Set Analysis

[#1]

Hi ,

Pls help with set Analysis..Sample data & Required Result attached.

Thanks in advance..

Sub2u

[manojkulkarni]

Use variables to calculate sales between two dates. Start date will be your Month Start of fiscal year and End date will be the last date of selected month. You can use both these variables to get sales between selected period

set

st_date=

date(monthstart(FirstMonthOfFiscalYear),'YYYY-MM-DD');

set

en_date=

date(monthend(Max(SelectedMonthYear)),'YYYY-MM-DD');

= sum({<bill_date={">=$(=st_date) <=$(=en_date)"}>}sales)