1 of 1 people found this helpful
to achieve this you need to parameters
one with the values
the second with just dates
a calculated field that calculates the max date from datasource. - Use an LOD Formula
then calculated field
if parameter 1 = max date
if date = maxdate then 'show'
else if date = date parameter then 'Show'
now use the calculated field as a filter and select show.
Thank you Khalid!
I am trying to achieve the same thing as Annie, would be great if you could have sample workbook attached with? Because I am still unclear how to do so from your explanation.
I also would like to try this, but I also have a little trouble understanding your explanation...
Could you design a little example in a workbook please?
Thank you very much!