Forum

Notifications
Clear all

[Solved] Getting the correct total of FTE per quarter using Pivot table

19 Posts
2 Users
0 Reactions
1,423 Views
 Bee
(@bee)
Posts: 18
Eminent Member
Topic starter
 

@riny, I’m ran into another issue (again) with my slicer. I entered January 2026 and added the 'Year' slicer, and it messed up the 'months', please see image for reference:

Could you please help me figure out what I did wrong this time? Again, Many thanks!

image

 


 
Posted : 02/03/2026 9:38 pm
Riny van Eekelen
(@riny)
Posts: 1441
Member Moderator
 

@bee 

Hi! Used your latest file and got rid of most of the data as the file is quite big. Added some entries in the first tab (in the Week table and at the bottom of the larger one), marked in yellow to achieve what I think you need. Then a "Year" slicer in the Overview. Let me know if that is what you intended.

 


 
Posted : 03/03/2026 12:56 am
 Bee
(@bee)
Posts: 18
Eminent Member
Topic starter
 

@riny Thanks, you're the best! I'll do just that 😊


 
Posted : 04/03/2026 11:42 pm
Riny van Eekelen
(@riny)
Posts: 1441
Member Moderator
 

@bee Glad I could help!


 
Posted : 04/03/2026 11:58 pm
Page 2 / 2
Share:
0