Data Table

Using Data Tables you can show and aggregate data in a table format. You can aggregate on multiple dimensions and look at different measures (e.g., summary of per unit values).

A measure is the variable whose values you want to show, typically a number. A dimension is a variable per which the measure is calculated and shown, typically a string, date, etc. For example, if you want to see the pocket price per product, then the pocket price is the measure and product ID is the dimension.

For Data Tables, there are hardcoded limits of maximum 10 000 displayed rows and 8 'Group by' levels.

See also a comparison with Rollups which are somewhat similar to Data Tables.

For step-by-step instructions see How to Manage Data Tables.