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:



      - Year (date)

      - Scenario (Actual or Revised Estimate / string)

      - Product (string)



      - 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!