Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
sijojoseph22
Creator II
Creator II

Sum Total based on the left columns

Hi All,

I need to create a pivot table by adding the sum of months in a accumulative from the left side columns in a pivot table.

Attached the data we are having

Attached the data we are expecting.

Attached the qvw with raw data

Thanks,

Sijo

1 Solution

Accepted Solutions
sunny_talwar

Try this expression:

=RangeSum(Before(Sum(GWP), 0, ColumnNo()))


Capture.PNG

View solution in original post

2 Replies
sunny_talwar

Try this expression:

=RangeSum(Before(Sum(GWP), 0, ColumnNo()))


Capture.PNG

sijojoseph22
Creator II
Creator II
Author

Thanks Sunny, it is working for me. I will try this in my real dashboard.