min selected date on dimension

[#1]

Hi All,

I'm trying to apply logic in an if statement on a pivot chart dimension where i want to compare the min selected date to each of the rows in the chart.

I had been using aggr(min(date), group).

e.g. if i select aug, sep, oct in my date range im trying to get a statement together to compare august with august, september with august and october with august.
what is happening is it is comparing august with august, september with september and october with october.

Any ideas?

Thanks,
Kevin.