Business Intelligence Tool.
Pivot, Chart, Report & Share.

Have questions?
CALL NOW 1-800-530-9647

View Cart

Home

Products

Downloads

Cool Data

Support

About

Contact Us

Tutorials

Frequently Asked Questions

Pivot table tutorial

Further Pivoting

So far I’ve kept the Ship Date as a column and the Region, Category and Shirt Style as rows. The next few images of this pivot table example will show different types of Pivots.

Figure 13
Pivot Table Examples

Figure 14

Business Intelligence

As you can see from the pivot table example, being able to pivot and aggregate date in any number of combinations will provide tremendous insight into your business. Totals across time, products, divisions, etc… are all just a few clicks away. No need to create new spreadsheets and formulae to see what’s happening.

Summary

Pivot tables can be used for just about any type of data – sales, financial, shipping, log file analysis and manufacturing just to name a few. Typically any dimension can be in any position except as a fact. Only numeric dimensions can be facts.

A Pivot table is very simple once you understand what to expect.

I hope this tutorial provide some insight into a Pivot table. If you would like to see it work for yourself, please contact us for a trial copy of the numberGo Publisher and some of the Cool Data. You can also download the sample spreadsheet here and the sample numberGo file here used in this tutorial.

Download a FREE copy of the numberGo Publisher

Was this tutorial helpful?

Very HelpfulHelpfulNot so HelpfulNot Helpful at allNot what I was looking for

Business Intelligence Tool. Pivot, Chart, Report & Share.

Pivot table tutorial

Business Intelligence Tool.
Pivot, Chart, Report & Share.