Participation by column.

[msantarone]

Hello, I need to obtain the % participation of the Premio measure in each of the columns per month (not the Total Premio but the Premio of the month).

In the measure "% Dv Premio/ Premio" I use the following formula: Sum (Premio) / Aggr (Sum (Premio), PeriodId) - but it only works well for Mendoza province. Why not go for all?

See attached.

[Kushal_Chawda]

@msantarone  try below

Sum (Premio) / Sum (total <PeriodId>Premio)

[msantarone]

Thanks, but it works the same as column "% Dv Premio / Total Premio"

[Kushal_Chawda]

@msantarone  try to add first dimension as well

Sum (Premio) / Sum (total <Dim1,PeriodId>Premio)