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"

[Channa]

there are two solutions i put

one when you select month and date

it give data for that month till the selected date

other one Monthstart date to today of the selected month

imposible share data

[Channa]

take that ZIP File everything is clearly done

use the APP

u can't even select month if no data

[Lionel_Maximus · Accepted solution]

Thank You  All.

The Sloution is :

Previous Month Sale:

Sum({1<Month={'$(PreMonth)'},Day={"<=$(MaxDay)"}>}Sales)

PreMonth = =Month(Max(VDate)) -1

Current Month Sale:

Sum({1<Month={"$(=Max(Month))"},Day={"<=$(MaxDay)"}>}Sales)