Pivot table is used to organize, summarize and compare complex data. It allows you to extract significance from a large data set.
There are 7 operations available: sum, count, max, min, ratio, avg, tally. If you set your column operation to ratio, it will compute correlation between previous two columns to the left. Tally is used to display all subtotal and grand total cells as count while displaying all regular cells as sum.
| Pivot specific options: |
|
| Total column | Additional column with summary for each row |
| Total row | Footer row with summary for each column |
| Rows background color | Defaults to white |
| Rows font color | Defaults to black |
| Header background color | Defaults to light blue |
| Header font color | Defaults to black |
| Fit To Widget Width | Marked columns shrink to fit widget width to eliminate horizontal scroll |
| Format | Apply different formatting to values: Number, Currency, Date or Percentage |
| Columns Sort Order | Sort columns by topmost column header: Ascending or Descending |