I have a table of with yards placed to different locations by date. I created a pivot table and now want to use the date filter to get total yards by location betwen the selcted dates. When I use any date filter I get zero results. The dates in the pivot table are right justified which I think means that Excel is not recognizing them as dates (hence no results?) but they are seen as dates in the table (I can sort oldest to youngest which implies Excel sees them as dates).
Why isnt the pivot table allowing me to use the date filter to calculate total yards by location between any two dates.
If pivot tables arent working for this seemingly simple task, what is another approach? Would an index and match be easier? I have Excel 2016
thanks for any thoughts and suggestions
Bookmarks