Filtering in a Pivot Table

[hawki1]

my pivot table below has filters on column a and b but I need to filter by c and d. I can't figure out how to add the filter at the top of the column like a & b and the filter icon is greyed out.


[TABLE="width: 393"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]EE#[/TD]
[TD]LS2[/TD]
[TD]Values[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]1[/TD]
[TD]BONUS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]1[/TD]
[TD] MISC.[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]1[/TD]
[TD]COMMISSIONS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD="align: right"]1[/TD]
[TD]BONUS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD="align: right"]1[/TD]
[TD] MISC.[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD="align: right"]1[/TD]
[TD]COMMISSIONS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD="align: right"]1[/TD]
[TD]BONUS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD="align: right"]1[/TD]
[TD] MISC.[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD="align: right"]1[/TD]
[TD]COMMISSIONS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD="align: right"]1[/TD]
[TD]BONUS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD="align: right"]1[/TD]
[TD] MISC.[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD="align: right"]1[/TD]
[TD]COMMISSIONS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD="align: right"]1[/TD]
[TD]BONUS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD="align: right"]1[/TD]
[TD] MISC.[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD="align: right"]1[/TD]
[TD]COMMISSIONS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD="align: right"]1[/TD]
[TD]BONUS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD="align: right"]1[/TD]
[TD] MISC.[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD="align: right"]1[/TD]
[TD]COMMISSIONS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD="align: right"]1[/TD]
[TD]BONUS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD="align: right"]1[/TD]
[TD] MISC.[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD="align: right"]1[/TD]
[TD]COMMISSIONS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD="align: right"]1[/TD]
[TD]BONUS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD="align: right"]1[/TD]
[TD] MISC.[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD="align: right"]1[/TD]
[TD]COMMISSIONS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD="align: right"]1[/TD]
[TD]BONUS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD="align: right"]1[/TD]
[TD] MISC.[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD="align: right"]1[/TD]
[TD]COMMISSIONS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]58[/TD]
[TD]BONUS [/TD]
[TD="align: right"]$737.38[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]58[/TD]
[TD] MISC.[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]58[/TD]
[TD]COMMISSIONS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD="align: right"]58[/TD]
[TD]BONUS [/TD]
[TD="align: right"]$577.86[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD="align: right"]58[/TD]
[TD] MISC.[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD="align: right"]58[/TD]
[TD]COMMISSIONS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD]1[/TD]
[TD]BONUS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD]1[/TD]
[TD] MISC.[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD]1[/TD]
[TD]COMMISSIONS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]34[/TD]
[TD="align: right"]1[/TD]
[TD]BONUS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]34[/TD]
[TD="align: right"]1[/TD]
[TD] MISC.[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]34[/TD]
[TD="align: right"]1[/TD]
[TD]COMMISSIONS [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]41[/TD]
[TD]58[/TD]
[TD]BONUS [/TD]
[TD="align: right"]$696.18[/TD]
[/TR]
</tbody>[/TABLE]

 

[Xeroh]

Assuming that your "Values" column (c) came from the fact that you have 2 fields in the "Values" section of the PivotTable definition, I'll tell you that you can't filter the aggregate data results of your Pivot table. If you want those fields filtered, you need to put them in the "Report Filter" section or make them a Column/Row Label and filter them that way.