Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I don't want to show all totals in a pivot table.
There are 3 expressions (all of them are SUM calculations).
I want to show the totals for 2 dimensions.
See example below
Expression 1 (SUM x) | Expression 2 (SUM y) | Expression 3 (SUM z) |
---|---|---|
10 | 20 | 30 |
40 | 50 | 60 |
Total: 50 | EMPTY! | Total: 90 |
Hi
Try like this, in second expression
=if(RowNo() = 0 or isnull(rowno()) , '' , Sum(y))
hope it helps
The totals for expression 2 are gone.
But now all null lines in the pivot table appears.
"Suppress When Value Is Null" = TRUE
Hi I needed to do the same and I think changing the code provided to:
=if(RowNo() = 0 or isnull(rowno()) , null() , Sum(y))
will resolve the issue with null lines showing.
Thanks
You can use dimensionality function to control the visibility of the totals