2 Replies Latest reply on Sep 20, 2016 11:13 PM by Trevor Hungerford

    How can I tally up number of combinations of a particular result

    Trevor Hungerford

      Hi all,

       

      This will be hard to explain, but I'll give it a crack.

       

      I have a view of data which shows per truck visit at our site (trk key), the configuration of the containers on the back of the truck (Columns are D and R for Trans Dir, meaning receival and delivery, i.e. containers on and off the truck. And the slot is the position on the back of the truck). Size is the length of container, ie. 2 = 20ft, 4 = 40 foot

       

      Some combinations of containers on the truck are more common than others, e.g. a container in slot 1.

       

      I want to have a view that summarizes the number of times a particular combination occurs.

       

      Any ideas?