Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm new to QlikSense and I'm trying to add a % of total column in a Pivot table I have created. I have used the Measures feature to do basic "sum" formulas (e.g., for sales), but not sure how to create a % Mix based on each rows value relative to the whole dataset.
Here's a very basic illustration of what I'm trying to do:
Product | Sales | % Mix |
A | $ 5 | 14% |
B | $ 10 | 29% |
C | $ 20 | 57% |
Something tells me the answer is to use Expressions, but I'm not familiar with the language/syntax
Thanks for your help!
Hi Dear john_henry
You can create a new measure with this formula Sum(Sales) / Sum(TOTAL Sales)
Test please and if works mark with the correct answer
that worked! thanks Marcos!
Hi Dear John
Wonderfull please mark the answer with "correct answer"
Thanks
how? I don't see a selection/action for that. Do I just reply with "correct answer?