Bizarre Set Analysis issue

[#1]

Hi all,

I am hoping someone can help me figure this out as it is confusing and frustrating me.

I have a pie chart and a bar chart, both of them should use the most recent month's data, so for the period under review, we use Dec-2010.

In my pie chart, I use this expression to get a full count of distinct customers.

Expression 1

count ({<[BUSINESS DATE Month-Year]= {"= date(max(BUSINESS_DATE),'MMM-YYYY')"}>}distinct CUSTOMER_NO)

This pie chart only has one dimension called Status.

The result of the count I do does not give me the value for the most recent month value, but instead counts all the distinct customer numbers worth of data that I have, which is totally incorrect

Now, I used this expression as a test

Expression 2 :

count ({<[BUSINESS_DATE Month-Year]= {'Dec-2010'} >}distinct CUSTOMER_NO)

and that expression gives me the right value for distinct customers in Dec 2010.

Can someone help me out with expression 1, so that both expression 1 and expression 2 evaluate to the same answer, as I cannot go in each month to change the month year value to correspond to the month being looked at

Thank you

[#2]

I'll try it out and will let you know the result.

Thanks guys for all the help