Pivot Table Filters

J

julievandermeulen

Board Regular
Joined
Jan 25, 2020
Messages
64
Office Version
  1. 2013
Platform
  1. Windows
I have a pivot table that I want to filter by date. The date in the data source is formatted as short date, but for some reason in my pivot table filter it is a number (ex. 44,502) how can I change it so the filter will work?
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
You must log in or register to reply here.

Similar threads

B
  • Question
Pivot table errors
Replies
4
Views
228
Alex Blakenburg
A
J
  • Question
Filter Pivot Table Generated From PowerQuery Data Model
Replies
1
Views
73
jdorby
J
F
  • Solved
Problems filtering a Pivot Table with VBA
Replies
2
Views
173
Domenic
D
B
  • Question
Why are separate pivot charts being filtered simultaneously?
Replies
4
Views
60
Alex Blakenburg
A
B
  • Question
Pivot Table question - could be impossible to implement
Replies
0
Views
515
buroh
B

Forum statistics

Threads
1,214,642
Messages
6,120,698
Members
448,979
Latest member
DET4492

Share this page

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
Back
Top