Simple Average of Row Labels

[minhestrone]

How do I get a monthly average of my spending?

<a href="http://s1305.photobucket.com/user/minhestrone/media/1_zps29b77aa7.jpg.html" target="_blank"><img src="http://i1305.photobucket.com/albums/s560/minhestrone/1_zps29b77aa7.jpg" border="0" alt="MonthlyAvg1 photo 1_zps29b77aa7.jpg"/></a>

The above pivot chart shows total amount for each month. When I replace it with Average of Amounts, I get the average of individual expenses for each month:

<a href="http://s1305.photobucket.com/user/minhestrone/media/2_zps6ab591a8.jpg.html" target="_blank"><img src="http://i1305.photobucket.com/albums/s560/minhestrone/2_zps6ab591a8.jpg" border="0" alt="MonthlyAvg2 photo 2_zps6ab591a8.jpg"/></a>

I want a monthly average of total spending, i.e. what's my average monthly spending?

I can calculate that the generic way:

<a href="http://s1305.photobucket.com/user/minhestrone/media/3_zpsad93c982.jpg.html" target="_blank"><img src="http://i1305.photobucket.com/albums/s560/minhestrone/3_zpsad93c982.jpg" border="0" alt="MonthlyAvg3 photo 3_zpsad93c982.jpg"/></a>

But is there a way to incorporate that into the pivot chart?

[alansidman]

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.