Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
juanm_olondo
Contributor
Contributor

Partial sums in pivot table with several dimensions

Hi all,

I have a Pivot Table with 3 dimensions and 1 expression, as you can see in the picture below:

EjemploNO.png

I have activated the 'Show partial sums' option for both the food and the quality, but I don´t get the total quantities in good state and in bad state. I would like it to appear this way:

EjemploSI.png

Does anyone have any ideas of how I can get this? Thanks a lot!

2 Replies
alexandermorale
Contributor II
Contributor II

Activa Show partial sums para la dimension que tiene el encabezado "Mes"

juanm_olondo
Contributor
Contributor
Author

Pero eso hace que me salga la suma total de todos los meses abajo. Yo necesito que me saque un desglose de la suma de toda la comida buena y toda la comida mala (En la segunda tabla, CR =  Bad y HR = Good)