How to extract/filter certain values in Pivot table

[HienFerber]

Hi everyone! I have some questions with filtering in a pivot table:

Below is an extract of my very long table. Is there anyway I can pull out the bold lines into a separate list, or filtered for only these lines in the same pivot table with the percentage unchanged? I played around with "Showing values as.." but it does not help because basically Excel wants to calculate % based on the subtotal line, which means the "Count of Source in %" will become 100% if I filter for age group 0-4 only.

A separate question is I don't need the average age for each age group since it's obvious that the average age of 0-4 group is 2. How can I show only the average age at the subtotal line?

Many thanks for your help!


[TABLE="width: 574"]
<tbody>[TR]
[TD]Source of plants[/TD]
[TD="align: center"]Age[/TD]
[TD="align: center"]Count of Source[/TD]
[TD="align: center"]Count of Source in %[/TD]
[TD="align: center"]Average of Age[/TD]
[/TR]
[TR]
[TD]ABC Nursery[/TD]
[TD="align: center"]0-4[/TD]
[TD="align: center"]108[/TD]
[TD="align: center"]18%[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]5-9[/TD]
[TD="align: center"]141[/TD]
[TD="align: center"]23%[/TD]
[TD="align: center"]7[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]10-14[/TD]
[TD="align: center"]180[/TD]
[TD="align: center"]30%[/TD]
[TD="align: center"]12[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]15-19[/TD]
[TD="align: center"]73[/TD]
[TD="align: center"]12%[/TD]
[TD="align: center"]17[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]20-24[/TD]
[TD="align: center"]52[/TD]
[TD="align: center"]9%[/TD]
[TD="align: center"]22[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]25-29[/TD]
[TD="align: center"]31[/TD]
[TD="align: center"]5%[/TD]
[TD="align: center"]27[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]30-34[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]2%[/TD]
[TD="align: center"]32[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]35-39[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]1%[/TD]
[TD="align: center"]36[/TD]
[/TR]
[TR]
[TD]ABC Nursery Total[/TD]
[TD="align: center"][/TD]
[TD="align: center"]602[/TD]
[TD="align: center"]4%[/TD]
[TD="align: center"]12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DEF Nursery[/TD]
[TD="align: center"]0-4[/TD]
[TD="align: center"]48[/TD]
[TD="align: center"]9%[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]5-9[/TD]
[TD="align: center"]65[/TD]
[TD="align: center"]12%[/TD]
[TD="align: center"]7[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]10-14[/TD]
[TD="align: center"]53[/TD]
[TD="align: center"]10%[/TD]
[TD="align: center"]12[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]15-19[/TD]
[TD="align: center"]39[/TD]
[TD="align: center"]7%[/TD]
[TD="align: center"]17[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]20-24[/TD]
[TD="align: center"]31[/TD]
[TD="align: center"]6%[/TD]
[TD="align: center"]22[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]25-29[/TD]
[TD="align: center"]24[/TD]
[TD="align: center"]4%[/TD]
[TD="align: center"]26[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]30-34[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]3%[/TD]
[TD="align: center"]32[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]35-39[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]2%[/TD]
[TD="align: center"]37[/TD]
[/TR]
</tbody>[/TABLE]
.........