Filter bar chart by sequence of MonthEnd Date

[shumailh]

I have the day by day data of total sales like sales as of day b4 yesterday is 100, yesterday 104, today 99 as accumulative. I want to filter my data by monthend. I am trying the below code but it's not working.

if (date(LoadDate, 'DD/MM/YY') = date(MonthEnd(LoadDate), 'DD/MM/YY') , sum(Sales))

 (date(LoadDate, 'DD/MM/YY') = date(MonthEnd(LoadDate), 'DD/MM/YY') , sum(Sales))

 (date(LoadDate, 'DD/MM/YY') = date(MonthEnd(LoadDate), 'DD/MM/YY') , sum(Sales))

I tried the same thing using set analysis but not work. i check the date format as i am getting data from sql server but couldnt found change.

I tried wildmatch in the above code, index etc but no resolution. can anybody help.

Shumail

[shumailh]

See the attached data I am using.... Can anybody pleeeeeeeeeease help me on the above?

[#3]

Hi

I attached sample application herewith.

monthsEnd() function take two parameter.

Regards

Ashish Srivastava

[shumailh]

See I want the bar chart with month end date and amount for that specific month end, but the problem is when i put amount expression then it's aggregating for whole month data which was already aggregated on daily basis.

=

if(Date(LoadDate)=monthsEnd(1,LoadDate), sum(Amount))

Try check in this way.... if you made the selection for '31 may 2010' then LoadDate will be selected for the full month... i want the loaddate to be selected for the last date not the full months date. See the attachement

[#5]

deffer this attachment .

Regards

Ashish Srivastava