1 Reply Latest reply on Aug 10, 2016 2:58 PM by diego.medrano

    how to display dynamic date list based on a parameter value

    srini.kasu.0

      is it possible to display dates based on a parameter value.

      The parameter has two values "Headquarters" or "Dealer" location

      when the parameter is set to Headquarters the requirement is to show only the latest 10 Vehicle sale dates across all dealers within the chosen Headquarter.  The Headquarter is chosen via filter. This filter is a calculated dimension that either shows the list of headquarters or a list of individual dealers based on the value of the parameter.

       

      I tried using sets and I went nowhere as I ran into "can't use boolean in Case".

       

      Looking for Ideas and thoughts

      unfortunately I cannot share the workbook from my client location.

       

      Thanks,
      Sri