Repeated values in rows and subtotals

[Former Member]

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 · Accepted solution]

SAlve Bruno,

I think that you can try hiding the lines where the count of them is 1. In this way, only the break footer will be shown.

ABraços,

ROgerio

[Former Member · Accepted solution]

E ae Rogério, blz?

I think I've got your point but I dont have any idea how to do its formula.
Can you help me any further?

Obrigado

[Former Member · Accepted solution]

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.

Abs,

Rogerio

[Former Member · Accepted solution]

Thank you Rogerio,
it did worked for me!!

[Former Member · Accepted solution]

Blz !!!

Abs

[sateesh_kumar1]

Hi Bruno,

for totals , write formula =count([Product])>1;sum([Measure])

apply auto height.It'll not be exactly like hiding ,but we are making measure as null in cases where count is 1.