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
