In this example, we will explore on-the-fly features of PerformancePoint reports. We will go through features such as sorting, filtering, drilling down/up, changing measures, and report type with the help of the following steps:
Go to the Sales dashboard page that we created in the previous example. Open the page in an Internet browser.
In the right-hand legend, you will see some geographical groups listed. From that list, click on the Europe option.
You will see that the report changes and only Europe's data is being displayed. The legend will show countries such as France, Germany, and United Kingdom.
Now, right-click on the legend of countries and from pop-up menu, choose Drill Up.
Now, you will see two calendar years (2009 and 2010) without data in the calendar axis.
Right-click on one of the items in the calendar axis, and from the pop-up menu, click on Filter, and then choose Filter Empty Axis Items, as shown in the following screenshot:
You...