Forum Discussion
How to create charts or comparisons from last years monthly spreadsheet totals to this years totals
I create an excel spreadsheet last year with ongoing weekly totals of sales and leads that came in to our business. We are wanting to compare those numbers and totals to this year to see how much pro...
Hello,
Yes you can measure the progress and growth of your business based on the data analyzed. PivotTable will be very handy here to compared the Totals for each year as well as the running Totals.
In the caption below and the attached file, you can see, in this example, Sum of Total, % of Grand Total and Running Total for Year 2015 and 2016 by Account Manager
Kindly go through the attached file and see how exactly the Spreadsheet is designed