Syntha Lab RU

Pivot table

An Excel table that sums and groups the rows of the source data by chosen fields on its own without formulas.

References, data and reports

Open interactively →

Formula

rows = groups, values = the sum or average of a field

How to read

The source data must be a flat table with headers and no merged cells; after editing data the pivot is refreshed.

Where it is discussed

Documents

Other terms in the group

Open interactively →