Columns subtotals in table

[#1]

Hello

I would like to have a pivot table like this:

	Product A				Product B				Product C				SubTotal	SubTotal
	IN	OUT			IN	OUT			IN	OUT			Product A	Product B + C
		PT	ES	Others		PT	ES	Others		PT	ES	Others
Jan	8	2	1	4	4	2	1	1	4	2	1	1	15	16
Feb	7	4	3	5	1	2	2		1	2	2		19	10
Mar	9	2	2	2	2	1	1	1	2	1	1	1	13	10
SubTotal 1		8	6	11		5	4	2		5	4	2
SubTotal 2	24	25			7	11			7	11
Total	49				18				18				49	36

The dimensions are "Month", "Products", "IN/OUT" and "Countries" and the respective quantities are given by a sum expression.

For now I've managed to do the majority of the table but i'm lacking the experience to do lines and columns in red.

How can I do the SubTotals columns and lines that I've mencioned above?

Thanks in advance

[Anonymous]

Presentation sheet of charts properties, select the dimension in the top left and tick the Show Partial sums checkbox below it. Looks like you'd need to do this for the "IN/OUT" and "Countries" dimensions.

Jonathan

[#3]

Thanks jonbroughavone.

I've tried to do that but it creates the total line by line and not column by column which means I end up getting:

	Product A						Product B
	IN	OUT				Total	IN	OUT				Total
		PT	ES	Others	Total			PT	ES	Others	Total
Jan	8	2	1	4	7	15	4	2	1	1	4	8
Feb	7	4	3	5	12	19	1	2	2		4	5
Mar	9	2	2	2	6	15	2	1	1	1	3	5
Total	24	8	6	11	25	49	7	5	4	2	11	19

Which is not what I actually want. Is there any flag or option that I have to enable to do what I pretend?

[Anonymous]

Not that I know of.

Jonathan