Sum Total based on the left columns

[sijojoseph22]

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

[sunny_talwar · Accepted solution]

Try this expression:

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

[sijojoseph22]

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