Concept"

From Documentation
Line 14: Line 14:
 
and someone asks you "Hey, how did Antonio do this week? How much did he sell from each airline?"
 
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.
+
You read through the table, highlight all entries with Antonio involved, categorize them by airlines, and sum up the selling prices.
  
 
[[Image: ZKPivotEsn_raw_table_04s.png]]
 
[[Image: ZKPivotEsn_raw_table_04s.png]]
Line 26: Line 26:
 
[[Image: ZKPivotEsn_work_pivot_03.png]]
 
[[Image: ZKPivotEsn_work_pivot_03.png]]
  
 +
Taking a closer look, the number in each cell comes from summing up the values of all price entries of given agent and airline:
  
 +
[[Image: ZKPivotEsn_work_pivot_06.png]]
  
 +
 +
 +
==Row and column headers==
 
<!-- header categorization -->
 
<!-- header categorization -->
 
<!-- open/close a node -->
 
<!-- open/close a node -->
 +
 +
 +
 +
==Summary and subtotal types==
 
<!-- Subtotal -->
 
<!-- Subtotal -->
  
=Version History=
+
 
 +
<!--
 +
==More terms and trivia==
 +
-->
 +
 
 +
 
 +
==Version History==
 
{{LastUpdated}}
 
{{LastUpdated}}
 
{| border='1px' | width="100%"
 
{| border='1px' | width="100%"

Revision as of 09:52, 28 March 2011


WarningTriangle-32x32.png 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,

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, highlight all entries with Antonio involved, categorize them by airlines, and sum up the selling prices.

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.

ZKPivotEsn work pivot 03.png

Taking a closer look, the number in each cell comes from summing up the values of all price entries of given agent and airline:

ZKPivotEsn work pivot 06.png


Row and column headers

Summary and subtotal types

Version History

Last Update : 2011/03/28


Version Date Content
     



Last Update : 2011/03/28

Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License.