Excel 2010 Magic Trick 812: PivotTable Show Report Filter Pages For School District Reports

1. See how to quickly create many student summary report using a Pivot Table and the Show Report Filter Pages feature
Steps
1. Proper data set with Field Names in first row
2. Keyboard to create PT on new sheet: Alt, N, V, T, Enter
3. Drag field that will determine each sheet to the Report Filter area
4. Drag criteria fields to Row Label area
5. Drag field to make calculations upon to the Values area
6. Format report: Design Tab, Layout Group, Report Layout, Show in Tabular Form
7. Create sheets for Report Filter: PivotTable Options ribbon tab, PivotTable group, Options button, Show Report Filter Pages, OK

[soodashishr]

When are you planning to upload series on Power Pivot. Awaiting with great enthusiasm.

[shoppersdream]

Thank you! How do I do this if the report copies of the filter field, I want are in Rows Field and not in Filter Field? Can't I put the same Field in Filter as well as Rows Field? I was not able to put the same fields in 2 places? Any advice, Please?

[Dave-gqhq]

How you Mantain PivotTable updated if data is been added/updated?

[vietnamisfun]

How can i activate this function in excel 2013? Please help. Thanks

[Asi.Qureshi]

This is the same vedio that is on the no.24. means it is a duplicate vedio of 24 .by the way Excel is fun you are great.