A pivot table is a tool that allows you to discover, summarize and explore your data interactively. Pivot tables can sort, count, unique count, average, or find the min or max of your data, and display the results in a new table showing the summarized data. This gives you a lot of flexibility and analytical power to extract the significance from detailed data sets.
Here is an example:
You have a list of closed deals and you want to see your total MRR by sales rep and by date. We can answer this question quickly using a pivot table.
Select what you want to compare as your Row and Column source. In our case we want CloseDate as the Row Source, and Sales Rep in the Column Source. The Value Source is the MRR column, and we want to do a Sum as our Calculation Type. If you wanted to see the total number of sales by Sales Rep, rather than the dollar amount, you could change the Calculation Type to a Count, instead.
The resulting output is as follows:
If you have any questions please email email@example.com or chat in on the site.