But we can actually create it and which helps us in various decision-making purposes. We can clearly observe that there is no filter option for value areas, i.e. Generally, when we take data into value areas, there won’t be any filter created to those fields.
Example #2 – Creating a Filter to the Value Areas We can filter the Flat no’s as per our requirement, which is the normal way of creating a filter in the Pivot table. Let’s drag the Flat no’s field into Filters, and we can see the filter for Flat no’s would have been created. Step 3: Pivot table Field will be available on the right end of the sheet as below. We can observe the Filter field, where we can drag the fields into filters to create a filter in the Pivot table. We also can place the Pivot table report, whether in the same worksheet or new worksheet, and we can see it as shown in the above image. We have an option of selecting a table or a range to create a pivot table, or we also can use an external data source as well. When you click the pivot table, the “Create Pivot Table” window pops out. Step 2: Go to the Insert tab and select the Pivot table as shown below. The above data consists of 4 different columns with Sl.No, Flat No’s, Carpet Area & SBA. Step 1: Let’s have the data in one of the worksheets.
#HOW TO PUT FILTERS ON PIVOT TABLES IN EXCEL 2013 DOWNLOAD#
You can download this Pivot Table Filter here – Pivot Table Filter Example #1 – Creating Inbuilt Filter in PIVOT Table