Pivot Page Field: Multi-criteria select?

[pete234]

I exported a pivot from Access. While in Access I had options for page fields, for instance, I could select 2 dates by checking the boxes. I believe in Access they are referred to as "filtered fields".

Now that the pivot is in Excel, I can only select one page field at a time---in this case only one date. Is there anyway to allow multi-criteria select for a page field? I want this to be up to the user and I'm trying to keep the data condensed so don't want more worksheets made from those fields. I've checked a couple resources including this forum and it doesn't seem possible but thought I might be missing something. Thanks, Pete

 

[RoryA]

You can have that if the data comes from an OLAP cube, but not otherwise, though if you right-click the field and choose Field Settings, you can hide items.

 

[DonkeyOte]

No, not AFAIK at least... you would need to make the page field your first ROW Field and then select whichever options you wanted from there.

EDIT: Thanks Rory, I did not know that re: OLAP.

 

[pete234]

Thanks, I figured I might have to use the row field. Not a huge deal for this report but thought I'd check.

 

[Fazza]

Hi Pete,

There is a simple answer to this, I think, though as it hasn't been mentioned maybe I am misunderstanding the question. I know nothing about exporting a pivot from Access.

For a normal Excel pivot table though, drag the page field to become a row (or column) field, select the field/s you want, drag the field back to be a page field.

HTH, Fazza