Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Hide duplicate Rows
minsc87
<p>Hello, i have a table that produces duplicate rows as in the attachment 1.<br>
Can I hide the duplicates as in the attachment 2?</p>
Find more posts tagged with
Comments
micajblock
<p>How are you getting the data? Easiest is to change the query so you only get non duplicate data.</p>
minsc87
<p>Thanks for reply, but the dataset is also used for another table where there are other details by which it does not duplicate.</p>
shamo
<p>Group, add running count aggregation on group and hide based on aggregation > 1. Hope it helps</p>
minsc87
<blockquote class="ipsBlockquote" data-author="shamo" data-cid="147476" data-time="1493306906">
<div>
<p>Group, add running count aggregation on group and hide based on aggregation > 1. Hope it helps</p>
</div>
</blockquote>
<p>
Thanks, it works</p>
minsc87
<p>Good morning, excuse me yet, but can I set the color of the alternate lines? row.__rownum does not work because there are hidden rows.<br><br>
Thanks</p>
shamo
<p>I just went back to look at your picture. This is what you have to do. Instead of using aggregation to hide at the detail level, move the datasets in the detail to the group row then do this. First put a running count aggregation on the group then use that aggregation to replace row.__rownum on the group row. Hope it helps</p>
