Show report filter on multiple pages with Pivot Tables

MyExcelOnline John Michaloudis
A free video tutorial from MyExcelOnline John Michaloudis
Chief Inspirational Officer at MyExcelOnline
4.4 instructor rating • 10 courses • 77,258 students

Lecture description

Customize your Microsoft Excel Pivot Table - Show Report Filter items on multiple sheets

Learn more from the full course

Pivot Tables, Power Pivot Tables, Power Query & Power BI

5 Course Excel Bundle: Microsoft Excel, Pivot Tables, Power Pivot Tables, Power Query & Power BI (Excel 2007-2019, O365)

18:07:15 of on-demand video • Updated October 2020

  • Become more PRODUCTIVE at using Microsoft Excel which will SAVE YOU HOURS per day & ELIMINATE STRESS at work!
  • We teach you how to use Microsoft Excel with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!
  • Increase your Microsoft Excel SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
  • COURSE #1: Learn ALL the Pivot Table features: Slicers, Pivot Charts, Filtering, Grouping, Sorting, Conditional Formatting, Macros, Dashboards, Data Analysis, GETPIVOTDATA, Calculated Fields, Formatting plus MORE!
  • COURSE #2: Learn Power Pivot, DAX Formulas, Measures, Calculated Columns & Table Relationships!
  • COURSE #3: Learn Power Query (Get & Transform), import & transform your data, consolidate from multiple workbooks, folders, worksheets plus MORE!
  • COURSE #4: Learn Power BI and create interactive Dashboards that tell a story about your data!
  • COURSE #5: 333 Excel Keyboard Shortcuts explained, covering Formatting, Ribbon, Formulas, VBA, Pivot Tables, Power BI plus MORE!
  • 7 COURSE BONUSES: Excel PDF Cheat Sheets, 101 Ready Made Excel Templates, plus MORE!!!
  • ADDED BONUS: This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)!
  • DOWNLOADABLE Excel workbooks so you can keep on your desktop & practice!
  • Test your skills with various real life Quizzes & Homework Practice Activities & Assignments!
  • Personal Excel support from Professional Excel Trainers with 30+ Years of combined Excel Training!
English [Auto] Their sales results from 2012 to 2014 showing for each month and in our report filters we have our products and sales person and all we can do is show each sales persons values in three separate tabs. If you do this you go on to the options tab and then under options dropdown box choose show report filter pages in here. Get a dialog box to choose which of the to report filters you want to show. Just choose the salesperson and press. Okay. And then when we press that you'll say at the bottom of the tab here that we get the different sales people's names in there. See that where Homer Simpson Ian right atomic rivers and Michael Jackson they show their values for each of the years we're in Michael Jackson here hold down the shift key and go all the way to Homer Simpson and we grouped our sheets there we know that because on top of the page he shows the group in there what we can do now while they're grouped we can actually make a change into one and then every one of them will get amended as well so you can see there that is there. So in format each one of them. Okay. Now they're still grouped. We got a file and print and in here because they're grouped we have the four different sales people in there and we can print to PBF so this choose your PDA and then press print you can call it the individual sales person reports press save and it brings it up in here. We go to the second page third page type fourth page. Okay let's get out of here and then make sure when you're back in your pivot table you're right click add on group the sheets. So that's a quick way where you can see a report filters items on separate sheets with their filter the results.