Month Year dimension displayed as a month

[#1]

hi bit stuck here !

I have a pivot table which is meant to show the last 13 months of data so Dec 2014- Dec 2015

The thing is I need the headers to show the months without the year, but its grouping the value for Dec 2014 and Dec 2015 together (attached an example )

Anyone got any ideas how I can meet this requirement ?

Thanks

Sarah

[sunny_talwar · Accepted solution]

Try this as your calculated dimension:

=Dual(Left(Month_Year,3), Date#(Month_Year, 'MMM YYYY'))

[#3]

Perfect thank you Sunny !

[#4]

Try like below:

LOAD

  * ,

  Num(Date#(Month_Year,'MMMM YYYY')) AS Month_YRDate,

  Left(Month_Year,3) AS Month_Name

INLINE [

Month_Year,ID

Dec 2014, 1

Jan 2015, 1

Feb 2015, 1

Mar 2015, 1

Apr 2015, 1

May 2015, 1

Jun 2015, 1

Jul 2015, 1

Aug 2015, 1

Sep 2015, 1

Oct 2015, 1

Nov 2015, 1

Dec 2015,1

];

Create calcualted diemension like below:

Dual(Month_Name,Month_YRDate)

[sunny_talwar]

No problem

[#6]

attached qvw file.