Quote:
Originally Posted by fundmark19
I haven't messed around with pivot tables but it may be of use if I can dumb it down enough for other team members. We have the different sheets to track activities by the month and doing month by month plus yearly analysis which could probably be accomplished by a pivot table as well
|
Once you get the data set up in a pivot table, it would just be a matter of refreshing the table for new entries and then turning the filters to get what you want
The filtering is pretty straight forward, just dropdowns.
Depending on the size of your business you could even go as far as setting up an analytics interface with PowerBI or more costly, Tableau
(Apparently Power BI is included in all Office 365 subscriptions if your work already has this)