OK, looking back at the screenshots I sent you, I've noticed that when drilling down, the 'Target' measure was being excluded. This is what drives the 2nd analysis. I've protected my filter so that all of the 'Types' are included and I'm now getting results. Thanks for your help, I really appreciate it! @Robert Angel

Hi Robert, Sure. Hopefully this will help you: The home page looks like this: When you click on the Agent ID, you can drill to the managers view via the Action Link. The Action Link properties are: When you use the Action Link to drill to the manager's view, the AGENT_ID variable from the home page is used to set the…

When results are returned, the URL looks like: "analytics/saw.dll?Dashboard&PortalPath=..." When no results are returned, the PortalPath of the URL is cut off and the URL looks like: "analytics/saw.dll?Dashboard"

Thanks Robert! Using union has allows me to get all of the measures I need into the graph. I'll now try to find a way to order them correctly.

To sort this I ended up creating a repository variable which selects the current month number (EXTRACT(MONTH FROM CURRENT_DATE)). Then I set a filter on the Analysis to only calculate the revenue when the month number is less than the variable I created.

OK, no worries - I can appreciate that. I've managed to get a hold of the Support Identifier so I'll wait until my request gets approved then I'll have a look at the link. Thanks for your help

Hi Joel, Thanks for getting back to me. Although, I'm not able to access the link - it asks me to register and provide a 'Support Identifier'. Would you be able to tell me the details of what it says?