O'Reilly logo

Microsoft Tabular Modeling Cookbook by Paul te Braak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using cube functions

A pivot table can be a very useful tool for analyzing data. The ability to dynamically drop a hierarchy from the model and expose all members, then sorting, filtering, and restricting those members can be used in a large number of analytical situations. However, one problem with the pivot table is that all the elements of the object (Filters, rows, and columns) are connected and cannot be formatted with the complete discretion of the user. For example, the user cannot insert a row between rows in the pivot table. While there are some options for formatting a pivot table, these mainly relate to styles, and often the user wishes to have a larger amount of control over what they are presenting. Additionally, using the formula ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required