Limiting the values displayed in a straight table (Continued)

[#1]

Hi all,

I created a 1000+ € customer list with the following criteria:

- Only new clients (no turnover for previous year same month)
- Turnover is cumulated YTD

So I user this expression

sum(if(aggr(sum({$<YEAR={$(=Max(YEAR-1)}>}TURNOVER), CLIENT, MONTH)=0 and aggr(sum({$<YEAR={$(=Max(YEAR)}>}TURNOVER), CLIENT, MONTH)>=0,aggr(sum({$<YEAR={$(=Max(YEAR))}>}TURNOVER),CLIENT,MONTH),0))

This gives me a list of all new clients.

Applying Miguel A. Baeyens's suggestion to limit the list to 1000+ € only (if(Expression>=1000,Expression), I get the following result (this is the total amount of turnover for the first two months of 2010. Without the 1000+ condition, I would have a total of 40733 €.

I tried to apply this formula within a new straight table with MONTH as dimension instead of CUSTOMER. The problem is that it does not retain the condition > 1000 € anymore; and so I get the following result:

As you can see, the breakdown per month does amount to the global turnover, meanwhile I only want the turnover per month for client whose two month period turnover is over 1000 €.

If you have an idea,that would be great.

Thanks

Vincent