Hi There. I am Bing and I look forward to helping you with your issue today. Please give me a bit more time to review your question.
Sorry I can't update the given Excel file due to a lower version (I am using Excel for Mac 2011). I am opting out and let other experts help you.
Okay as no other experts come in, I am back for a few words.
Basically, your requirement is to make a Pivot Table from data in multiple source or sheets. This can be done. Please check here for the detailed steps.
You may try it yourself. Just hope I have addressed your question. :)
If I understand that correctly, you may get the formula by clicking on the Info button of related field to get the formula used for that field. See the attached screenshot.
Okay, as I don't have the right Excel version for your question, I opt out again. Good luck!
I have considerable experience that will enable me to solve this for you. Would you be so kind as to wait until tomorrow morning, when I can attack the problem fresh? It has been a long day, and it is getting late here on the East Coast. Thank you for your anticipated patience and cooperation.
Any particular reason you couldn't use a generic Excel formula? PowerPivot limits you sharply in backward compatibility. I have been able to solve "impossible" problems using routine formulas on many occasions. All it takes is a clever approach.
You haven't stated what "the measure" is. What is this formula supposed to achieve--precisely?