Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try
=Sum(total {<Region={'p'}>}[Sales])/Sum(total [Sales])
Thanks for the response. What I am looking for is to get it dynamically for different regions.
@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: