Filter the data in the PivotTable to show specific data.

Step 1:Drag the Date field to the Filters area.

Step 2:Click on Date in the Pivot table, select 8-Apr-13, and click OK.

Step 3:Click on Date in the Pivot table, select 9-Apr-13, and click OK.

Step 4:Click on Date in the Pivot table, select 10-Apr-13, and click OK.

Step 5:Click on Date in the Pivot table, select 11-Apr-13, and click OK.

Step 5: Click on Date in the Pivot table, select 12-Apr-13, and click OK.