Filter/Group Pivot table data columns by field summary type?

[colintso]

I'm attempting to filter a pivot table so that it will only show one field summary type at a time (e.g. Sum, Count). Currently, I have them on the same pivot table and thus end up with duplicate fields in the "Values" section of the pivot table settings. I would also like to filter through VBA, as the table is being created by VBA at the moment.
<o> </o>

Row Labels	Mean (Sum)	Mean (Count)	Mean (Average)	Norm (Sum)	Norm (Count)	Norm (Average)	Doh (Sum)	Doh (Count)	Doh (Average)
1	169.5	6	28.25	320.7	6	53.45	561.25	6	93.54166667
2	393.4	7	56.2	178.5	7	25.5	903.4833334	7	129.0690476
4	793.9225	8	99.24031251	782.55	8	97.81875	739.7913096	8	92.4739137
5	914.3091667	7	130.6155952	1638	7	234	947.3361904	7	135.3337415
Grand Total	2271.131667	28	81.11184524	2919.75	28	104.2767857	3151.860833	28	112.5664583

<tbody>
</tbody>

<o> </o>

 

[Jerry Sullivan]

Hi and Welcome to MrExcel,

If I'm understanding your setup, I don't think you can "filter" by summary type.

You could use VBA to change the type of a displayed datafield's .Function property to switch one type to another.