good morning,
to see if you can help me, please
I have a set of items with a delivery date of order, In the script I calculate the load weekname both dates.
item | order date | w_od_name | delivery date | w_dd_name |
---|
1 | 01/01/2014 | 2014/01 | 01/01/2014 | 2014/01 |
3 | 03/01/2014 | 2014/01 | 01/01/2014 | 2014/01 |
3 | 05/01/2014 | 2014/01 | 01/01/2014 | 2014/01 |
5 | 07/01/2014 | 2014/02 | 01/01/2014 | 2014/01 |
5 | 11/01/2014 | 2014/02 | 01/01/2014 | 2014/01 |
1 | 04/01/2014 | 2014/01 | 06/01/2014 | 2014/02 |
2 | 02/01/2014 | 2014/01 | 06/01/2014 | 2014/02 |
4 | 06/01/2014 | 2014/02 | 06/01/2014 | 2014/02 |
4 | 10/01/2014 | 2014/02 | 08/01/2014 | 2014/02 |
3 | 18/01/2014 | 2014/03 | 08/01/2014 | 2014/02 |
2 | 19/01/2014 | 2014/03 | 29/01/2014 | 2014/05 |
the goal is to represent the number of different items that are delivered in the MIN w_od_name, being requested a w_dd_name as dimension. I get
w_od_name | MinString(w_dd_name) | count(if(w_dd_name=MinString(total w_dd_name),item)) |
---|
| 2014/01 | 5 |
2014/01 | 2014/01 | 3 |
2014/02 | 2014/01 | 2 |
2014/03 | 2014/02 | 0 |
I get to set the number of items for the lowest week of the document but not the dimension
please,, help me
thanks and regards