Slicer for age groups

[lezawang]

Hi
I have a table like the one below. I inserted a table then I inserted Slicer for age. So I can use the slicer to filter. My question, can I group age into group like this

18-30
31-50
51-65

So the slicer can show only 3 groups only. I know that can be done in Pivot table but can it be done here with a regular table not pivot? Thank you very much

[TABLE="class: grid, width: 312"]
<colgroup><col span="3"><col></colgroup><tbody>[TR]
[TD="align: left"]name[/TD]
[TD="align: left"]sex[/TD]
[TD="align: left"]age[/TD]
[TD="align: left"]dept[/TD]
[/TR]
[TR]
[TD="align: left"]mary1[/TD]
[TD="align: left"]f[/TD]
[TD="align: right"]39[/TD]
[TD="align: left"]hr[/TD]
[/TR]
[TR]
[TD="align: left"]linda1[/TD]
[TD="align: left"]f[/TD]
[TD="align: right"]26[/TD]
[TD="align: left"]it[/TD]
[/TR]
[TR]
[TD="align: left"]kim1[/TD]
[TD="align: left"]f[/TD]
[TD="align: right"]19[/TD]
[TD="align: left"]sales[/TD]
[/TR]
[TR]
[TD="align: left"]allen1[/TD]
[TD="align: left"]m[/TD]
[TD="align: right"]38[/TD]
[TD="align: left"]it[/TD]
[/TR]
[TR]
[TD="align: left"]adam1[/TD]
[TD="align: left"]m[/TD]
[TD="align: right"]49[/TD]
[TD="align: left"]marketing[/TD]
[/TR]
[TR]
[TD="align: left"]mary2[/TD]
[TD="align: left"]f[/TD]
[TD="align: right"]50[/TD]
[TD="align: left"]sales[/TD]
[/TR]
[TR]
[TD="align: left"]linda2[/TD]
[TD="align: left"]f[/TD]
[TD="align: right"]61[/TD]
[TD="align: left"]marketing[/TD]
[/TR]
[TR]
[TD="align: left"]kim2[/TD]
[TD="align: left"]f[/TD]
[TD="align: right"]26[/TD]
[TD="align: left"]hr[/TD]
[/TR]
[TR]
[TD="align: left"]allen2[/TD]
[TD="align: left"]m[/TD]
[TD="align: right"]26[/TD]
[TD="align: left"]it[/TD]
[/TR]
[TR]
[TD="align: left"]adam2[/TD]
[TD="align: left"]m[/TD]
[TD="align: right"]27[/TD]
[TD="align: left"]sales[/TD]
[/TR]
[TR]
[TD="align: left"]mary3[/TD]
[TD="align: left"]f[/TD]
[TD="align: right"]59[/TD]
[TD="align: left"]it[/TD]
[/TR]
</tbody>[/TABLE]

 

[mrshl9898]

You'll need to turn it into a table if you haven't already (click in the data and press ctrl + T).

Then add a column =IF([@age]<31,"18-30",IF([@age]<51,"31-50","51-65"))

You can then slice that