Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

juanm_olondo
New 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!

Tags (2)
2 Replies
alexandermorale
New Contributor II

Re: Partial sums in pivot table with several dimensions

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

juanm_olondo
New Contributor

Re: Partial sums in pivot table with several dimensions

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)

Community Browser