Partial Sum Wrong For One of the Expression with 2 Dimensions and 2 Expressions in Pivot Table

[MCFH93]

Hi, I have the Pivot table below with 2 Dimension and 2 Expression but the Partial Sum for one of the expression is 0. Below are the Dimension and Expression formula used in this table. Kindly advise. Thank you.

Dimension

(1) Source

(2) FY Year

Expression

(1) tCO₂e = ROUND((SUM(VALUE) * CONVERSION_FACTOR) / 1000)

(2) MWh = ROUND((SUM(SM_VALUE) * 10.55) / 1000)

[anat]

Can you give a try with dimentionality. 

Dimensionality() returns the "level" of the cell in a pivot. Dimensionality() = 0 would be your grand total. 

[MCFH93]

I have tried to use Dimensionality() but the total amount for one of the expression is still 0.

[anat]

Is it working for other metrics? 

Can I see your logic? 

[MCFH93]

Thanks for your help.

I have managed to resolve this issue by using SUM(AGGR()).