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

name	sex	age	dept
mary1	f	39	hr
linda1	f	26	it
kim1	f	19	sales
allen1	m	38	it
adam1	m	49	marketing
mary2	f	50	sales
linda2	f	61	marketing
kim2	f	26	hr
allen2	m	26	it
adam2	m	27	sales
mary3	f	59	it

<colgroup><col span="3"><col></colgroup><tbody>
</tbody>

 

[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