Available Filters for Aggregate and Non-Aggregate Fields
When you're working with filters, each field shows different options based on the type of field you pick (like numeric or date fields) and how you use them in your workbook visualizations. In charts and pivot tables, you can use some fields in two different ways:
-
Use fields as aggregate fields - If you drag fields to the Measure section, the visualization shows results as an aggregate field. Therefore, results are grouped together to display a single summary result for several value entries.
-
Use fields as non-aggregate fields - If you drag fields to the Rows or Columns sections (for pivot tables) or the X-Axis and Color Stack sections (for charts), each aggregate field shows a result for each value entry.
Whether you use fields as aggregate or non-aggregate values affects how your workbook visualizations show results. For example, if you want to see the sales amount broken by sales rep, your workbook visualization can display results in different ways. If you use the Amount (Net) field as an aggregate (or measure) field, the visualization shows a single result for all sales transactions by a specific sales rep, based on the aggregate function you choose. For example, if you pick the sum function, you'll see a single value for all the sales transactions. In this case, the field displays 10,000 USD. If you use the Amount (Net) field as a non-aggregate field, the visualization shows a result for each sales transaction of that sales rep. In this case, the visualization displays the following field results: transaction A (9,000 USD), transaction B (600 USD), and transaction C (400 USD).