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 ColumnZoho Reports now lets you sort data on any column. You can right-click on any column and apply the appropriate sort option.
View Underlying DataWant
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.
(posts) 
Post Comment