Description
The table displays values in record form, so that each row of the table contains fields calculated using measures. Often a table consists of a single dimension, for example, customers, and multiple measures, such as sales, quantity, margin, and invoice figures.
When to use it
Use a table, when you want to view detailed data and precise values rather than visualizations of values. Tables are good when you want to compare individual values. Drill-down group dimensions are very efficient in tables. Within a limited space, you can drill down to the next level of detail and analyze the updated measure values.
Advantages
You can filter and sort the table in different ways. Many values can be included in a table, and when you drill down in a table, you make good use of a limited space of the sheet. A table is excellent when you want to see exact values rather than trends or patterns.
Disadvantages
If the table contains many values, it is difficult to get an overview of how values are related. It is also hard to identify an irregularity within the table.