Hide total in pivot

[#1]

Hi,

i´ve got a pivot with the sum of sales, sum of amount and with both of them i invoice the single price. It doesn´t make sense to show the single-price in total, so i want to hide it. I´ve added an if-clause for it:

=IF(ISNULL(RowNo()) OR RowNo()=0,'',Sales/Amount)

It works fine, but now all customers, also these ones without any sales where shown. Without my if-clause they´re hidden:

Has anyone an idea how to handle it? Perhaps there´s a different solution without if-clauses for hiding the total in pivot.

I´ve attache my app for testing.

Ragards.

[#2 · Accepted solution]

On the Dimensions tab check "Supress when value is null" on the Customer Dimension.

Kind Regards

Footsie

[#3]

Omg, at least it was so easy!

I´ve tried everything and the function "Supress when value is null", too, but not for all dimensions.

Sometimes you miss the wood for the trees.

Thanks!