Forum Discussion
Pivot Tables
I have a table named Hours with three columns; Cost Code, Description, Allowance. I have another table named Tracked Hours on a different sheet that has four columns; Employee (drop down using data ...
Can you expand on your answer so I know how exactly this works and how to do it myself in the future. A step by step guide would be extremely helpful.
Thank you.
Thank you.
rdwmatt I'm sorry, but a step-by-step guide explaining how it all works goes beyond the scope of my involvement in this user forum. I don't have time for that.
But you could invest some time yourself learning basic DAX. Learn what measures are and then use on-line resources to read about the functions used in my examples. Though, be prepared that DAX is far from intuitive or user friendly. At least, that's my personal opinion. It takes a considerable effort to master it. An I am still a long way away from that point.
Thank you, I appreciate the help. I will look into DAX and study up.