Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

to calculate the percentage with the partial sum

hello,

i have a problem : i have calculate a percentage and the total must be added in the column percentage.

pivot_table.PNG

in this column should go to the following calculation:

in the first row: 76.470 / 95374

in the second: 18904 /95374

....

I attach the example that I represent.

thank Valentina

3 Replies
SunilChauhan
Champion II
Champion II

Sum(fildname which contain  76.470)/sum(Total <SedeMercePresente> fildname which contain  76.470)

Sunil Chauhan
Not applicable
Author

hello,

I have tried but unsuccessfully.

I have attached an example.



Not applicable
Author

Does this work?

Regards,

Kiran.