Education Level | Age | Age Range | Employment Status | Gender | Children | Weekly Earnings | Year | Weekly Hours Worked | Sleeping | Grooming | Housework | Food & Drink Prep | Caring for Children | Playing with Children | Job Searching | Shopping | Eating and Drinking | Socializing & Relaxing | Television | Golfing | Running | Volunteering | Master | 60 | 60-69 | Employed | Male | 0 | 660 | 2003 | 30 | 870 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 325 | 325 | 0 | 200 | 0 | Some College | 41 | 40-49 | Employed | Female | 2 | 200 | 2003 | 30 | 620 | 60 | 0 | 0 | 60 | 0 | 0 | 0 | 90 | 590 | 60 | 0 | 0 | 0 | Associate Degree | 26 | 20-29 | Employed | Female | 0 | 200 | 2003 | 12 | 560 | 80 | 15 | 240 | 0 | 0 | 0 | 60 | 75 | 340 | 120 | 0 | 0 | 0 |
| Header 2 | Header 3 | Header 4 | Header 5 | Header 6 | Header 7 | Header 8 | Header 9 | Header 10 | Header 11 | Header 12 | Header 13 | Header 14 | Header 15 | Header 16 | Header 17 | Header 18 | Header 19 | Header 20 | Header 21 | Header 22 | Header 23 | Header 24 | Header 25 | Header 26 | Header 27 | Header 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)