Excel Pivot Table - Change Columns using Filter

Question

I have a pivot table and values separated by a signal flag (0 or 1). I many different signal types (columns) to use.

Question: Instead of creating a new pivot table for each signal, is there a 'column filter' I can add to quickly change the first pivot table to the second as in the picture?

I can't add the signals as a filter as I need all the data to be used.

Answer 1

you have to rearrange your input table like this

| Team color | Count | Signal Type (1 or 2) | Signal Value |

Then you can slice on the column Signal Type.

s. the concept in this older answer.