Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Energetic
Contributor III
Contributor III

Accumulate Sum

I'd like to make accumulated sum table using raw data table to Result.

How can I make accumulated table by month?

 

 Raw data
 JanFebMarApr
a10101010
b20202020
c30303030
d40404040

 

 Accumulated Result
 JanFebMarApr
a10203040
b20406080
c306090120
d4080120160
5 Replies
sunny_talwar

Are you trying to do this in the pivot table?

ThePeterK
Creator
Creator

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.

93/93
Energetic
Contributor III
Contributor III
Author

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)

 

Energetic
Contributor III
Contributor III
Author

In my case I have to use at least two values.

Could you show me how could you make this using combo chart?

ThePeterK
Creator
Creator

That's what I'm trying to do, too. I'm not having any luck.

93/93