Hi I am using running totals in my pivot table. We are tracking how many mobile devices are active. I use it for weekly reports. I don't copy all users each week - I simply add the new ones. For example, on July 26 we had 1,000 users (this is the first week we started tracking everyone that had registered in 2013). Then an additional 200 for Aug 2 (total 1,200), an additional 300 for Aug 9 (total 1,500), an additional 500 for Aug 16 (total 2,000). The question becomes - since I am not copying all users for each week - it would eventually become too many rows - how do I show when a user leaves the company? Specifically, reducing the week they left by one user. Versus deleting their name from the week they became active and having the numbers for that week - say Aug 2nd go down by one. I would really want it to be showing as one less in the Aug 23rd report.
Thanks.
Gayenell
Bookmarks