Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'd like to make accumulated sum table using raw data table to Result.
How can I make accumulated table by month?
Raw data | ||||
Jan | Feb | Mar | Apr | |
a | 10 | 10 | 10 | 10 |
b | 20 | 20 | 20 | 20 |
c | 30 | 30 | 30 | 30 |
d | 40 | 40 | 40 | 40 |
Accumulated Result | ||||
Jan | Feb | Mar | Apr | |
a | 10 | 20 | 30 | 40 |
b | 20 | 40 | 60 | 80 |
c | 30 | 60 | 90 | 120 |
d | 40 | 80 | 120 | 160 |
Are you trying to do this in the pivot table?
I'm trying to do something similar, but in a combo chart. Writing a new set expression for each possible dimension combination seems like the wrong way to do this. It's pretty easy in Qlikview.
I'm trying to make this with pivot table but table is possible.
Actually, I'd like to make monthly accumulated table using three columns(Plan, revised plan, Actual result)
In my case I have to use at least two values.
Could you show me how could you make this using combo chart?
That's what I'm trying to do, too. I'm not having any luck.