Expression Subtotal

[manojkulkarni]

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

[rubenmarin]

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 )