1 Reply Latest reply: May 8, 2017 9:37 AM by Sunny Talwar RSS

    Segment Data from aggregated data

    Stuart Frew

      Hi,

       

      I have an aggregated table that has multiple(13)  flag fields in it that I want to get into 1 field called "Segment"

       

      NORTH_IND

      SOUTH_IND

      WEST_IND

      BLACK_IND

      BLUE_IND

      UP_IND

      DOWN_IND

      etc

      etc

       

       

      In this table there are also multiple fields (15) that I want to be able to SUM by

      NAME_COUNT
      EMAIL_COUNT

      PHONE_COUNT

       

       

      I can get Crosstable to work to get a table that has Segment in it; but I cant work out how to link that table back to the original table so I can SUM those extra fields by Segment.

       

      Maybe there is a better way of achieving this?

       

      Many Thanks

      Stuart