The fast way to do this is to click anywhere in the pivot table, then on the options tab, click OLAP tools, convert to formulas. If you are prompted to convert the filters, click yes. If you have to many filters, the conversion won't happen and you'll have to try again without including the filters which will remain in pivot table form. If you aren't familiar with cube formulas, you'll want to check the help topic, as you can extract data directly from the source via cubevalue, cubemember etc.
Bookmarks