Hi all
So my issue is I have a column showing journeys of car from A-B, B-C, A-C etc, but there are many for each instance (four A-B journeys in the week for example). I also have another column which show's number of passengers in the cars and that number varies amongst the journeys (A-B with 3 passengers, A-B with 1 passenger etc.). I want to be able to find a way to find the MAX of the number of passengers for each Journey and bring back that MAX value against every journey. So, in the example above, I'd expect to see A-B journey with 3 against the value.
This might help:
A-B - 1
A-B - 3
A-B - 2
C-D - 5
C-D - 2
C-D - 1
A-B = 3 for all A-B’s present
C-D = 5 for all C-D’s present
Does anyone know how to do this? I've been trying to use a MAXX to disaggregate but I can't seem to find a way to make it work!
So my issue is I have a column showing journeys of car from A-B, B-C, A-C etc, but there are many for each instance (four A-B journeys in the week for example). I also have another column which show's number of passengers in the cars and that number varies amongst the journeys (A-B with 3 passengers, A-B with 1 passenger etc.). I want to be able to find a way to find the MAX of the number of passengers for each Journey and bring back that MAX value against every journey. So, in the example above, I'd expect to see A-B journey with 3 against the value.
This might help:
A-B - 1
A-B - 3
A-B - 2
C-D - 5
C-D - 2
C-D - 1
A-B = 3 for all A-B’s present
C-D = 5 for all C-D’s present
Does anyone know how to do this? I've been trying to use a MAXX to disaggregate but I can't seem to find a way to make it work!
