topic Participation by column. in App Development

Participation by column.

msantarone — Wed, 23 Sep 2020 20:27:18 GMT

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.

Re: Participation by column.

Kushal_Chawda — Wed, 23 Sep 2020 21:22:29 GMT

@msantarone try below

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

Re: Participation by column.

msantarone — Thu, 24 Sep 2020 16:00:06 GMT

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

Re: Participation by column.

Kushal_Chawda — Thu, 24 Sep 2020 16:28:37 GMT

@msantarone try to add first dimension as well

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