![]() |
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. |
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