Warning. This is not supported. But how often IS the stuff normally posted here? Nuff said.

A client had an interesting issue:

·         A bar chart that has two action filters associated with it

·         Each action filter gets applied to a different sheet (Sheet1, Sheet2)

·         The client wants the “navigation” action to occur against Sheet1, not Sheet2.

How is navigation order determined? It appears to be the order in which the Actions are recorded in the XML of a TWB.

Example:

Here, we navigate to Sheet 2 – which is the target of Action 3  (The last action in the actions collection).

I wondered if changing the names of the Actions around in the XML a bit might make a difference. It doesn’t. Using the sample below, we still nav to Sheet 2. 

…but if you change the order of these suckers around, magic happens. Now, we navigate to Sheet 3: