How to ignore a dimensions value while using set analysis for date restriction.

[davyqliks]

HI,

I have a very large data set which i am restircting to 10 weeks using set analaysis.

I need to review the data which has been received in the last 10 weeks (using the set analysis), however, i also need to see if the received data has ever been ordered. ( not only within the last 10 weeks).

In the load i have made a flag based on if the data has ever been ordered, so i now need a way to only show the 10 weeks received data while showing the Ordered flag, even if it was over 10 weeks ago.

here is the expression to restrict the data in the table to 10 weeks -

=Aggr(only({<[Send Date]={">=$(=Weekstart(WeekName(max([Send Date]),-10)))<=$(=Weekend(WeekName(max([Send Date]))))"}>} [Purchase Order No]),[Purchase Order No])

I would like the table to show the [Purchase Order No] for the [Send Date] within 10 weeks, but if the order flag is Y (any date) show the Y value, I will not include the N data.

Is this possible? thank you

Daniel

[marcus_sommer]

You may try something like this:

... only({< Date = {...} > + < Flag = {Y}>} Field) ...

- Marcus

[davyqliks]

Hi Marcus,

thank you for the reply, i will give this a go today.

regards,

Daniel