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.

  1. Arvind

    Bobo & Mtif: It is is not possible to plot the pivot table as a chart. But you can always create a chart which contains the same values as in the pivot table you have.For example, let’s say you have a pivot table for region-wise weekly sales. You can create a similar chart too. It’s just that you can’t create it over the pivot table but over the base sales data table.

  2. Arvind

    Bobo & Mtif: It is is not possible to plot the pivot table as a chart. But you can always create a chart which contains the same values as in the pivot table you have.For example, let’s say you have a pivot table for region-wise weekly sales. You can create a similar chart too. It’s just that you can’t create it over the pivot table but over the base sales data table.

  3. mtif

    I have the same question as Bobo.How can I make a chart of fields in a Pivot Table. It seems such a shame to have great tools to summarize data and not be able to chart them

  4. mtif

    I have the same question as Bobo.How can I make a chart of fields in a Pivot Table. It seems such a shame to have great tools to summarize data and not be able to chart them

  5. Bobo

    How to make Grapic by Pivot Table ?

  6. Bobo

    How to make Grapic by Pivot Table ?

  7. mtpaperworks

    FYI – The sample Pivot table does not appear
    I need to emulate this example for my site….
    Is the sample table available for download, so I can play with it and learn?

  8. mtpaperworks

    FYI – The sample Pivot table does not appear
    I need to emulate this example for my site….
    Is the sample table available for download, so I can play with it and learn?

  9. johncaulfield

    I had absolutely no idea that Pivot reports were possible outside Excel!

  10. johncaulfield

    I had absolutely no idea that Pivot reports were possible outside Excel!

  11. Clarence

    Hi Suhit,Thank you very much for your compliments. It’s really encouraging to receive such feedback from our users.Zoho Reports will soon be offering business editions, based on a very affordable monthly subscription fee. We will anyway continue to provide a very liberal free-edition ($0) which will easily handle small-scale business reporting requirements. We will announce the pricing plans very soon.If you require any further clarifications, please feel free to mail us at support at zohodb dot com.Clarence
    Zoho Reports
    Online Reporting & Business Intelligence Service

  12. Clarence

    Hi Suhit,Thank you very much for your compliments. It’s really encouraging to receive such feedback from our users.Zoho Reports will soon be offering business editions, based on a very affordable monthly subscription fee. We will anyway continue to provide a very liberal free-edition ($0) which will easily handle small-scale business reporting requirements. We will announce the pricing plans very soon.If you require any further clarifications, please feel free to mail us at support at zohodb dot com.Clarence
    Zoho Reports
    Online Reporting & Business Intelligence Service

  13. worldisgreen

    I used Zoho reports at my workplace. The flexibility, power and instant report generation was fantastic.The senior management was amazed and we got some really good results using this.Now I am figuring out how to use Creator to set up a database and use reports for analysing that data.A great job here.Now, will reports be always free?Suhit

  14. worldisgreen

    I used Zoho reports at my workplace. The flexibility, power and instant report generation was fantastic.The senior management was amazed and we got some really good results using this.Now I am figuring out how to use Creator to set up a database and use reports for analysing that data.A great job here.Now, will reports be always free?Suhit