Year,month expression

[narender123]

Hi All,

I have 2 filters

1) Year

2) Month

my expression(1):

=sum({<Year={$(=max(Year))},Month={$(=MaxString(Month))}>}Amount)

so by default it should show the amount of max month of max year.

but it not working

When i select year filter only then it shows the that year max month amount(means working fine)

expression

=sum({<Year={$(=max(Year))}>}Amount) is working fine.

the problem is that both together (month and year) not showing result bydefault for max(month ) of Max(year).

so anybody can tell me whats is wrong with my expression(1).

Thanks in advance.

Narender

[#2]

Can you provide us with an example QVW? I think we would be able to solve your problem faster with your specific example - with just the calendar and fake data for Amount.

If you try er.mohit's example above. I would remove the double quotes since you don't need to search for the number. Also, you don't need to ignore the selections and then redefine year and month.

Try this:

=Sum({<Month=,Year={$(=Max(Year))},Monthno={$(=Max(Monthno))}>} Amount)

See the attached example.