Forum Discussion
Solved
Calculate Monthly Average on a Pivot Table
Hi, I have a table with all my daily expenses (that I extracted from my credit card reports). I made categories and subcategories for these expenses I created a Pivot Table to group these expenses ...
That's for Windows:
- creating PivotTable you have an option to add data to data model
- in data model you have an option to add measures
- for above sample measure could be
which we may use in PivotTable.
I attached the file with the sample, you may try to open it. I'm not on Mac, but as I know it doesn't support such functionality. Perhaps something changes recently.
When I do the same thing with my Pivot Table that tracks my checking accounts AND my credit cards, by budget categories, I use the Pivot Table to do the monthly totals and just create a separate column off to the side (NOT part of the Pivot Table but adjacent to it) and calculate the averages there. Perhaps that will work adequately for you.