Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Am getting wrong grand total in pivot table.Previously it is good .
Thanks..
Could you explain how you got to -7.91% ? Or why do you call -0.012% wrong and -7.91% correct?
It seems to me that you are calculating something like a growth rate per dimension value.
IMHO, I would expect to see in the total line the growth rate calculated from the total aggregates, and not summing up or averaging the growth rate of the dimension lines.
Hence, -0.012% might be correct, at least I don't see an issue with using the expression total here instead of an aggregation-of-rows.
Regards,
Stefan
Can you provide more details? What is the expression you are using? What changed that the totals changed from what was expected? What is the expected output?
Hi,
Dimension : =if(KEY3='Appliances' or KEY3='Electronics' or KEY3='Furniture' or KEY3='Mattress' or KEY3='Office',KEY3)
Expression:1
(Sum({<DATE={'$(Vyesterday)'},Indicator={1}>}Dollars)
-
Sum ({<DATE={'$(vDayLY)'},Indicator={1}>} Dollars))
/
Sum ({<DATE={'$(vDayLY)'},Indicator={1}>} Dollars)
Expression:2
(Sum ({<DATE= {">=$(vMonthStart)<=$(Vyesterday)"},Indicator={1}>} Dollars)-Sum ({<DATE= {">=$(vMonthStartLY)<=$(vPrevYesterday)"},Indicator={1}>} Dollars))
/
Sum ({<DATE= {">=$(vMonthStartLY)<=$(vPrevYesterday)"},Indicator={1}>} Dollars)
Desired O/P:
2.00% |
-11.35% |
15.48% |
3.17% |
-17.21% |
Total =-7.91%
But it gives -0.012%.
Note: Didn't change any chart properties it working good since log time.
Thanks..
Can you try this:
Sum(Aggr((Sum ({<DATE= {">=$(vMonthStart)<=$(Vyesterday)"},Indicator={1}>} Dollars)-Sum ({<DATE= {">=$(vMonthStartLY)<=$(vPrevYesterday)"},Indicator={1}>} Dollars))
/
Sum ({<DATE= {">=$(vMonthStartLY)<=$(vPrevYesterday)"},Indicator={1}>} Dollars), KEY3))
Could you explain how you got to -7.91% ? Or why do you call -0.012% wrong and -7.91% correct?
It seems to me that you are calculating something like a growth rate per dimension value.
IMHO, I would expect to see in the total line the growth rate calculated from the total aggregates, and not summing up or averaging the growth rate of the dimension lines.
Hence, -0.012% might be correct, at least I don't see an issue with using the expression total here instead of an aggregation-of-rows.
Regards,
Stefan