Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Can you give a try with dimentionality.
Dimensionality() returns the "level" of the cell in a pivot. Dimensionality() = 0 would be your grand total.
I have tried to use Dimensionality() but the total amount for one of the expression is still 0.
Is it working for other metrics?
Can I see your logic?
Thanks for your help.
I have managed to resolve this issue by using SUM(AGGR()).