Hi,
I have created a table in QlikSense as shown below:
Product | Sub Product | Day | Date | Sales |
A | AA | Tuesday | 17/9/2019 | 100 |
A | AB | Wednesday | 30/9/2019 | 200 |
B | AA | Tuesday | 17/9/2019 | 150 |
B | AB | Wedensday | 30/9/2019 | 150 |
I wish to add a column in the table which would calculate the cumulative sum of sales for each product, sub product combination. The resulting table should be as shown below:
Product | Sub Product | Day | Date | Sales | **bleep** Sales |
A | AA | Tuesday | 17/9/2019 | 100 | 100 |
A | AB | Wednesday | 30/9/2019 | 200 | 300 |
B | AA | Tuesday | 17/9/2019 | 150 | 150 |
B | AB | Wedensday | 30/9/2019 | 150 | 300 |
Can someone please help me with what expression needs to be written in **bleep** Sales column?
Thanks.