Avg refrence line in drill down group

[sat_tok52]

Hi Guru's,

I am using time(Year,Month,Week) drill down group dimension in my line chart , i want to set avg refrence line for each dimension.I tried different ways but i won't get exact result.

any help.

Thanks,

Sateesh.T

[MK_QSL]

Use Something like below

=Avg(TOTAL Aggr(SUM(Sales),$(='[' & GetCurrentField(TIME) & ']')))

or

=Avg(Aggr(SUM(Sales),$(='[' & GetCurrentField(TIME) & ']')))

Replace SUM(Sales) with your expression

TIME with your Drill Down Group Name

[sat_tok52]

Hi Manish,

Thanks for quick reply. it's not working.

[MK_QSL]

Provide sample data or sample app... Without that difficult to answer.