I have a file that requires power pivot to help. Have attached the file as example, please contact for more details.
Basically need help in rolling up the forecast accuracy and biasness and these are indicated in the file under <instructions>
I would appreciate if you can suggest ways to go around it AFTER you have understood the file - so far, I would think calculated items and calculated fields or powerpivot is the way to go.
Have also included an example of what I need; including how it should be calculated just in case.
I do not think this would take more than 2 hours for anyone who knows powerpivot or calculated items/fields well but let me know if it warrants more time. Freelancer needs to be meticulous, please do not make me check your mistakes for you.. we're adults.
I will strive to assign within a day of posting and if this is completed within a day, I will give completion bonus + good ratings + offer new assignments with you as priority.