3 Replies Latest reply on Jul 28, 2018 10:02 AM by Deepak Rai

    Adding Two Summaries

    Paula Sims

      Hello,

      I below is a sample dataset. I have categories and delivery statuses based on State One criteria and StateTwo criteria. Each criteria is distinct, with some categories only subject to one state criteria than the other  (note PONIES only is subject to STATE TWO criteria)

       

      CATEGORYDELIVERY STATE ONEDELIVERY STATE TWO

      PENS

      ON TIMELATE
      CHAIRSLATEON TIME
      BOOKSLATEON TIME
      COMPUTERSON TIMEON TIME
      GROCERIESON TIMEON TIME
      PONIESON TIME

                                            

      DELIVERY   STATE ONEDELIVERY STATE   TWOCATEGORY
      ON TIMELATEPENS
      LATEON TIMECHAIRS
      LATEON TIMEBOOKS
      ON TIMEON TIMECOMPUTERS
      ON TIMEON TIMEGROCERIES
      ON TIMEPONIES

       

      What I seen are summaries of each state separately and then together

       

      STATUSDELIVERY STATE ONE
      LATE2
      ON TIME3
      TOTAL5

       

       

      STATUSDELIVERY STATE TWO
      LATE1
      ON TIME5
      TOTAL6

       

       

      STATUSTOTAL
      LATE3
      ON TIME8
      TOTAL11

       

      I know this is an LOD thing but I'm not sure how. Everything I've tried gives an incorrect answer

       

      Thank you!

      Paula

       

      Message was edited by: Paula Sims