topic Re: Split Total in Pivot Table in QlikView

Split Total in Pivot Table

Wed, 11 Mar 2015 21:14:32 GMT

Hello,

I'm facing with this situation:

I have a pivot table with 5 dimensions, and it looks like this one:

		City	City1				Total
		Month	1		2		Total
		Product	A	B	A	B
LineGroup	Line
Group1	Line1		100	200	300	400	1000
	Line2		100	300	500	700	1600
	Total		200	500	800	1100	2600
….

I made a total for the City dimension, but I want to split this total based on product groups, like that:

		City	City1				Total
		Month	1		2		Total
		Product	A	B	A	B	A	B	Total
LineGroup	Line
Group1	Line1		100	200	300	400	400	600	1000
	Line2		100	300	500	700	600	1000	1600
	Total		200	500	800	1100	1000	1600	2600
….

Do you have any suggestions to solve this problem?

Thank you!

Re: Split Total in Pivot Table

Thu, 12 Mar 2015 10:37:13 GMT

Hi,

you will put 5 dimensions fields in dimension tab and in expression tab put some expressions(sum(fields)). After that you will drag that fields how to you need. like this

Re: Split Total in Pivot Table

Thu, 12 Mar 2015 11:16:53 GMT

I already made this, I created a pivot table and it looks like the first table from my post, but I want to add these yellow columns to the total. I want a total based on product group. I don't know how to do that.