How to force null value into pivot table line

[#1]

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

[sunny_talwar]

Awesome

I am glad it worked.

Best,

Sunny