Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Manish,
Thanks for quick reply. it's not working.
Provide sample data or sample app... Without that difficult to answer.