Forum

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

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

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

@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 se...

3 months ago
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 ...

8 months 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 🙂

8 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...

8 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!

8 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...

8 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

8 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! 😊

1 year 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...

1 year ago
Forum
Topic
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.

1 year ago
Page 1 / 2
0