How to combine two filters into one in pivot table

I have A3 and A4 as report filters in the pivot table.
Is there any way can combine A3 and A4 into one cell. The new cell is something like drop-down list contains contents from A3 and A4. When picking up the from this drop-down, the corresponding data list will be shown (like the data in B3 and B4).

Thanks!

PivotTable_Filter_01.jpg
PivotTable_Filter_02.jpg

Hi there,

Can you attached your file?

Thanks,

Reimar_rem

The "service_name" has a long list of data and it changes daily. Since I need the dynamically read data from DB, the helper column may not be helpful.
Initially, I wonder whether the PivotTable has the option to merge two filters together. But it seems not.
I finally use the macro to make it work.

Thanks for the reply.

Originally Posted by Richard Buttrey

Why not create a helper column in your data which concatenates the two fields you're interested in then use that new field in the PT.