Abstract: A non-transitory computer readable storage medium has instructions executed by a processor to ingest source data tables received from a network connected source data machine. A pivot frame is derived from the source data tables. The pivot frame has an index column with index column values representing each unique combination of records in the source data tables, pivot dimension columns forming a deterministic matrix where each row of the deterministic matrix represents a unique combination of records in the source data tables, and a value column with individual values assigned to corresponding index column values. A definition of a desired pivot table is received from a network connected client machine. Pivot values are retrieved from the pivot frame that fulfill the definition of the desired pivot table to form a pivot table with unique pivot table row and column values. Index column values are associated with the unique pivot table row and column values.