Forum Discussion
Cumulative total
I'm sorry but it's not at all clear what you mean. Again, you only have one day shown, and your calculation of the totals for that day are accurate. You clearly have data someplace else that is incorporated into the Monthly figures shows in Columns H and I. But you total them accurately as well.
I'm sure what you're describing and wanting is clear to you. I'm only saying that I see nothing else amiss in what you've provided in your CRM sample file.
I want to reiterate what I said at the start--this only shows one day, so there are no other days to accumulate in any kind of cumulative total. You MUST have some other data somewhere in a more comprehensive set of information on the sales calls made by your sales reps. Where is the rest of the data that is to be totaled on a cumulative basis?
Let's me try to describe in little simple way
I enter the data every data in 2 columns changing the date and what I want is to get the data accumulated in the monthly column automatically, and then so to sum up if I put today's data... The Cumulative should have today's plus yesterday data
Or if u can suggest and better or other format to have cumulative total for 5 sales person