Calculated SSAS Measures in Extract RRS feed

  • Question

  • Hi,

    I'm using power pivot to retrieve data from a SQL Server 2008 R2 SSAS Cube.  Within my cube I have Prior period measures (YOY sales pct change).   When power pivot downloads the data locally, the percentage is maintained; however, when I create my pivot table, I can't find a format to display the percentage.

    The Excel pivot either sum's up the pct - not good or will count it; also not good.

    How can I show this percentage data point without any intrusion on it's native use?





    Monday, December 6, 2010 6:50 PM