Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'd like to ask a little help.
I have a pivot chart like this one below:
Product | MeasureA | MeasureB |
---|---|---|
A Product | 2 | 3 |
B Product | 3 | 5 |
C Product | 4 | 6 |
Total | 9 | - |
MeasureA and MeasureB are sum(<set analysis>Volume) expressions.
I have to show null value in MeasureB column for total.
Does somebody know a working solution for this? I tried with Product -= {''Total'} in set analysis but it shows zero value in the total cell, but I need null value.
Thank you
Gabor
Awesome
I am glad it worked.
Best,
Sunny