0 Replies Latest reply: Nov 28, 2017 8:15 AM by Baarathi V RSS

    Grouping field names as legends

    Baarathi V

                           

      Education LevelAgeAge RangeEmployment StatusGenderChildrenWeekly EarningsYearWeekly Hours WorkedSleepingGroomingHouseworkFood & Drink PrepCaring for ChildrenPlaying with ChildrenJob SearchingShoppingEating and DrinkingSocializing & RelaxingTelevisionGolfingRunningVolunteering
      Master6060-69EmployedMale066020033087040000000532532502000
      Some College4140-49EmployedFemale22002003306206000600009059060000
      Associate Degree2620-29EmployedFemale020020031256080152400006075340120000
      Header 2Header 3Header 4Header 5Header 6Header 7Header 8Header 9Header 10Header 11Header 12Header 13Header 14Header 15Header 16Header 17Header 18Header 19Header 20Header 21Header 22Header 23Header 24Header 25Header 26Header 27Header 28

      From the above table, I want to calculate total hours spent on sleeping, grooming, etc. basically what I want is to have field names as legends and find aggr on them, in my expression I want this aggr(Sum(sleeping, grooming, etc), Year)