Make a filter for header row in pivot table

[Hasek]

Hello everyone,

I am a kind of newbie with pivot tables and this is my first question on this forum.

Suppose that I have some data in table and want to create a pivot table on its basis with the ability to filter not just columns, but also rows (motivation is to compare something side by side). How can I do it?


Please take a look at the attached screenshot, this is a piece of the table which I want to use for creating a pivot.

Currently I can configure it in PivotTable Fields as:
- Filters: None
- Columns: Values
- Rows: My first column from original table
- Values: All other columns from original table

Then I am able to filter first column just using an ordinary filter, but is it possible to also filter a header and customize number of displayed columns in pivot table?

Thanks in advance. Any help will be very appreciative.

 

[Hasek]

Sorry, there is something wrong with screenshot in my original post and I can't see how to edit it. Please find screenshot in this reply.