Complex Dimension Value Calculation

[tresesco]

Hi All,

Here is my issue:

For Sample data, find the attachement. Please help me out.

Thanks and regards,

tresesco

[pover]

Try something like the following dimension:

=aggr(max({$<Date={"<=$(vMaxDate)"}>} Date),ID)

Regards.

[tresesco]

Thanks Pover, for your response. i have tried the similar in expression(not in dimension...because in dimension set analysis probably does not work). using this i get the ID wise MAX DATE, but i need to compare the STATUS corresponding to that MAXDATE....that's the area where i am getting stuck. please have a look, if you can help me out.

Thanks.

[pover]

Take a look at the example. I think that is what you are looking for.

Regards.

[tresesco]

Thanks Karl,

Though this was not the proper solution i wanted, still your SET gave me the clue to the solution.

Thanks a lot.

Regards,

tresesco