You can use pivot tables to narrow down a large data set or see relationships between data points. For example, you could use a pivot table to analyze which salesperson brought the most revenue for a specific month. Note: The pivot table refreshes any time you change the source data cells it’s drawn from. See cell details You can look at the source data rows for a cell in a pivot table. Calculated fields with SUM or a custom formula
Tip: To write custom formulas, you can use:
Important: If you use field values with spaces, make sure to use quotations around them in your custom formula. For example:
ExampleMake a copy Related articles
Was this helpful? How can we improve it? |