Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi ,
i have group with year->month , when i drill to month level i need to see for each month the relative part of the whole year ,for example , if i have at the year level the values :
and drill to month level , Expect see for each month the relative part (%) of the whole year (2017) :
according to the months values :
BUT instead i see for each month the relative part of the whole ALL YEARS from 1997 ... :
I know that its because i am using TOTAL in the expresion :
sum ( A_VALUE ) / sum ( TOTAL <A_YEAR> A_VALUE ) * 100
does anybody know the right way to solve this problem ? THANKS
here some data.
May be this
=If($(vGroup) = 'year', Sum(value), Aggr(Sum(value)/Sum(TOTAL <year> value) * 100, year, year_month_desc))
Where vGroup is GetCurrentField([Group])
HI Sunny , big help !! as always - thanks