Hi, I'm trying to create a pivot that shows the % of chargeable hours per month per employee. Is this best done with a formula, or pivot? Each row (35k+) of data contains an employee's time entry, per day, per project and includes a Chargeable "yes/no" field.
Is there a way to show the % Utilized (Chargeable Hours/(Chargeable + Non-Chargeable Hours). I'd basically like the pivot to show only the % Yes for each month. I can't figure out the best way to do this.
