Need help in set analysis

[sushil353]

Hi All,

In my application i need to get count of data for the lastday of the selected month.

i have a Date field which contains Date with time stamp. i have taken that Date field in listbox and there i have set an expression "=monthname(Date)" to get only month name in the list box.

Now if i select Oct 2012, i should get count of DATA for 31-Oct-2012 in the chart. in my sample data it should be 39.

i have attached the sample application and sample data file for clear understanding.

Please help me out to solve this problem.

Thanks

SKR

[sujeetsingh]

just take master calender and then take max of monthday in set analysis...

[sivarajs]

Please find the attachment

[#4]

Hi,

Please find the attachement,I done your requirement.

Niranjan M.