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.