![]() ![]() You can add more than one report filter to a pivot table. For this,ġ) Click anywhere inside pivot table, and go to Options ribbon.Ģ) From here, click on little down arrow next to options, choose “Show Report Filter Pages”.ģ) Select the filter field for which you want multiple pages.Ĥ) Done! Excel produces multiple worksheets, one each for a report filter setting. Using Report Filters, we can quickly generate multiple pivot reports. Generating Multiple Reports from One Pivot Table: You can immediately switch the report filter to other regions (or a combination of them) to produce the region-wise reports. You can put Salesperson in Row label area, Product in Column area, net sales in value field area and region in report filter area of the pivot table. This is where a Report filter would help you. Now, you are given the data for all sales from Jan 2007 to July 2009 and your boss asks you, “I need a report on sales by product and salesperson in each region”. You operate in 3 regions – West, North and Middle. ![]() ![]() You have 4 salespersons – Joseph, Lawrence, Maria & Matt. Let us say, you are an analyst at ACME Inc., that has 3 products – Fastcar, Rapidzoo and Superglue. Excel has several useful pivot table features to help us make all sorts of reports and charts. We all know that Pivot Tables help us analyze and report massive amount of data in little time. Today we will learn about Pivot Table Report Filters.
0 Comments
Leave a Reply. |