3 Replies Latest reply on Aug 23, 2018 8:02 AM by Okechukwu Ossai

    Dynamically select scenario based on year parameter

    Christian Geuer

      Hi all,

       

      unfortuntately I cannot provide a sample workbook, but here's the case:

       

      Dimensions:

      - Year (date)

      - Scenario (Actual or Revised Estimate / string)

      - Product (string)

       

      Measures

      - Sales (number)

       

      Now, I want to show either Actuals or Revised Estimate SAles depending on which year I select in a parameter. So if I select 2018, it should show revised estimate for this year and actual for all prio years. If I switch to 2017, again revised estimate sales for 2017 and actuals for all prior years.

       

      Sounds easy, but I cannot get my head around it.

       

      Thanks so much for any help!

       

      Chris