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.
Hi Sergei thank you!
What do you mean by "with data model". You mean my raw data, and directly calculate there in the excel sheet instead of using the pivot table?
What do you mean by "with data model". You mean my raw data, and directly calculate there in the excel sheet instead of using the pivot table?
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.
- thank you, I'm gonna try!