Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try like this
In expression
IF(GetCurrentField(DrillDownGroupName)='Month',Avg(Value),'Default Calculation')
Hope it helps you
Hi,
Try like this
In expression
IF(GetCurrentField(DrillDownGroupName)='Month',Avg(Value),'Default Calculation')
Hope it helps you
Hi,
This is not give a proper solution then please post your sample file
hey Thanks, Its working
Hi,
If u got correct solution means please closed the thread and give mark. because its motivate for us.
If its working then mark it as correct answer