topic Re: Grouped Total split on Pivot Table in QlikView

Grouped Total split on Pivot Table

Tue, 19 Mar 2013 13:11:30 GMT

I have a pivot table with Central and Direct set up as groupings for different methods for each area.

I have calculated the mix per group and added the Total section to the end of the pivot.

However I am wanting to have the mix on the total block split into Central and Direct mix as per the pivot table below

- however I am unable to figure this out in QV as it appears that as its a total I can only show the mix once as per the grouped sectins for Direct/Central

Please can anyone help with this.

Many Thanks

Type	Central			Direct			Total
Measure	sales	qty	mix	sales	qty	mix	sales	qty	Central Mix	Direct Mix
Total	300	15	13.64%	300	95	86.36%	600	110	13.64%	86.36%
Area 1	100	5	50%	200	5	50%	300	10	50.00%	50.00%
Area 2	200	10	10%	100	90	90	300	100	10.00%	90.00%

Re: Grouped Total split on Pivot Table

Gysbert_Wassenaar — Tue, 19 Mar 2013 13:35:53 GMT

That's correct. You can't do this in a pivot table. You could do it with a straight table. But that has the obvious disadvantage that you'll have to create more expressions since you can't use Type as a horizontal dimension.

Re: Grouped Total split on Pivot Table

Tue, 19 Mar 2013 14:03:25 GMT

Ok thankyou

Re: Grouped Total split on Pivot Table

Tue, 19 Mar 2013 14:12:18 GMT

I have decided to go with two pivot tables placed side by side in a container. One with the detail and the other with the totals - including the mix split. Thanks for your help and confirmation this cant be done