Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
On the Dimensions tab check "Supress when value is null" on the Customer Dimension.
Kind Regards
Footsie
On the Dimensions tab check "Supress when value is null" on the Customer Dimension.
Kind Regards
Footsie
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!