Forum Discussion
Need help getting correct average when using calculated field in pivot table with multiple levels
I need assistance trying to figure out how to accomplish something. I have two fields in my data (Billed Hours and Tech Hrs Available). I am making a calculated field using those fields to come up ...
Hi Michael
DAX is the way to go if you have PowerPivot
You create a measure for Billed Hours and one for Available Hours and then a 3rd for Proficiency %
This will then give you the result your after