“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Calculating cumulative sum and % in pivot tables

Solved by X. S. in 21 mins

Hi I have a column which gives me daily temperatures since 1975 till 2017. I am trying to calculate the cumulative deviation of temperature and trigger a payout if the cumulative is greater than 150 degrees celcius or 250 degrees. The deviation is based on 'triggers' so if the daily max temp is 30 and the trigger is 31 then the cumulative deviation is -1 and so on. I have a set of 6 triggers - 31, 33 35.5 38 39.5 and 39. How can I calculate this on excel?

Solved by O. C. in 13 mins

I want to show cumulative on pivot considering sales, in transit and on hand week on week. Not showing cumulative of sales just overall total considering weekly entries such as in transit and sales etc

Solved by O. J. in 26 mins

Trying to calculate cumulative interest for the year and find various tax rates.

Solved by B. B. in 18 mins

1 have a problem with 9 distinct steps, each of which can be correct or incorrect. What is the formula to use to determine the cumulative percentage of all steps being correct?

Solved by A. C. in 27 mins