This project has moved and is read-only. For the latest updates, please go here.

Month and YTD next to each other

Topics: Resolved
May 13, 2009 at 7:38 AM

Hi,

can anyone help me out with the following problem.

We want to have the revenue for a month next to the revenue YTD. Is there anyway we can make a calculation over several rows in the pivotable?

Thanks

May 13, 2009 at 4:02 PM
Edited May 13, 2009 at 4:03 PM

I would build your PivotTable just as you want, but without the YTD part. Then I would use OLAP PivotTable Extensions to capture the exact MDX. Then I would post that MDX and your desired report layout and your question on the SSAS forums:

http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/threads/

Sorry. I can't really answer generic MDX questions on this discussion board. Once you've got the MDX for that YTD calculation figured out, you should be able to easily add that calculation to the PivotTable using OLAP PivotTable Extensions.

Marked as answer by furmangg on 6/10/2014 at 3:51 PM