Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

Percentage in a pivot table


I have a pivot table with 2 columns: Item and Amount. I'd need to know if there is the possibility to add a new column %, with the formula indicated in the image. Exemple: Revenue product A/ Total Revenue, Cost product A/Revenue product A, ect.Ex_table.PNG

1 Reply

Re: Percentage in a pivot table

Try this

Aggr(Sum(Amount)/Sum(TOTAL <[Item Category]> Amount), [Item Category], Item)

Where Item Category is a field which will have Revenue and Cost as values

Community Browser