O'Reilly logo

SAP BusinessObjects Reporting Cookbook by Yoav Yahav

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

Working with cross tables

Pivot tables are matrix tables aimed to slice a measure with two or more dimensions.

Pivot tables are great for presenting aggregative data, but provide additional value for the data analysis as they use the x and y axes. This enables us to cross the data and compare two dimensions or more.

Getting ready

In order to understand the pivot table capabilities, we will use a basic structure: two dimensions and one measure object.

How to do it...

In the following pivot table, we will be able to analyze data by the Year or Quarter dimension. In the pivot body table, the revenue measure is presented as follows:

How to do it...

We can analyze each quarter ...

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