As for your last question you could either use the GETPIVOTDATA function ( not very flexible) or have a look at this article.
Using the free POWERPIVOT add-in also has it's advantages, but I can't help you much with that one.

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post