IT always better to include your workbook Packaged workbooks: when, why, how
It gives a data base to work from but that said I have a question for you -
the fixed function that you are using will create permutations on all the dimensions that preceed the colon and then aggregate them on what follows th colon -so in identifying the truck movement you aggregating teh fixed expression across -pick up address - delivery address - truck id2 - start date - and movement code - do you really need to get to that level to count the containers on a TRUCK and Movement code - seems like adding the other dimensions into your formula is creating a problem you don't need
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.