Forum

Bee
@bee
Eminent Member
Joined: Apr 11, 2025
Last seen: Oct 8, 2025
Topics: 4 / Replies: 12
Reply
RE: Getting the correct total of FTE per quarter using Pivot table

@riny Hi, I’m running into an issue with my slicer and the pivot info for the file I mentioned a couple of weeks back. When I input the new hours for ...

1 month ago
Reply
RE: Getting the correct total of FTE per quarter using Pivot table

@riny Thanks for your time on this. I'll have a look 🙂

2 months ago
Reply
RE: Getting the correct total of FTE per quarter using Pivot table

@riny Please see the attached file with pivot and slicers Notes: The FTE calculation works fine for each month. When I try to get FTEs for c...

2 months ago
Reply
RE: Getting the correct total of FTE per quarter using Pivot table

@riny Yes. Please see the anon file attached. let me know if you are having issues with the file. Again, thanks!

2 months ago
Reply
RE: Getting the correct total of FTE per quarter using Pivot table

I want the report to be dynamic where if I select the month in the slicer, it will show the correct FTE total for the month and if I select 3 months i...

2 months ago
Reply
RE: Getting the correct total of FTE per quarter using Pivot table

@riny thank you. I have splicers connected to the Pivot. Will it dynamically work if I go back to choosing per month

2 months ago
Reply
RE: Filter Function using Drop down excluding one category.

@riny This works! Thanks, as I didn't know about the function "<>". Again Many thanks! 😊

6 months ago
Forum
Reply
RE: Filter Function using Drop down excluding one category.

Thank you for the response. The structured table is located in another sheet, as shown in the attachment. The initial attachment above is where I'm tr...

6 months ago
Forum
Topic
Forum
Replies: 4
Views: 712
Reply
RE: SUMIF is not working

@riny Sorry, I can't, due to confidentiality, but I have enlarged the photo. let me know if it is still not looking great.

7 months ago
Topic
Replies: 3
Views: 1025
Reply
RE: Append Query duplicating rows in the table

I did it and now it’s working. Thanks, Mynda!

7 months ago
Forum
Page 1 / 2