Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Note:In the calculated item for Forecast Vs Actual i used @{Scenario} - Actual , then the value is not calculating for default value Forecast 1 When i hardcode the Forecast 1 in the calculated Item the result is right
-
Hello Gianni, Thanks for responding , Based on your response i went ahead and did the following Created a presentation variable using the Dashboard prompt "Scenario"( value in Drop down Forecast 1 thru Forecast 12) with default value Forecast 1 In the Criteria I created nested filters Scenario equal to @{Scenario}{Forecast…