filter the pivot table result

  • Thread starter Thread starter Soe
  • Start date Start date
S

Soe

i like to filter the pivot table result, say names of all people born in
December 1970.
Somebody has suggested to use "hide" some data for required field, however,
if data is too long, then we can't hide each and everyone item especially
these filter uses to change quite often.
anybody can suggest?
 
As answered in your previous thread:

'=====================================
1) You can group the Date field, then add the fields to the Page area:
-- Add the Date field to the Row area
--Right-click on the button for the Date field
--Choose 'Group and show detail' > Group
--Select Years and Months, click OK
--Drag the Years and Date fields to the Page area
--Select a Year and Month from the dropdown list in the Page Area

2) To remove the subtotals for a field:
--Right-click on the field button in the pivot table
--Choose Field Settings
--Under Subtotals, select 'None'
--Click OK
'====================================
 
Back
Top