Hi,
I have created a pivot table with slicers. I can't quite get the month slicers working.
Please see below table which records the number of days that people are absent:
absense data.jpg
The above formula under the total days columns calculates the difference between date from and date to, it excludes holidays which i've listed else where on the worksheet. This works perfectly.
I'm having problems with below pivot table based on above data though. As you can see below i've created a date from slicer. But when I select just january for Jeff Banks, it shows 45 days. But 45 days spans Jan-Feb. I can't seem to display figures purely based on january. This deems the month slicer useless. Am I doing something wrong here? Any help appreciated as I'm banging my head on a wall
pivot table.jpg
Bookmarks