Suppress duplicates is suppressing data on all rows after group by.

Migrateduser

<p>Hi </p>
<p> </p>
<p>Please find the attached Sample report. I have three columns namely 'col1', 'col2' and 'col3'. I have applied Group By on 'col1' and 'col2'. Also applied "Suppress Duplicates" on 'col2'. As you can see in the attached report that it is suppressing all data under 'col2' for other Groups of 'col1' also. I want the 'col2' data for each 'col1' group one time as in picture below. Any suggestions please.</p>
<p> </p>

<div>Column 1</div>


<div>Column 2</div>


<div style="text-align:center;">Column 3</div>


<div>Count</div>


<div style="text-align:center;">AUD</div>


<div>ABXD</div>


<div>Master Card</div>


<div style="text-align:center;">30</div>


 

 

<div>Visa</div>


<div style="text-align:center;">20</div>


 

<div style="text-align:right;">Total ABXD</div>


 

<div style="text-align:left;">50</div>


<div style="text-align:right;">Grand Total AUD</div>


 

 

<div style="text-align:left;">50</div>


<div style="text-align:center;">CAD</div>


ABXD

<div>Unknown</div>


<div style="text-align:center;">11</div>


 

 

<div>Master Card</div>


<div style="text-align:center;">25</div>


 

 

<div>Amex</div>


<div style="text-align:center;">35</div>


 

<div style="text-align:right;">Total ABXD</div>


 

<div style="text-align:left;">71</div>


<div style="text-align:right;">Grand Total CAD</div>


 

 

<div style="text-align:left;">71</div>


<div style="text-align:center;">Rs.</div>


ABXD

<div>Master Card</div>


<div style="text-align:center;">10</div>


 

 

<div>Visa</div>


<div style="text-align:center;">20</div>


 

 

<div>Unknown</div>


<div style="text-align:center;">14</div>


 

<div style="text-align:right;">Total ABXD</div>


 

<div style="text-align:left;">44</div>


<div style="text-align:right;">Grand Total Rs.</div>


 

 

<div style="text-align:left;">44</div>


<div style="text-align:center;">USD</div>


ABXD

<div>Master Card</div>


<div style="text-align:center;">70</div>


 

 

<div>Visa</div>


<div style="text-align:center;">12</div>


 

 

<div>Visa</div>


<div style="text-align:center;">50</div>


 

<div style="text-align:right;">Total ABXD</div>


 

<div style="text-align:left;">132</div>


<div style="text-align:right;">Grand Total USD</div>


 

 

<div style="text-align:left;">132</div>

<p> </p>