Max value issue

[ravindraa]

Hi Friends

   I have struck in one place please give me some suggestion to come out from this.

In my data base i have one date it has following fields like Date,Scheme,Plan,amount.

Here my requirement is i have to show the chart scheme and plan wise Amount.

To get amount one condition is there that i have to take Max date value like

--> for example we have scheme AB, under AB scheme we have two plans like (0A,0B) ,here 0A plan has two times , here as per the condition i have to max date plan amount like wise for all the scheme i have to display the chart, but here the problem is i wrote the set analysis like below

sum({<Date={"$(=max(Date))"}>}amount)   , but it is giving max date value as per the date filed not for the scheme wise and plan wise.

please give me some suggestion how to get the value.

Thanks in advance.

Please find attached documents.

[sunny_talwar · Accepted solution]

Is this what you are looking for?

Dimensions

1) Scheme

2) plan

Expressions

1) Date(Max(Date))

2) FirstSortedValue(amount, -Date)

[ravindraa]

Hi Sunny,

  Thank you very much for giving suggestion.

Thanks & Regards

Niranjan