Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can someone help
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
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