Open navigation

Pivot

Modified on: Mon, Jul 15, 2019 at 4:45 PM

Quickly extract meaning from your worksheets by creating tables of summary statistics including sums, averages, unique counts, and weighted sums.


Ebook


FAQ

How are row breaks different from column breaks?
Row breaks refer to the columns you want results to be grouped by. If you want to see total sales by customer, your customer key column is your row break.

Column breaks are useful if additional groupings are needed. If you want to see total sales by customer by year, customer key is the row break and year is the column break.
What are values/metrics?
Values and metrics refer to the results you want to get and how you want your data to be summarized. These values are calculated by aggregating data from a given column (ex: sales) using a grouping function (ex: sum, percent of, average, number of unique values, etc.).
How can I sort columns during a pivot?
You can sort row and column breaks in ascending or descending order during a pivot by clicking the sort icon in the row and column box. Choose the AZ icon to sort in ascending order, the ZA icon to sort in descending order, or the greyed out icon if you don’t want rows to be sorted.

After a pivot, you can sort each column’s results in ascending or descending order by using each column’s gear icon in the grid.
How many row breaks and/or column breaks can I add?
You can add as many row breaks as you want and up to a thousand column breaks.
Can I change how values are formatted?
Yes, you can format outputs by clicking the pencil icon in the values box. This panel shows the new column’s name and data type, and lets you edit the column’s label and values display format.
How can I create a multi-level pivot table in DSCVR? Is there a rollup feature?
Rollups are not currently available in DSCVR.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.