Subtotals Pooled

[pgalvezt]

Hi,

I have a Pivot table that show different states over codes.

Actually I have to expand the dimension to show the diferent states but by Code.

Is there a way to show all states by family. Actually QlikView shows any result (only one result, I dont know how Qlikview Obtain the family result)

Present:

Familia: Accesorios

          Sin Cambios  7890.

Familia: Bombas         

Sobrestock ---> Compras<1año 787.655

What I want: By Family shows all states (and no only one)

Familia: Accesorios

Sin Cambios  7890.

Compras<1año 787.655

Entre 0 y 1 año ----> Inm 567.332

I attached an example,

Thanks,

[pgalvezt]

I put an example excel example test of What I want  to obtain.

Thanks!

[pgalvezt]

Any Help?

Thanks!

[#4]

If you make many selections, QlikView will show multiple families in your pivot table. See the attached qvw.

[pgalvezt]

Hi Jacob,

I know that but is not what I want. What I want is to have a subtotals pooled but only by family.

Like excel file...

Thanks!

[pgalvezt]

Anybody can help me with this?

Thanks!

[pgalvezt]

Anyone?

Thanks!