Calculating average on time drill down

[#1]

Hi Experts,

I have created drill down menu for Time(Year-Month-Day-Minute).I have values available for days of month.

ex. for month-5

day    value

1        a

2        b

3        c

..        ..

31      d

For Month value, I want to calculate average of day values.

for month 5, monthVal= avg(a+b+c+...d)

So when i drill up from day to month, it will show me average value of all days i.e monthVal of that particular month.

Please help

Thank You

[#2 · Accepted solution]

Hi,

Try like this

In expression

IF(GetCurrentField(DrillDownGroupName)='Month',Avg(Value),'Default Calculation')

Hope it helps you

[#3]

Hi,

This is not give a proper solution then please post your sample file

[#4]

hey Thanks, Its working

[v_iyyappan]

Hi,

If u got correct solution means please closed the thread and give mark. because its motivate for us.

[#6]

If its working then mark it as correct answer