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
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.
You can use dimensionality function to control the visibility of the totals
Re: Dimensionality Function and its types
Retrieving data ...