Pivot filtering from date to date

vezzanimarco

New Member
Joined
Jun 30, 2015
Messages
2
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
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

AlexandraT

Board Regular
Joined
Mar 23, 2015
Messages
144
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

New Member
Joined
Jun 30, 2015
Messages
2
Thank you Alexandra but I didn't get exhactly what you mean?

can you please make me an example?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,326
Members
414,053
Latest member
Dual Showman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top