mdx - Adding YTD, YTG column to Excel OLAP Pivot -

I have an Excel pivot table that connects to the OLAP cube, such as

  January February March ......... December Revenue 55 32 65 .......... 45  

I would like to add additional columns YTD and YTG etc. These have already been measured in my cube, but when they are added to the pivot table, it is not surprising, months are repeated for each measurement.

I just need columns at the end, like

  Jan Feb Mar ......... Dec YTD YTG Revenue 55 32 65 ..... ..... 45 654 30  

Is this possible?

I have found a solution, although an unqualified originally created members calculated for Jan-December And these reports are used as columns.

As I said, rude, but customers like it.