Skip to Content
0
Former Member
Jul 12, 2013 at 06:25 AM

How to get column wise total in crosstab webi

1734 Views

Hi All,

I have a crosstab in webi as below with Store Name as the dimension and a variable 'sum of points' for each store. Break is applied on Store.

The table looks like below. I would like to know how to get the sum of the variable 'Sum of Points' column wise

Store Week 1 Week Sum Week 2 Week sum .....

a 1 0 1 1 1 1 1 6 1 0 1 0 1 1 0 4 ......

b 0 0 0 1 1 1 0 3 0 1 1 0 1 1 0 4

c 0 1 0 0 1 0 0 2 1 1 0 1 0 1 0 4 .....

d 0 0 0 1 1 1 1 4 1 1 0 1 1 0 0 4 ........

e 0 0 0 0 0 1 0 1 1 0 1 0 1 0 0 3 ......

Sum 1 1 1 3 4 3 2 4 3 3 2 4 3 0 ...........

I would like to see the 'Sum' row as above i.e Sum of Points for a particular Date in a Week in all the stores. I have tried using Sum([Sum of Points] ForEach([Store Name]) and Sum([Sum of Points] In([Store Name]), however it is not yielding me the desired results.

Could anyone let me know how to achieve this in Webi XI3.1 SP3

Thank you

Syed