Cumulative Sum

[sadiaasghar]

I need a help in finding cumulative value in a pivot table for the attached QVW file.

I wanted to find the cumulative values based on project levels.

RangeSum( Above(total Sum([Progress Description]),0,RowNo(total )) )

It's working fine for me. But it's treating all the projects as same. I am attaching qvw file for reference.

[alex00321]

Hi,

Could you check if attached file meets your requirement? Thanks!

[sadiaasghar]

Thanks Alex. It serves the purpose.

I have tons of different formulas for two fields Monthly Step Weight-age and Overall Weight-age for every record based on the project. And i have to calculate multiple Cumulative for the formulas. So should i evaluate them in load script or in expression. I am attaching Excel Sheet for reference and can you please look into my formulas too. 

[alex00321]

I would suggest you put the calculation in the back end. So it will reduce the potential performance issue in the front. Thanks!