Repeated values in rows and subtotals
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
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.