How do I create calculations in QlikSense?

[john_henry]

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!

[marcos_herrera]

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

[john_henry]

that worked!  thanks Marcos!

[marcos_herrera]

Hi Dear  John

Wonderfull please mark the answer with "correct answer"

Thanks

[john_henry]

how?  I don't see a selection/action for that.  Do I just reply with "correct answer?