|
|
Pivot Table |
|
|
Slice, Dice, Roll-Up and Drill down |
What product sells faster in November? How do prices compare across months, weeks,
or quarters? When you have the detailed data, the answers to these questions typically
involve numerous gyrations of formulae or SQL when using a spreadsheet or database.
Using the pivot table in numberGo delivers these answers and
many more with a few clicks, drags and drops of the mouse.
numberGo’s pivot table offers a intuitive and hassle-free experience for the one
un-initiated in the use of pivot tables. There is no setup required. Just import
your data using the powerful, yet flexible Importer built in to the numberGo Publisher
and instantly find answers to your questions and those not yet asked.
Features:
- Drag and Drop of fields to perform the pivot
- Easy filtering of field values
- Many aggregation (Rollup) types such as Sum, Average, Min, Max, Count, Error, Standard
Deviation, Variance, Weighted Average and more.
- Automatically calculate variations between facts.
- Ascending/Descending sorts
- Custom sorts
- Field or Fact sorts
- Custom formatting of values and totals.
- TopN functionality. Easily locate the top 10, 20, 30, etc percent.
- Display single or multiple total lines at a time. For example Sum and Average
- Plus many more easy-to-use features. A simple right click of a field can give you
a wealth of information.
Once your data is pivoted the way you want, you can create a complete set of charts
(ChartSets) giving you a better visual representation of your data with just one-click.
Click here to see an image of a pivot table with a ChartSet.
Each layout of the Pivot Table and ChartSets are stored in a View. Each View can
be arranged any way with any type of sort and aggregation.
If you want to learn more about a pivot table, see our Pivot table tutorial
Download the FREE numberGo Publisher today. It’s the most accessible and cost-effective
way to get powerful data mining capabilities for adhoc or structured data.
|
|