<< Click to Display Table of Contents >>
## Pivot |

Creates a pivot table to summarise values for one or two columns.

One.

•Set Column to the column values you want to use as columns in your pivot table.

•Set Rows to the column values you want to use as rows in your pivot table.

•Set Values to the column you wish to summarize.

•Set Summarize by to how you wish to summarize the values:

oSum show the sum of the values. Non-numeric and empty values are ignored.

oMaximum shows the largest value. Non-numeric and empty values are ignored.

oMinimum shows the smallest value. Non-numeric and empty values are ignored.

oAverage shows the arithmetic mean of the values. Non-numeric and empty values are ignored.

oCount shows the number of non-empty values. A value that contains whitespace is not considered empty.

•Set Set non-calculated depending on how you want to set cells not calculated by the pivot.