Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
hI tncholiver,
I would like to receive the totals of each row and each column as I draw in the Goal.Jpg (In yellow)