Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total on Pivot Table

Hi ,

I calculated percentage in a pivot table with the expression

Count (Dc)/Count( All <Lib_TC , Flag_APC> Dc)

I have 3 dimensions : Lib_TC, Flag_APC & Nb_SV.

I'd like to add as a new column a total by row (= 100%)

This my table result

Lib_TCFlag_APCNb_SV01234Plus de 5
1: < 500 hab.053,1%26,5%11,0%4,4%2,0%3,0%
1: < 500 hab.112,4%24,6%22,2%16,2%9,4%15,2%
2: 500 à 1000 hab.08,3%17,4%18,3%14,1%9,9%31,9%
2: 500 à 1000 hab.12,4%9,7%16,2%17,7%14,9%39,1%
Total30,1%18,3%10,8%6,7%4,6%29,4%

Thanks for your help

Jean-Jacques

2 Replies
Not applicable
Author

What about expression which would be summing all expresion?? It should give you back 100%

Not applicable
Author

I just want to add a new column with (for this example) a total of 100% for each. More generally, how can I put a total in pivot-table. I just success only with one dimension.

Thanks for your help

JJ