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.
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).
Sorting Data on 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.
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.
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.
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.
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
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
How to make Grapic by Pivot Table ?
How to make Grapic by Pivot Table ?
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?
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?
I had absolutely no idea that Pivot reports were possible outside Excel!
I had absolutely no idea that Pivot reports were possible outside Excel!
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
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
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
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