Pivot Table calculated value % of Total

[Hobbs13]

I have a pivot table in my Qlik Sense app, with a dimension of Products and a measure that is the Sum of Invoice Amounts/Values for each product. I have also selected Show Totals.

I want to add a calculated measure that is what percent each invoice amount is, of the total invoice amount, as below.  The below is a mock-up in Excel of what I am trying to achieve in Qlik Sense.

Products	Sum of Invoice Amounts/Values	% of Total
Beans	10,890.23	15%
Apples	21,463.01	29%
Grapes	5,899.55	8%
Oranges	34,756.89	48%
Total	73,009.68	100%

If someone could help I'd really appreciate it. Thanks in advance.

[rubenmarin · Accepted solution]

Hi, if the field that stores the amount is called InvoiceAmount you can use: 

Sum(InvoiceAmount)/Sum(TOTAL InvoiceAmount)

Change the field name with your current field and you'll get the percentage.

[Hobbs13]

That is Superb and worked first time. Thank you, I really appreciate you help.