I need help on a transaction search. I am trying to get breakout columns of the tax group by state, county, then city. How do I target the individual tax rates in a saved search? Anybody ever do this? If I expose the tax line, I can see them in rows, but how can i get columns?

Create a workbook

Maybe, but not what I’m looking for. I finally found the correct method: Formula (Text) Maximum CASE WHEN {taxitem.taxtype} = ‘County’ THEN {taxitem.taxtype} END Tax County Tax County Formula (Percent) Maximum CASE WHEN {taxitem.taxtype} = ‘County’ THEN ({taxitem.rate}/100) END Tax County % Tax County % Formula (Text) Maximum CASE WHEN {taxitem.taxtype} = ‘State’ THEN {taxitem.taxtype} END Tax State Tax State Formula (Percent) Maximum CASE WHEN {taxitem.taxtype} = ‘State’ THEN ({taxitem.rate}/100) END Tax State % Tax State % Formula (Text) Maximum CASE WHEN {taxitem.taxtype} = ‘City’ THEN {taxitem.taxtype} END Tax City Tax City Formula (Percent) Maximum CASE WHEN {taxitem.taxtype} = ‘City’ THEN ({taxitem.rate}/100) END Tax City % Tax City %