Concept"
m (Created page with "{{ZKPivottableEssentialsPageHeader}} {{Template:UnderConstruction}} <!-- What's in a data cell: summary (intersection by criteria) --> <!-- header categorization --> <!-- open/...") |
|||
| Line 3: | Line 3: | ||
{{Template:UnderConstruction}} | {{Template:UnderConstruction}} | ||
| − | + | If you are not familiar with the concept of pivot table, this section will kindly guide you through. | |
| + | |||
| + | ==The Basic== | ||
| + | Suppose you have a table of data of flight ticket sales record like this, | ||
| + | |||
| + | [[Image: ZKPivotEsn_raw_table_03s.png]] | ||
| + | |||
| + | |||
| + | |||
| + | and someone asks you "Hey, how did Antonio do this week? How much did he sell from each airline?" | ||
| + | |||
| + | You read through the table, highlighted all entries with Antonio involved, categorized by airline names, and sum up the selling prices. | ||
| + | |||
| + | [[Image: ZKPivotEsn_raw_table_04s.png]] | ||
| + | |||
| + | |||
| + | |||
| + | This is a typical scenario when you work with business data, and this is where a pivot table comes into play. | ||
| + | |||
| + | For example, you can let Pivottable sums up all the selling prices per agent, per airline, and arrange agents on the row, airline on the column, then you automatically have the desired data summary on Antonio's row. | ||
| + | |||
| + | [[Image: ZKPivotEsn_work_pivot_03.png]] | ||
| + | |||
| + | |||
| + | |||
<!-- header categorization --> | <!-- header categorization --> | ||
<!-- open/close a node --> | <!-- open/close a node --> | ||
Revision as of 09:23, 28 March 2011
This page is under construction, so we cannot guarantee the accuracy of the content!
If you are not familiar with the concept of pivot table, this section will kindly guide you through.
The Basic
Suppose you have a table of data of flight ticket sales record like this,
and someone asks you "Hey, how did Antonio do this week? How much did he sell from each airline?"
You read through the table, highlighted all entries with Antonio involved, categorized by airline names, and sum up the selling prices.
This is a typical scenario when you work with business data, and this is where a pivot table comes into play.
For example, you can let Pivottable sums up all the selling prices per agent, per airline, and arrange agents on the row, airline on the column, then you automatically have the desired data summary on Antonio's row.
Version History
| Version | Date | Content |
|---|---|---|