Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Would you be able to share few rows of actual data and explain what you want to see as the output?