Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a pivot table that has few columns. I added the total column that by default adds all the columns.
But i want to stop it to add for one column.
you can see the example below.
I have to stop the addition for Block Stock (the last line).
Thanks
Aman
Hi,
maybe try with
If(Dimensionality()<>0 or yourdimension<>the value that you want without total, yourexpression, ' ')
Thanks for the reply, I tried this solution but in this case all the columns go blank. I just want Totals to go Blank