Can you create a Pivot table that can filter and change the column data??

Hello

I want to create a Pivot table to display previous results (rows) against current results (columns) and count the number of records, so I can see how many records have increased results.

For the previous results I'm using an average so this data will remain the same there but there are results for different tests that I'm showing in the columns and curious to know if I can include a filter within the Pivot table to change the data displayed in the columns.

Can this be done with a Pivot table or should I try and build this manually with some formulas and vba controls and code?

Any advice would be much appreciated.

Thanks, Harry