Hello
I have an expression that can take in three types of indicators
-CUM : which is the sum on a selected period of a value
-FDP: which has to return the maximum of the value on a selected period
-MOY: which has to return the average of the value on a selected period
the indicators are presented in a hierarchy, there for, for each indicator (on every level) there is a precalculcated value.
the periods are also in a hyerarchies. we decided to split the values by indicators and period so that we have the right value, but the problem happens when we reduce the columns of the pivot table (the dimension [Indicateur niveau] or [PERIODE_DESC]) it sums on a all the columns which it shouldn't.
for example
in image 1 the the indicator is split by period , so it gives the right values,
but if we reduce Encours Bilan FDP ( which is an indicator of the type 'FDP'), it gives the sum on the months and the trimester which is wrong
Thank you in advance for your help