Split Total in Pivot Table

[#1]

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

[#2]

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

[#3]

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.