Pivot table totals

[shahafei2]

Hi all,

I have a pivot table  with 3 dimensions as describe in the "Pivot" picture

The values of the expression are calculated by the following if

if(Comp='A' and Process='R',Value/$(v_A_H_R)*$(v_Volatility_R),
if(Comp='B' and Process='R',Value/$(v_B_H_R)*$(v_Volatility_R),
if(Comp='A' and Process='P',Value/$(v_A_H_P)*$(v_Volatility_P),

if(Comp='B' and Process='P',Value/$(v_B_H_P)*$(v_Volatility_P),
if(Comp='A' and Process='D',Value/$(v_A_H_D)*$(v_Volatility_D),
if(Comp='B' and Process='D',Value/$(v_B_H_D)*$(v_Volatility_D)
)))))))

When I checked the "Show Partial Sums"

For the "Description" and "Comp" Dimensions

I received  "-" (Nulls) for the Totals

I also attached the data file

There is a way to calculate and present the totals as I did in the Goal picture?

[tincholiver]

I do not know if I understand your problem well;
the totals are null because there are no values for those dimensions, what number do you hope to achieve?
Did you try putting sum at the beginning of the expression?

[shahafei2]

hI tncholiver,

I would like to receive the totals of each row and each column as I draw in the Goal.Jpg   (In yellow)