Month To Day Sales

[Lionel_Maximus]

Hello,

I have four months of sale.......I have a filter-pane with Months and Days in it.

What I want:

When i select Any Day in the filter pane......It should show the sales in every month till that day. How to do it???

Thanks

"Sample Data Is Attached"

[OmarBenSalem]

u have 2 filter panes with 2 fields? Days and Month?

Or one filter pane with one field? Day-Month?

[Lionel_Maximus]

I have 2 Filter Panes with fields.....Month & Day

[Channa]

=Sum({$<[Ship Date]={">=$(MonthStart(passselcted month))<$(=monthend(passselcted month)"}>}Sales)

[Channa]

Hi I attach qvf 

it has two dates try to have date between those 2 dates

start date of selected month

=MonthStart(max(Date))

today of selected month

=date(num(Month(max(Date)))&'/'&day(today())&'/'&year(max(Date)))

create those two variables and take date between those

[OmarBenSalem]

sum({<Month, Day={"<=$(=max(Day))"}>}Value)

[Channa]

1st wile loading date just do date(Date) as DateS

2nd  create variable vMonthStart

=MonthStart(max(DateS))

3rd create variable to get current date vCurrentDate

=date(num(Month(max(DateS)))&'/'&day(today())&'/'&year(max(DateS)))

4th add below in test box

=Sum({$<DateS = {">=$(vMonthStart)<=$(vCurrentDate)"}>}Sales)

it is working i am not able to attach qvf

[Channa]

the above solution will take today of selected month

if you want to pass selected date just pass date into vCurrentDate=DateS

[Channa]

try the sample attached

[Lionel_Maximus]

Hello,

Thank you for the solution but it is giving the wrong answer.....e.g. I don't have the sales in Sep,Dec but when i select either one of those it gives me sale.