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.
Could you share the calculations you're using to create the parameters/dimensions? What you're asking sounds do-able but we need more info. Also, if you've already found a solution, please share!