Set Analysis

[rathnam_qv]

Hi all,

i have Quaters data..

in the Month Listbox if i select May, it should give may and April Data as well

how can i achieve that

Urgent Please...

Can any one help me...

Thanks in Advance

Smiley

[#2]

Add new column to your table

sum({$<Month={$=(Max(Month)-1)}>} Sales)

[narender123]

=sum({<Month={">= $(=MaxString(Month)-1)"}>} Amount)

Thanks

Narender

[er_mohit]

Try this

sum({$<Date = {">=$(=MonthStart(Max(Date),-1))<=$(=MonthEnd(Max(Date)))"},Year=,Month=>}Sale)

[mikecrengland]

You might try something like:

=sum({<Month *= >} Total <Quarter> SalesAmount)