Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
is there any chance to share the qvw for reference..!
¿hay alguna posibilidad de compartir el qvw para referencia ..!
Of course ! Here it is
What would be the expected output here? Would you be able to point that out in an Excel file may be?
Here is the expected output for April 2016, in an Excel file and in a qvw
I am not entirely sure how you reached to this calculation? Would you be able to point how the calculations are carried out?
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 🙂 |