Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sadiaasghar
Contributor
Contributor

Cumulative Sum

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.

 

3 Replies
alex00321
Creator II
Creator II

Hi,

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

sadiaasghar
Contributor
Contributor
Author

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
Creator II
Creator II

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