Pivot filtering from date to date

[vezzanimarco]

Hello,
I have a to work a lot with pivot and, sometime, I need to select a group of dates or a group of codes.
I don't know if there is the possibility to filter from date to date. Right now I flag each date but sometimes it's a long way...

Another problem is to make a selection from a list of codes not "from to" in this case. I need something like code1,code2,code3 to put in the filter cell.

Example 1 from data to data
28/02/2014
03/03/2014
12/03/2014
28/03/2014

Example 2 list of code to filter:
EAC06
EAC07
EAC10
EAC11
EAC12

thanks

 

[AlexandraT]

You can add the Date to the "Filters" field (next to the Column field and above the Rows and Values fields). Or you can use slicers. Would that help?

Alex

 

[vezzanimarco]

Thank you Alexandra but I didn't get exhactly what you mean?

can you please make me an example?

 

[AlexandraT]

Try this: https://support.office.com/en-us/ar...votTable-cc1ed287-3a97-4e95-b377-ddfafe79fa8f

It shows how to use Slicers.

Or you can try the filter area in the Fields List (like "Country" is used in this example: https://support.office.com/en-us/ar...votTable-43980e05-a585-4fcd-bd91-80160adfebec)

Alex