Using Filtered Rows
Filtered Rows was one of the greatest additions to Xcelsius 2008 (now SAP BusinessObjects Dashboards 4.1) from Xcelsius 4.5. If we look at the following screenshot, we see that we have a set of Sales metrics that are grouped by Region and Office:
Let's say we want to be able to select a region and show a sales comparison chart between the different sales offices of that region. Before the advent of Filtered Rows, we would have had to perform a complex VLOOKUP or have the result come back through a query every time a region was selected. Both methods are very time consuming.
How to do it...
We will use a Combo Box selector to choose the desired region.
In the Combo Box selector properties, bind the Labels to the Region column.
Select Filtered Rows as the Insertion Type. Bind Source Data to cells A3:C12. The Destination will contain the chart values as well as the selected region.
Bind the chart values to the Destination section from step 3.
How it works...
The Filtered Rows insertion...
