I think I understand
try using this
it returns this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Profitability_v10.5.twbx 17.3 KB
Thank you Jim Dehner. it works perfectly. I got another issue. In the attached file, I've added
- region and
- billable and non billable clients.
To calculate the overhead driver,
- I need to divide Individual Client hours (by) Total Region Hours and
- I need to filter out Non Billable clients from the calculation. I tried to use exclude function. But I'm missing something.
Hope you can help. Attaching the file for reference.
there is no file attached
Please break this out into a separate post and attach the TWBX file you referenced