Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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_TC | Flag_APC | Nb_SV | 0 | 1 | 2 | 3 | 4 | Plus de 5 |
1: < 500 hab. | 0 | 53,1% | 26,5% | 11,0% | 4,4% | 2,0% | 3,0% | |
1: < 500 hab. | 1 | 12,4% | 24,6% | 22,2% | 16,2% | 9,4% | 15,2% | |
2: 500 à 1000 hab. | 0 | 8,3% | 17,4% | 18,3% | 14,1% | 9,9% | 31,9% | |
2: 500 à 1000 hab. | 1 | 2,4% | 9,7% | 16,2% | 17,7% | 14,9% | 39,1% | |
Total | 30,1% | 18,3% | 10,8% | 6,7% | 4,6% | 29,4% |
Thanks for your help
Jean-Jacques
What about expression which would be summing all expresion?? It should give you back 100%
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