Tabulation

In the above examples, Pivot sums a numeric column and places the total in the pivot grid.

Tabulation, by contrast, produces a two-dimensional tabulation of your grid. No summarization takes place.

In the example below:

Tabulation

Some notes:

Tabulation is used in situations where the combination of the Grouping columns plus Pivot column is unique. In the above example, EMPNO and PROPERTY are the unique key for the table; so for each combination of these there is only one value of the VALUE column.
If Grouping plus Pivot are not unique, only one of the values of Analysis column will be shown in the grid. This may not produce meaningful results.
When Tabulation is used, the Analysis column can be of any type (eg. can be character). For non-tabulation pivots, the Analysis column must be numeric.
When Tabulation is used, there are no Totals row and column.

Advanced Query Tool