Create buckets of required filter,
if(gross Market<20,'below 20',
if(gross Market>=20 and gross Market<30,'20 to 30',
if(gross Market>=30 and gross Market<40,'30 to 40',
if(gross Market>=40,'above 40'))) as GM
use same for another
filter then add this in pivot base table then you can use them as slicer,
we use slicer in excel as an filter.
where just select pivot and then you will find slicer option in insert tab,
after selecting slicer it will show a option list select whatever slicer you want.