Last seen: May 2, 2025
I believe the attached file contains a working PQ solution. It's not very fancy but it does the job. A number of custom columns that pick-up the corre...
Please upload the file shown in the picture. Then we don't have to recreate your scenario from scratch.
@mrm See attached!
@Mrm Not sure either what your intentions are but if you want the slicer to control both pivot table based on the 'Resource', then you must use the ...
Can you share your file? It's difficult to help based and your description of the problem only.
Oh, but then you should your approach. No need for the intermediate EXTRACT table, provided you are using a modern Excel version, using CHOOSECOLS and...
What do you have in mind? Change something in the EXTRACT table or add a row with relevant data and the scrollable view updates automatically. Am I mi...
Not 100% what you asked for but it could be acceptable for you anyway. The following M-code produces a table that resembles your FINAL sheet. Just poi...
Change the CHOOSE part of the formula to CHOOSE(OrderBy,1,-1) and it shall work.
Please share your file (press the paper clip icon "Attach Files" below the editor where you write your reply) as it's not clear from your question alo...
Still not clear to me. Sorry! Do you really set limits up to 56 hours on a weekly running total basis. For instance, employee 1 worked 2102 hours in 2...
It seems that when an employee works, for example, three full weeks of 40 hours for a total of 120, they only get 3 hours leave. Even though 120 equal...
@j8150outlook-com Sure, that's an option as well.
Well, since you prefer not to work with VBA and if you are on a modern Excel version that supports the FILTER function, you could extend the file with...
@j8150outlook-com Thanks for the file, but I don't understand what I'm looking at or how you want to split it.
