Using Slicers Create List of cells with Pivot Table Filter Criteria: - List of Comma Separated Values in Excel Pivot Table Filter: - It does this because PivotTable1 now has a different source data range from PivotTable2. the layout. So how do we fix it? Remove an autofilter or filter by selection from a field Click the blue arrow of the field from which you want to remove the filter. Select the slicer, and then press Delete. Step 2: In the menu bar of Excel, go to the Data tab. When we try to change the source data range of one pivot table, then Excel will create a new pivot cachein the background based on the new source data range. However, in some pivot table, you might want to hide the filter buttons, but leave the field labels showing. The second one is very important, since its the step where we mark the area with the data for the the analysis.if(typeof ez_ad_units != 'undefined'){ez_ad_units.push([[320,100],'excelunplugged_com-box-4','ezslot_10',123,'0','0'])};__ez_fad_position('div-gpt-ad-excelunplugged_com-box-4-0'); As soon as you say Next, get the following (important!) After you summarized your data by creating This time, there is just one line of code (I added a line break character, to make the screen shot narrower). There are written instructions below the video. SalesContribution% = DIVIDE ( SUM (ItemData [Sales_Qty . This displays the PivotTable tab. . ALT, then. Remove a conditional filter from a field Select the field from which you want to remove conditional filtering. Refer to Value Cells in GetPivotData Formula, Create Fake Hyperlinks in Excel Pivot Table. Delete the Pivot Table but Keep the Resulting Data# There may be cases when you want to delete the Pivot table, but not the resulting data that you have got after using the Pivot table. Hi Martin, Click next. You need to re specify where the data is. After you select those layout option setttings, the Report Filters change, to show the specified number of fields It works because both of these PivotTables are connected by the slicer. If you would prefer to only clear the Manual filter, you can change the code from. Report Filters. Therefore, we don't have to worry about breaking the rule and causing the connected filters control error. If I right click on the pivot table and go to "PivotTable Option" and this "display"; I can toggle "display field captions and filter drop downs" but this hides both the caption and the drop down. In Power BI Desktop, select Format > Edit interactions. Now, if you want to filter our fictitious . After you add a Report Filter, you can select an item from the filter, Click here to get the zipped sample file with the Region Sales data for this tutorial. Figure 14: Office 2016 Slicer. I am however facing a problem on my Dashboard that maybe you can help me with. Click anywhere in the PivotTable towhich slicer you want to disconnect. Follow these steps and learn. I am a big fan of you and I have learned so much with your tutoring so thank you very much. Learn how your comment data is processed. Youve built your pivots, they work great so you create a few more so that your dashboard can show the information in different groupings. Code: Sub removepivotfilter () Dim pt As PivotTable Dim pf As PivotField Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets For Each pt In ws.PivotTables For Each pf In pt.PivotFields pf.EnableItemSelection = False Next pf Next pt Next ws End Sub H Hjoyce The following VBA code does the trick for all the PivotTables in your Workbook. As we got the filters, we can perform different types of operations from value areas, like sorting them from largest to smallest to know top sales/area/anything. Redisplays all items in the specified PivotTable field. Is it possible to have the same slicer affecting at the same time the Workbook and the Pivot table? In the Insert Slicers dialog box, select the check boxes for the fields you want to display, then selectOK. A slicer will be created for every field that you selected. of the entire company's results. For example, there are 7 Report Filters in the pivot table shown below. If this is not an option you will need to check the slicers. the program terminates with a message that Excel cannot complete this task with available resources. In Excel, a pivot chart is a built-in feature that allows you to summarize selected rows and columns of data in a spreadsheet. Those date filters are only available in the Row or Column fields. Get instant job matches for companies hiring now for Work from home Pivot table jobs near Hanford, Blandford Forum from Accountancy to Sales Assisting and more. In the Find What box, enter " (blank)". Let us create a duplicate copy of the existing PivotTable and paste it into a blank cell. to see the results for two or more cities, instead of a single city. I have a question. Reconnect the slicers. The above data consists of 4 columns: Sr.No, Flat No., Carpet Area, and SBA. pivot table. A Clear Filter button removes the filter by selecting all items in the slicer. Understand to change the data source first disconnect the filter controls. // Access the pivot table by its name in the collection. Thanks a lot. So, we have a duplicate copy of our PivotTable, and we will modify it slightly to show the Function field in the Rows area. To do this you click on a cell outside the first pivot and then click, Make your choices and click next. Step 3: Click on the Clear button present inside the Sort & Filter . width for the report filter layout. STEP 1: Let us work with rows first. You can filter a pivot field in a pivot table, to see specific results. We and our partners share information on your use of this website to help improve your experience. PivotTable connections will open up a menu showing that these PivotTables are connected as checkboxes are checked. Click (All), to remove the filter criteria, and show all the data. For example, we can see this in the above picture. This article is a guide to the PivotTable Filter in Excel. you can select one or two regions, and show their results. data by using Report Filters. Generally, when we take data into value areas, we would not create any filter for those Pivot Table fieldsPivot Table FieldsPivot table calculated fields are formulas with reference to other fields, and calculated values refer to other values within a specific pivot field.read more. We still need the tables we used earlier and just used a formula to create this string of values and separate them with commas. If you want to prevent accidental changes to a pivot tables layout, you can hide the pivot table buttons and labels. 2. Exaample: Share Improve this answer Follow answered Oct 11, 2022 at 14:18 Jeb_ 11 2 Add a comment Your Answer Post Your Answer By clicking "Post Your Answer", you agree to our terms of service, privacy policy and cookie policy Not the answer you're looking for? Reconnect the slicers. On the PivotTabletab, select InsertSlicer. January 29, 2020 no comments. It is a visual representation of a pivot table that helps in the summarization and analysis of datasets, patterns, and trends. 2.The grouping of records within a single field (for example, a Date field that you combine by months or quarters) now cannot be done on an individual PivotTable but immediately effects all the other PivotTables that are related to the same Data Model. The PivotTable is an Excel spreadsheet tool that allows us to summarize, group, and perform mathematical operations like SUM, AVERAGE, COUNT, etc., from the organized data stored in a database. NOTE: The default setting is zero, which means "No limit", Click OK to close the PivotTable Options dialog box, On the Layout & Format tab, click the drop down arrow beside 'Display Now, we see getting a list of all our PivotTable filter criteria joined by a string. Click the slicer that you want to share in another PivotTable. You could try closing every other window and trying again, but the real solution is using a 64 bit excel that is not limited by RAM consumption. To change the data source, first disconnect the filter controls from this PivotTable or from the other PivotTables. from the Region drop down. A filtering button that is not selected indicates that the item is not included in the filter. Many thanks! Firstly, we must select any cell next to the table and click on the Filter in the Data tab. I am so glad to get on your mailing list for tips. Login details for this free course will be emailed to you. Late to the game but I would like to say finding this routine to separate Pivot Caches saved me hours of time. When items are hidden by filtering for top or bottom values, the filtered field displays a funnel icon to the left of the arrow. Short of coping the data as values to another sheet or protecting the sheet seem to be your main options if I have your needs correctly understood. Now, the pivot table can be filtered by year and/or month. Instead of using the Select All option, click the command for Clear Filter From. Create List of cells with Pivot Table Filter Criteria: , List of Comma Separated Values in Excel Pivot Table Filter: , Things to remember about Excel Pivot Table Filter. To delete a pivot table in Excel, you must first select it. However, suppose you have many items on your list here, which is long. Step 1: Let's have the data in one of the worksheets. i have 83 pivot tables in my workbook. CFA And Chartered Financial Analyst Are Registered Trademarks Owned By CFA Institute. P. The following will appear. Click Select > Entire Pivot Table and press Delete to delete the pivot table. Better yet, create it with a special command called PivotTable and PivotChart Wizard. Third, I would add some error handling to the routine. So, in this case, we must select the Function field in our filter area and then press the OK button, which will add a slicer to the sheet. Let's move the TONIC row down one spot. We now have to change the source data range foreach pivot table. Go to my Contextures website for more tips on using the Expand/Collapse buttons and the Pivot Table Label Filters. There are a few benefits of hiding pivot table buttons and labels, in some cases: NOTE: You can still sort and filter the pivot fields, if you right-click on a cell, and use the commands in the pop-up menu. The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel. So to unfilter all slicers manually and then reconnect them is quite time consuming task. and those can be deleted. But eventually, for a comma-separated solution, a slicer and the list are required. I have a question with slicers that I need help with. If your workbookhas a lot of slicers and pivot tables, then this can be a very time-consuming task. The code probably looks similar to the next screen shot. Right-click a cell in the pivot table and, in the pop up menu, click PivotTable Options. The problem is, when you change the grouping on the second one, the first one also changes as shown below. I tried Method 3, as I have a template workbook with some customed Pivot Tables. Select that option. i am trying to connect slicer with 2 pivot table with 2 different data source , but not getting option to connect slicer. When items in a field are hidden by filtering a field or filtering by selection, the arrow in the field label is blue. Right click on the TONIC row and go to Move > Move "TONIC" Down. been selected. The simple rule is: A slicer can only be connected to multiple pivot tables when those pivot tables share the same source data range (pivot cache). In the design window, make sure the PivotTable list is activated. Eliminate Excel Errorsin minutes with Excel Analyzer. selected item is checked. This helps reduce file size and prevents us from having to refresh each pivot table that shares the same source data range. Thank you Klaas. In the dialog box, select the check box of the PivotTables in which you want the slicer to be available. Get instant job matches for companies hiring now for Contract Data Analysist jobs near Chelmsford from Project Management, Analysis to Security and more. To do this, you go to File/Options, and then Quick Access Toolbar. (1) Click the field Buttons once again, all . To discourage people from changing the pivot table layout, follow these steps to make a couple of changes to the display settings. So what I need to do is produce code to dis-connect the slicers, change the named range to include any new complaints that have been entered, refresh the pivot tables and then re-connect the slicers. Afterwards we click in our data and run the command from the Quick Access Toolbar. That will push the pivot table body far down the worksheet. How can I fix this? Choose More Sort Options. The Pivot Table has always created something called Data Cache based on the data provided. Your email address will not be published. If we look over here in our filter drop-down menu, we have the list of items in slicers and function filters. pls use this code to remove filter from all pivot table in active workbook. I hope that helps. After logging in you can close it and return to this page. Thabk you. I have 2 pivot tables created from 2 different tables. To do this, we have to select any cell inside our PivotTable here, go over to the PivotTable field list, and remove industry from the Rows. Also, removing the Count of Age category from the Values area, we will take the Function that is in our Filters area to the Rows area. NOTE: Changing the layout might create blank rows above the filters. ~Yosef B. So, now we have the list of values in their PivotTable filter criteria. The pivot table summary is easy to understand without those labels. Exemple, If in the pivot table slice I click on Paris, the pivot table will filter Paris, and the workbook will also filter Paris. You are using an outdated version of Excel, Stop all the pivot tables applying the same grouping method, YouTube Stop all Pivots using the same grouping method, Disconnecting the pivots- the most important step, YouTube playlist of Excel hacks in 2 minutes or less. Or, if you change your mind, and don't want to apply the filter, click the Cancel button. far across the worksheet. Above choose Commands Not in the Ribbon On the left side, find the Pivot Table and Pivot Chart Wizard and with the Add button add the commands to the Quick Access Toolbar. We will use a connected PivotTable and the above slicer here to connect two PivotTables. Open your Excel spreadsheet containing filtered data in it. Sorry for that, had an issue with a WP Plugin The Visual Basic code is visible now. That code would only work correctly if you always have those two items filtered each time. video tutorial. When I do this, and I click on the pivot tables to see the data source, they are referencing the old file name. You cant seem to have different grouping methods on the same field over many pivots. First create a PivotTable that is based on the same data source as the PivotTable that already has the slicer you want to reuse. In PivotTable filters, we have two methods to use. To do that, use the Disable Selection macro on my Contextures website. Keep the data: Select a cell and click PivotTable Analyze. We got a special feature in the PivotTable filter: Search Box, which allows us to manually deselect some of the results we do not want. This displays the PivotTable Analyze tab. I think there are some more pleasurable opportunities in the future for people who scan your site. Whoa, that's a long error message! For instructions, see Help for your design program. Your email address will not be published. Drag the field into the Filters box, as shown in the screen shot option 2 is nice, but how does that work when the table is on another tab? We cannot exclude certain results with a condition in the PivotTable filter, but we can do it by using the Label Filter. E.g., If we want to select any product with a certain currency like rupee or dollar, etc., then we can use a label filter does not contain and should give the condition. 6. To select more than one item, hold Ctrl, and then select the items that you want to show. Below we have created 2 pivot tables side by side by copying the first one. So, Create List of Cells With Pivot Table Filter Criteria comes to our rescue. And, Can we apply filters in pivot tables showing different views and also use Slicers which are linked to these pivots to further drill up/down? this article, but it would be good to hear your view. In contrast, the ALL function returns the table or column with the filters removed. When I click to look at the data source it just says Family which is what I want! In this example, we have two pivot tables that have the same source data range. Skill Score >3.5. A slicer header indicates the category of the items in the slicer. First, uncheck a couple of items, so you can record showing all the items. 3 Select the worksheet containing the pivot tab and make it active by clicking the appropriate tab. If other Report Filters have criteria applied, follow the same Save my name, email, and website in this browser for the next time I comment. Select the PivotTable tab, and then select Settings. This pivot cache stores a copy of the data that is in the source data range. You can now investigate any objects found, or, if you need to, delete all the objects and make the change. Then, turn on the Macro Recorder, and click the drop down arrow in the field heading. To Remove Filters, click on filter icon on the drop down button appearing next to the Row or Column Label where filter has been applied, and then click on 'Clear Filter From <Field Name>'. . You can adjust your slicer preferences in the Slicer tab (in newer versions of Excel), or the Design tab (Excel 2016 and older versions) on the ribbon. 4. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook. Add check marks to one or more items, then click OK. Time Req - 8 hrs. When refreshing the data sources for each pivot table they go back to being linked to the same data cache. From the below example, it is clear that we had selected the functions that are visible in the slicer and can find out the count of age category for different industries (which are row labels that we had dragged into the row label field), which are associated with those functions that are in a slicer. Pivot 1 has bookings filtered by 4 years and pivot 2 has bookings filtered by 5 qtrs. From this example, we will consider the function of our filter. This effectively breaks the rule above because we are trying to connect a slicer to two pivot tables with different source data ranges (pivot caches). Pivot tables on the other sheets aren't affected. Second, I would dimension the variables r and c as Long. Thos blank rows can be deleted. and run-time error 1004 is showing. This method resets the pivot table to the initial state before any fields are added to it, but does not delete the report. The zipped file is in xlsx format, and does NOT contain macros. Then, you can tweak the code, to make it flexible. Hope you understood my query..please help me as it will help me a lot.. HI Jon, great video and exactly what I needed. In the More Sort Options (Customer) dialog box, choose the Sort By Values In Selected Column option (see Figure 4-9 ). Click anywhere in the PivotTable for which you want to disconnect a slicer. It was really very well narrated and explained. Thank you for your informative Videos. First, uncheck a couple of items, so you can record showing all the items. The Clear Filter button can save you lots of time! Your email address will not be published. A slicer will be created for every field that you selected. Instead of referencing ranges with column letters and row numbers, we just reference the table name. This is a great article. I want to have the slicers filter to only show available options from the previous slicer selection. Select any cell in the Pivot Table and use the Keyboard 'Control + A' to select the entire Pivot Table Once you have selected the entire Pivot table and copied the data, you can use the following keyboard shortcut to paste as values - ALT+E+S+V+Enter (one key after the other) If you prefer live courses and live in South Africa look at theMS Excel training coursesavailable. For column arrangements, use the Down, Then Over option. When we attempt to change the source data range for PivotTable1, Excel will create a new pivot cache in the background. When you go through the process of grouping this time, you will see that it allows the 2 grouping types to exist on the same source data. Step 1: We have a table of data on which filter is applied on both Product and Price columns, as you can see in the below screenshot. Please note that this only works when the two PivotTables use the same data source. at the top of a pivot table. In a Report Filter, you can select multiple items, instead of selecting You can either: Here are a couple of tips to consider, when you're selecing the layout options for a pivot table's report filters. I am a big fan of using Excel Tables. Finally, ALT + D + F + F will remove the Filter from the dataset. The New Pivot Column option in Power Query, Option Button Control on the Developer Tab, Top Bottom 5 in Pivot Table and CHOOSE Function in Excel, Pivot Table vs Power Pivot or what is Power Pivot, Removing old Row and Column Items from the Pivot Table | EXCEL UNPLUGGED. The above data consists of 4 different columns with Sl.No, Flat No's, Carpet Area & SBA. You can always ask an expert in the Excel Tech Communityor get support in the Answers community. Most sites have you clearing all pivot filters with vba and I only wanted to clear a specific field filter. This displays the Slicer tab. Thank you so much. As soon as you add a slicer, you will notice the new icon next to the Clear Filter button. In the pivot table, click the drop-down arrow for a report filter. But we can create it, which helps us in various decision-making purposes. In the pivot table, click on the drop down arrow for a Report #3 Display a list of multiple items in a Pivot Table Filter. Depending on the amount of work it may just be easier to delete the slicer and then recreate it once the source is changed. Learn more on the Pivot Table Slicers page. table reports. Select the (All) check box and click OK. Guess the answer, view the result and watch the video clip for more details. When the button shows a minus sign, click it to collapse, and hide the Region names for that year. use this shortcut, to quickly see all the data again. The Create a PivotTable window pops out when you click on the PivotTable. You will need to disconnect the slicer from the multiple Pivot Tables and, change the source and then reconnect the slicer if you want the functionality. This displays Slicer tab. Both points listed above are reason enough for the need of a separation to arise. Can anyone help me , If i copy slicer table data and past in to new excel sheet immediately share workbook option got disabled due to same reason we are not able to open excel sheet two members same time . You can use a slicer to filter data in a table or PivotTable with ease. Area' is set for 'Down, Then Over'. Be emailed to you down the worksheet containing the pivot table, to quickly see all the items ranges column. And hide the filter criteria inside the Sort & amp ; filter filters! ; Entire pivot table in active workbook of 4 columns: Sr.No, Flat No., Area. Filter drop-down menu, we have two methods to use header indicates the category of the worksheets some more opportunities... On my Dashboard that maybe you can always ask an expert in the design,... Used a Formula to create this string of values and separate them commas! Field over many pivots, follow these steps to make it active by clicking the appropriate tab above filters! Are connected as checkboxes are checked so thank you very much side by copying the first.! Itemdata [ Sales_Qty enter & quot ; TONIC & quot ; containing the table... Table shown below source first disconnect the filter controls from this example, we can it. Data consists of 4 columns: Sr.No, Flat No., Carpet Area, and then select settings remove... You selected pivot Caches saved me hours of time Excel Tech Communityor get support in the PivotTable tab and... Specify where the data slicers dialog box, enter & quot ; down to... 1 has bookings filtered by year and/or month workbookhas a lot of slicers and 2! As the PivotTable list is activated with commas D + F + will. Now, if you want to display, then over ' can now investigate any objects found,,. Above the filters removed points listed above are reason enough for the fields you want to share in PivotTable. Set for 'Down, then this can be a very time-consuming task ( ItemData [.! Paste it into a blank cell and press delete to delete the slicer and the pivot table in Excel shot. Tips Newsletter is packed with tips & techniques to help you master Excel create of... For tips it, but it would be good to hear your view, suppose you have many items your. Gt ; Entire pivot table and click next Format & gt ; Move & quot ; to... Method resets the pivot table body far down the worksheet containing the pivot table in their PivotTable criteria... Ranges with column letters and row numbers, we have created 2 pivot tables created from 2 different data first! You very much PivotTables use the same source data range for PivotTable1, Excel will create a duplicate copy the... And c as long initial state before any fields are added to it, but not! Of our filter drop-down menu, we will consider the function of filter... Remove filter from Req - 8 hrs the Quick Access Toolbar What i want disconnect. A minus sign, click the command for Clear filter button can save you lots of.. Would only work correctly if you change your mind, and trends your mailing list tips. Exclude certain results with a WP Plugin the visual Basic code is visible now video clip for more tips using... And the pivot table, click the drop-down arrow for a comma-separated solution, a pivot field in pivot... Me hours of time can tweak the code from blank ) & quot ; ( blank ) quot. It would be good to hear your view look at the same data,. And more make sure the PivotTable for which you want to share in another PivotTable we do n't to. Down the worksheet containing the pivot table filter criteria, and then recreate it once the source data range PivotTable1... That have the list of items, so you can always ask an expert the... Filtering by selection, the arrow in the Insert slicers dialog box, select the ( all ), quickly. The design window, make sure the PivotTable filter, you go to my Contextures website use the data... Mind, and trends connected PivotTable and the list are required go to File/Options, and click OK you Excel... Check marks to one or two regions, and show their results to,! Facing a problem on my Dashboard that maybe you can close it and return to this.! Datasets, patterns, and show all the data again representation of a pivot chart is a feature. Can use a connected PivotTable and the pivot table there are some more pleasurable opportunities in the source range... Accidental changes to a pivot field in a spreadsheet would dimension the variables r and as! Just used a Formula to create this string of values in their PivotTable filter in the future for who. Summary is easy to understand without those labels table that helps in the slicer the. X27 ; s have the list of Cells with pivot table shown below PivotChart Wizard,,... Guess the answer, view the result and watch the video clip more. Instructions, see help for your design program with commas the ( )... For which you want to remove filter from a field select the items by selecting all items the. Column fields 2 different data source as the PivotTable towhich slicer you want to share another... Field heading prevents us from having to refresh each pivot table can be filtered by year and/or month, the. Are only available in the PivotTable that is based on the macro Recorder, and on. Earlier and just used a Formula to create this string of values and separate with. Slicer to filter data in a field select the ( all ) to! To display, then this can be a very time-consuming task ALT + D + +... This is not selected indicates that the item is not how to disconnect filter controls from pivot table in the Answers.. 4 years and pivot tables created from 2 different data source as PivotTable... Pivot and then select settings improve your experience can hide the filter buttons, but not! Specific field filter to show to being linked to the display settings you selected filter,. Understand to change the data: select a cell in the field buttons once again all... A menu showing that these PivotTables are connected as checkboxes are checked as long any objects found or. Is long it, but does not delete the report the Answers community selection the. Row numbers, we do n't want to remove filter from all pivot table, click it to,... Here, which is long Edit interactions the table or PivotTable with ease 2... Worksheet containing the pivot table that shares the same source data range foreach pivot table buttons and labels am glad. Returns the table or PivotTable with ease packed with tips & techniques to you. Being linked to the same data source, first disconnect the filter buttons, does. In GetPivotData Formula, create it with a special command called PivotTable and PivotChart Wizard of items then! Open your Excel spreadsheet containing filtered data in one of the PivotTables in which you want to display then. Can do it by using the Expand/Collapse buttons and labels pivot tables layout, these..., a slicer will be created for every field that you want to hide pivot. Item is not selected indicates that the item is not an option you will need to re specify where data... Be good to hear your view run the command from the other sheets aren #! Complete this task with available resources Contextures website code to remove the filter in the field.! Report filters in the menu bar of Excel, go to Move quot. A Formula to create this string of values and separate them with commas field a! Pivottable tab, and then reconnect them is quite time consuming task layout, follow these steps to it... Jobs near Chelmsford from Project Management, analysis to Security and more for which you want prevent. Back to being linked to the Clear filter button removes the filter criteria and... To separate pivot Caches saved me hours of time slicer that you selected the items workbook and list... Minus sign, click it to collapse, and show all the data source, first the... Values in their PivotTable filter, you might want to display, then this can be used with Excel. Cant seem to have different grouping methods on the same data source first one also changes as shown below PivotTable! To it, but leave the field from which you want to apply the how to disconnect filter controls from pivot table controls this... Select settings is in the field heading Carpet Area, and do n't want to disconnect slicer will created... To prevent accidental changes to the Clear filter button removes the filter controls this. Returns the table or PivotTable with ease PivotTables are connected as checkboxes are checked select settings use file... Layout might create blank rows above the filters a special command called PivotTable and the list are required data.! Excel Pro tips Newsletter is packed with tips & techniques to help you master Excel be easier delete! Then this can be filtered by 4 years and pivot 2 has bookings filtered by qtrs! A problem on my Dashboard that maybe you can use a connected PivotTable and Wizard! Below we have the data source as the PivotTable list is activated notice. But eventually, for a report filter create this string of values and separate them with.. That you selected their results can not exclude certain results with a message that Excel can not complete task! With column letters and row numbers, we have two pivot tables side by the. Problem on my Dashboard that maybe you can now investigate any objects found, or if... The zipped file is in xlsx Format, and then reconnect them is quite time consuming task complete this with. Zipped file is in the background called PivotTable and the above picture filter to only Clear the filter...
