Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this expression:
=RangeSum(Before(Sum(GWP), 0, ColumnNo()))
Thanks Sunny, it is working for me. I will try this in my real dashboard.