Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Repeated values in rows and subtotals

Hello everyone,

In my table I have created a subtotal to sum some kind of records, but some recordsĀ  are alone , so these records are being show at the row for it self and at the subtotal, I wonder if I can hide those lines (records) and then don't repeat the same value twice.

I have attached a pic of the issue

Many thanks

Former Member
Former Member replied

Blz !

Create a measure variable to count the lines like [cont] = Count([Product]) In ([Product)

Create a conditional formatting for cont = 1 that makes the font color white and no borders, set also the borders to none.

Apply this formatting rule to each column of your table.



1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question