Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using below expression in one of the measures in pivot table, it is working fine in line entires but where as in subtotal it is not working properly. When we make selection of particular Dimension in the chart it work's fine. Any suggestions or advise on the below expression to work in any conditions.
( EXP(sum(Aggr(Log(1+Sum({$<CDate={">=$(=date(min(CDate)))<=$(=date(max(CDate)))"}>}Nr) /
FABS(Sum({$<CDate={">=$(=date(min(CDate)))<=$(=date(max(CDate)))"}>} Dr))),CDate)))-1 )
Thanks in advance
Hi, have you tried adding the other dimensions to the aggr?:
( EXP(sum(Aggr(Log(1+Sum({$<CDate={">=$(=date(min(CDate)))<=$(=date(max(CDate)))"}>}Nr) /
FABS(Sum({$<CDate={">=$(=date(min(CDate)))<=$(=date(max(CDate)))"}>} Dr))),CDate,[Dimension2],[Dimension3]...)))-1 )