Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is it possible to use indent pivot table without subtotals?
Thanks
Gabor
You mean that you do want to see the row which shows the subtotal, but not see any values in there (just blank cells)??
I mean I have two dimensions next to each other. I have to use indent mode, but I don't want to see totals on Dimension1 level only just blank cells.
Do you have any idea?
Thanks you
Gabor
Is this your goal?
If yes then you can use this expression:
=If(Dimensionality() = 1, ' ', If(Dimensionality() = 2, yourExpression))
Attaching a sample for your reference.
HTH
Best,
Sunny
Thank you Sunindia!
Thats perfect! That works as I expect!
Awesome I am glad we were able to resolve the issue fairly quickly.
Best,
Sunny
Please, check the correct answer.
thank you