Zoho Analytics : Pivot Table Enhancements

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 Analytics. Like the one below.

Screen Shot 2016-09-22 at 6.47.35 pm

 

Now, Zoho Analytics 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).

Screen Shot 2016-09-22 at 6.47.15 pm


Sorting Data Screen Shot 2016-09-22 at 6.50.27 pmon any Column

Zoho Analytics 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.

Screen Shot 2016-09-22 at 6.49.04 pm

 

The above features show how powerful pivot tables in Zoho Analytics are when you have to analyze and cut through your data in a meaningful way. Give the new pivot table features in Zoho Analytics a spin and let us know your feedback.

Comments

14 Replies to Zoho Analytics : Pivot Table Enhancements

  1. 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. 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. 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. 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. 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?

  6. 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?

  7. Hi Suhit,Thank you very much for your compliments. It's really encouraging to receive such feedback from our users.Zoho Analytics 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 Analytics
    Online Reporting & Business Intelligence Service

  8. Hi Suhit,Thank you very much for your compliments. It's really encouraging to receive such feedback from our users.Zoho Analytics 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 Analytics
    Online Reporting & Business Intelligence Service

  9. 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

  10. 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

Leave a Reply

Your email address will not be published.

The comment language code.
By submitting this form, you agree to the processing of personal data according to our Privacy Policy.

Related Posts