Pivot tables are powerful because they operate on the principle of multidimensional analysis, an intuitive framework for measuring (facts) by categories (dimens

Pivot tables are powerful because they operate on the principle of multidimensional analysis, an intuitive framework for measuring (facts) by categories (dimensions). Facts and dimensions are abstracted into an organized calculation model also known as cubes or OLAP or star schema.