topic Re: Create a % contribution variable in App Development

Create a % contribution variable

AB108 — Mon, 06 Feb 2023 20:16:48 GMT

Hi,

Attaching sample data.

If you look at the Pivot table, I want to create "% Contribution in Sales" as a variable. This should be dynamic based on the selections of year, prod, month.

I want to use this variable as part of expressions in other charts.

I tried a few expressions but its not working

Thanks for your help.

Re: Create a % contribution variable

E_Røse — Mon, 06 Feb 2023 21:52:25 GMT

Try

=Sum(total {<Region={'p'}>}[Sales])/Sum(total [Sales])

Re: Create a % contribution variable

AB108 — Mon, 06 Feb 2023 22:33:20 GMT

@E_Røse

Thanks for the response. What I am looking for is to get it dynamically for different regions.

Re: Create a % contribution variable

E_Røse — Mon, 06 Feb 2023 23:09:13 GMT

@AB108, it is dynamic, so can you be more specific?

I if you add the expression I wrote before, to the variable editor,

this is what you get:

If you want it for all regions in the same variable, you could do like this: