Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi have a look at the attach example
hi have a look at the attach example
I can't find attachment. thanks..