Pivot table %

[#1]

Hi everyone,

I need your help with pivot table calculations, especially percentages.

In the pivot table below, i need to calculate percentages for the "Libellé direction régionale" and every "Libellé groupe" in it.

The thing is the expression i used only works for the "Libellé direction régionale" and i can't figure out why.

Do you guys have an idea on how i should proceed ?

Thank you for your help.

[Anil_Babu_Samineni]

is there any chance to share the qvw for reference..!

¿hay alguna posibilidad de compartir el qvw para referencia ..!

[#3]

Of course ! Here it is

[sunny_talwar]

What would be the expected output here? Would you be able to point that out in an Excel file may be?

[#5]

Here is the expected output for April 2016, in an Excel file and in a qvw

[sunny_talwar]

I am not entirely sure how you reached to this calculation? Would you be able to point how the calculations are carried out?

[#7]

The expression "Taux de mise en conformité" allows me to follow the "Clauses Ko restantes" 's progression since April 2015. This is how it is calculated :

(Clauses KO restantes April 2015 - Clauses KO restantes April 2016) / Clauses KO restantes April 2015

I hope this is clear enough for you, my english is not that good, sorry 🙂