Filtered Rows was one of the greatest additions to Xcelsius 2008 (now SAP BusinessObjects Dashboards 4.0) from Xcelsius 4.5. If we look at the following figure, we have a set of Sales metrics that are grouped by Region and Office:
Let's say I wanted 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 to perform complex VLOOKUPs or have the result come back through a query every time a region is selected, which is very time consuming.
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 circled in red.
Select Filtered Rows as the Insertion Type. Bind Source Data to the area circled in red. The Destination will contain the chart values as well as the selected region.
Bind the chart values to the Destination section from step 3.