Total value in a Pivot table by Set Analysis

[#1]

Hi everyone,

I havea table like this

Country	Month	Sales
Spain	1	45
Germany	1	32
Italy	1	22
France	1	10
Spain	2	12
Germany	2	34
Italy	2	21
France	2	11
Spain	3	8
Germany	3	32
Italy	3	12
France	3	10

and I´d like to made a Pivot Table with Country and Month like Dimensions and SUM(Sales) in Expression, it is easy but also I´d like to add another Expression where I could see the Total Sales of every Month in every row for every Country.

I mean, I´d like to get something like this.

For Example, if Month='1' the Total Sales is '109' so I´d like to get this value an put it in a new column for every row.

Month	1	1	2	2	3	3
Country	Sales	Total Sales	Sales	Total Sales	Sales	Total Sales
France	10	109	11	78	10	62
Germany	32	109	34	78	32	62
Italy	22	109	21	78	12	62
Spain	45	109	12	78	8	62
Total	109	109	78	78	62	62

Maybe it could be possible to do by Set Analysis in the new column, but the problem is that in my pivot table has two dimensions (Country and Month) and I have to try to avoid the Country Dimension to get the right value isn,t it?

Thanks a lot

[#2 · Accepted solution]

Hi Eduardo,

In the second expression "Total Sales", you try this code.

Sum(Total <Month> Sales)

[#3]

Thanks a lot !!!