Set Analysis Conditional Exclusion

[Anonymous]

Hi,

I have those data and I would have to exclude the rows with status = “B” when they are not in the specified date range.

For example if the date range is From: 14/12/2014 to 21/12/2014 I would have to sum the Sales for the OrdersID = 2, 3 and 4 and exclude 1 and 3. (Sum Sales = 305 € instead of 195€) How could I do it with set analysis?

LOAD * INLINE [

    OrderID, Date, Status, Sales, Customer

    1, '13/12/2014', 'B', 90, 'John A.'

    2, '15/12/2014', 'B', 110, 'John A.'

    3, '19/12/2014', 'A', 140, 'John A.'

    4, '21/12/2014', 'A', 55, 'John A.'

    5, '24/12/2014', 'B', 70, 'John A.'

    ];

Thanks in advance.

[lironbaram · Accepted solution]

hi have a look at the attach example

[#3]

I can't find attachment. thanks..