I was able to find a way to sync them up so when I change the first prompt, it changes the other one automatically. I went into the second analysis and I added a Filter which "is based on results of another analysis" and I pointed it to the first graph so when the first graph changes location, the second one changes…

That worked! However, I have one problem with it. It does not update the second graph, you still have to manually select the one location that is in the list. Is there a way to have that automatically selected? First prompt: For example, I select BIG out of this list. Second prompt: After first one is selected Is it…

Here are the prompts I created. I am still getting that same error. 1st prompt: SELECT "Cognos_TurnoverByMonthOrgLevel1"."OrgLevel1Code" FROM "Ultimate" WHERE "Cognos_TurnoverByMonthOrgLevel1"."OrgLevel1Code" in (SELECT "Cognos_TurnoverByYearOrgLevel1"."OrgLevel1Code" FROM "Ultimate" WHERE…

Thanks for the quick response. I tried the examples from above and I am getting an error as seen below. Here is what I put in for the values. First prompt: SELECT "Cognos_TurnoverByMonthOrgLevel1"."OrgLevel1Code" FROM "Ultimate" WHERE "Cognos_TurnoverByMonthOrgLevel1"."OrgLevel1Code" in (SELECT…

Perfect. That's what I was looking for! Thank you!!

That's exactly what I was looking for. Thank you for the information!

Thanks for the response and I will check in the RPD if it doesn't work to hide the month. In OBIEE, where can you hide a column for a graph? I haven't been able to find that in any of the properties.