How to display year and month in the Pivot table

[#1]

hi,

Can anyone help me how to achieve the below requirement?

As per the requirement, i need to display period as Nov 2013, Oct 2013,.......Jan 2013, Dec2012.... Jan2010 in the pivot table.We have data for 5 years.

please suggest me some solution for the requirement ASAP.

Thanks in advance.

Smitha

[bruno_m_santos · Accepted solution]

Add in your  Master Calendar

(monthstart(TempDate), 'MMM-YYYY') as MonthYear.

Then use this new column.

[#3]

I usualy create some tables like this, crossing years and months: