Divide by total - EazyBI

Micha_qsp8sj

Hi!

 

I think I have a rather simple question, but still I can't seem to fix it. 

I made a pivot table and for each row there is a value. I also calculated the total of all those values together. I would like to divide the value of a row to the total of all rows. 

How do I do this?

 

Thanks in regards,

Janis Plume (eazyBI)

Hi Micha,

 

The exact formula might depend on the report you are creating. There is a generic approach for the calculation of the ratios to the total. The solution is by using the tuple with the "Default member" in it. Please, find here for more:
https://docs.eazybi.com/display/EAZYBI/Calculated+Members#CalculatedMembers-Tuples

For instance, if you have a measure "Your measure" showing values in the report by the members "Your dimension", the ratio calculation would be:

[Measures].[Your measure]

/

([Measures].[Your measure],

[Your dimension].DefaultMember)

 

Kindly,

Janis, eazyBI support