Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)