ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I choose more than one item in the page field area? (https://www.excelbanter.com/excel-discussion-misc-queries/139479-can-i-choose-more-than-one-item-page-field-area.html)

trainer07

Can I choose more than one item in the page field area?
 
If I drag a field to the page field area of a pivot table and in that field
are names of different regions (North, South, East, West), can I see
information on more than one region at a time? I can't seem to figure out a
way to select both North and South.

Satish

Can I choose more than one item in the page field area?
 
Drag the field from Page field to Row Area, Select North & South from drop
down menu and then put the field back to Page field area. Now you should be
able to see both North & South.

"trainer07" wrote:

If I drag a field to the page field area of a pivot table and in that field
are names of different regions (North, South, East, West), can I see
information on more than one region at a time? I can't seem to figure out a
way to select both North and South.



All times are GMT +1. The time now is 11:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com