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.
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.