![]() ![]() ![]() Viewers can then explore the data at the level of detail that interests them most. Expand-collapseĮxpand-collapse lets report viewers show or hide different levels of information in the pivot table by clicking + and – in the column header. Pivot tables support totals and subtotals for both rows and columns:Įxample pivot table showing totals and subtotals. This further breaks down the data, giving you even more insight into your data:Įxample pivot table showing Gender as breakdown dimension. The example below adds the Gender dimension to the rows. Pivot tables in Data Studio support adding multiple row and column dimensions. Notice that several countries had no revenue in Q4, for example. You can also quickly spot outliers or anomalies in your data. This table easily summarizes the data from the previous example. While this table is useful for showing which country received the most revenue per user and in which quarter, it isn't useful for summarizing this data in a meaningful way.Ī pivot table, however, quickly shows the relationship of this data:Įxample pivot table showing revenue per user, by country, quarter, and year The following is a standard table listing the Revenue Per User metric by calendar quarter and year:Įxample table showing revenue per user, by country, quarter, and year. This lets you group and summarize the data in ways a standard table can't provide. Pivot tables in Data Studio take the rows in a standard table and pivot them so they become columns. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |