Forum Discussion
Grouping
Hey I have a column called Age. I want to seperate it as groups like Age 55+ Age 45-55 Age 35-45 How can this be done?
- Hi - Create a calculated column such as
Age Group = SWITCH(True(), [Column Name] <=45, "35-45",
[Column Name] <=55,"45-55","+55")
This is assuming that there are no ages below 35 in have data.
D
Thank You! Bur what comes under column name? The variable Age comes under a table called Students. So would the column name be Student[AGE]?
Hi... Yes it would be the age.