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 aggregationofrows.
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 aggregationofrows.
Regards,
Stefan