Forum Discussion

Bebs's avatar
Bebs
Icon for Helper II rankHelper II
3 years ago

Is it possible to customize a total in Matrix table to avoid measures creation ?

Hello,

my customer wants to have a matrix table on budget with that kind of columns :

Quarter 2, Quarter 3, Quarter 4, Total Quarter 2 => Quarter 4, for each line % of the total

I'd like to avoid to create a measure for each column, is there a way to avoid that ? (The number of quarter will depend of the version of the budget).

 

 

If I use a quarter field as a column of the table, I've most of it  :  I will simply and dynamically have a value for each quarter , then the total of the columns will be the total of all quarter.  I just need additional column to add the % of each line of the total ; is there a way to get it ?

 

A idea may be to add one more total column by adding a field in column (exemple : year) with just one value for all the table : in that way I get another total ; then is there a way to change the calculation of the total to create the % of each line calculation ?

 

Best regards