Pivot Tables or Pivoting is a great way to analyze your business data. Zoho Reports has added further power to its pivot function. Salient points include,
- Support for adding multiple data columns (you could have only one column before). This is very useful for doing comparative data analysis
- Sorting support at any column level
- Viewing the underlying data of any data-point in the pivot
Let’s see them in detail.
Support for adding Multiple Data / Columns
Pivot Tables allow you to create a powerful view with data summarized in a grid both in horizontal and vertical columns (also known as Matrix Views or Cross Tabs). Earlier, you could only plot single data column pivots in Zoho Reports. Like the one below.
Now, Zoho Reports allows you to have multiple data columns, which enables you to do comparative data analysis. Also now you can add multiple column level grouping in a pivot which was not possible previously. Below is a pivot showing sales & profit figures (multiple data) for different regions over the years (multiple columns).
Sorting Data on any Column
Zoho Reports now lets you sort data on any column. You can right-click on any column and apply the appropriate sort option.
View Underlying Data
Want to drill down into what each cell in the pivot table / matrix table represents? Say you want to know who bought Office Chairs when and for how much. You can click on the relevant data point in the pivot table and see the underlying data.
A sample pivot table (URL for the pivot) is embedded below.
The above features show how powerful pivot tables in Zoho Reports are when you have to analyze and cut through your data in a meaningful way. Give the new pivot table features in Zoho Reports a spin and let us know your feedback.