Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
That is Superb and worked first time. Thank you, I really appreciate you help.