How to find part (%) of the month sum from all year sum in group (Cycle) ?

[yanivvl0]

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

[yanivvl0]

here some data.

[sunny_talwar · Accepted solution]

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])

[yanivvl0]

HI Sunny , big help !!   as always - thanks