Calcuate Average for an already pivoted pivot table

[k9kreationz]

Hi all,

I don't even know where to begin with this, so bear with me. I'm using Excel 2010. Ugh! I've tried to format my data, but it's not coming out right, close enough. sorry.

Here's my data:
<pre>
A B C D
1234 5 S M
1234 2 S M
1234 4 S M
1235 6 T M
1258 2 S M
1258 1 S M
1897 8 T O
1897 3 T O
1897 7 T O
</pre>

Here's my pivot table:
<pre>
A MIN
1234 2
1235 6
1258 1
1897 3
</pre>
In my pivot table, Column A is in Row Labels and Column B is in Values as MIN.
I have Columns C and D in Report Filter

I want to find the AVERAGE of all the MIN's while I sort by Column C and/or D.

Example 1: sort by M in Column D.
<pre>
A MIN
1234 2
1235 6
1258 1
</pre>
Average: 3


The problem becomes when I want to find the average of whatever I filter for. It needs to be dynamic. Thoughts? This is a report that will be updated monthly, so I'm trying to automate it as much as possible.

So if a user now want to sort by T, it'd look like this
<pre>
A MIN
1235 6
1897 3
</pre>
Average: 4.5

Obviously once I get into how much data I really have (around 2k rows), this needs to work on its own. Help! And thank you to anyone who can help me.