4 Replies Latest reply on Mar 4, 2018 7:04 PM by Zhouyi Zhang

    Cannot Categorize and Count Specific Dimension Values

    Mike Bushey

      Hello,

       

      So I have a data set that is broken down into a main shipping number and then a number of boxes for that shipment. I am trying to break the shipping numbers into two categories: Ones with premium paper and ones without premium paper. I then want to count these two categories.

       

      Where I am running into issues is the fact that each shipping number has different boxes.

       

      My data looks like this:

       

      Screen Shot 2018-03-02 at 9.15.50 PM.png

      This is what I have got it to so far:

       

      Screen Shot 2018-03-02 at 9.17.44 PM.png

       

      What I want to get to is this:

       

      Screen Shot 2018-03-02 at 9.17.44 PM.png

      Screen Shot 2018-03-02 at 10.02.34 PM.png

       

      Essentially I only want one line per shipping number and I want it to say whether that shipment has premium paper or no premium paper.

       

      I have tried various different formulas and options and for the life of me cannot get this. Any help would be greatly appreciated. Once I have the two categories I plan to show the trends of the two by date on a line chart.

       

      Thanks,

       

      Mike