I have a pivot table that calculates the sum of total expenses per month . Source is raw data in another worksheet.
I want to know the average per month. How do i calculate that in the pivot table ?
I know i can use the Average formulate to calcualte this outside of the pivot table.
I want to see if there is a way to calculate in the pivot table itself.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I want to know the average per month. How do i calculate that in the pivot table ?
I know i can use the Average formulate to calcualte this outside of the pivot table.
I want to see if there is a way to calculate in the pivot table itself.
Sum of Amount | Column Labels | |
Row Labels | Restaurants/Dining | Grand Total |
Jan | -347.33 | -347.33 |
Feb | -500.32 | -500.32 |
Mar | -787.7 | -787.7 |
Apr | -492.17 | -492.17 |
May | -1062.69 | -1062.69 |
Jun | -710.09 | -710.09 |
Jul | -541.08 | -541.08 |
Aug | -538.42 | -538.42 |
Sep | -379.89 | -379.89 |
Oct | -653.64 | -653.64 |
Nov | -479.76 | -479.76 |
Dec | -474.12 | -474.12 |
Grand Total | -6967.21 | -6967.21 |
Something like Average(6967/12) |
<colgroup><col><col><col></colgroup><tbody>
</tbody>