pivot table total column

[sr_qlikview]

i have 4 dimenions  ex: A,B,C,D, and 5 dimension is Month end (date) and expression is sum(sales)

My month end goes horizontal (means each monthend date as column).

Now if want a total COLUMN which is sum of sales for A,B,C,D ignoring months dimension in other words total of all months

[sr_qlikview]

can someone help

[Sokkorn]

Hi sr_qlikview,

It a little bit confused your requirement. Can you manipulate data in Excel what is your source and what is you looking for then post here.

Regards,

Sokkorn

[sr_qlikview]

Dim1	Dim2	Dim3	3/1/2013	3/8/2013	3/15/2013	Total
A	a1	aa1	1	0	3	4
A	a2	aa2	2	2	4	8
A	a2	aa3	0	2	5	7
A	a3	aa4	6	4	2	12
B	b1	bb1	2	4	2	8
B	b2	bb2	2	6	7	15

i have 4 dimensions, dim1,dim2,dim3,weekendate

my expression is sum(sales)

total is nothing but sum of sales for all weeks