pivot table filter

[deck-b]

Hi All

Is it possible to arrange a pivot table filter horizontally rather than vertically?

 

[sitewolf]

Wouldn't you just move row labels to column labels and vice versa if there are any?

 

[deck-b]

No, i just want to rearrange the actual filter box horizontally across the top of the pivot table

 

[63falcondude]

No, i just want to rearrange the actual filter box horizontally across the top of the pivot table

I think what you are saying is that you want to filter your horizontal categories (values). This can be done with the pivot table set up normally through the little drop down box next to Row Labels. Check out Value Filters.

 

[deck-b]

No, i have 10 fields in the filter box, these are using up 10 rows of my page. Can i move reposition these fields horizontally across the top of the sheets so that they wont use 10 rows of the page?

 

[63falcondude]

No, i have 10 fields in the filter box, these are using up 10 rows of my page. Can i move reposition these fields horizontally across the top of the sheets so that they wont use 10 rows of the page?

Oh I understand. You have 10 fields in the Report Filter box of the Pivot Table Field List and that is taking up 10 rows above your Pivot Table.

Read this towards the bottom http://www.contextures.com/Excel-Pivot-Table-Report-Filters.html

 

[deck-b]

Perfect, thank you 63falcondude!

 

[63falcondude]

Perfect, thank you 63falcondude!

Glad to help.