Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Add in your Master Calendar
(monthstart(TempDate), 'MMM-YYYY') as MonthYear.
Then use this new column.
Add in your Master Calendar
(monthstart(TempDate), 'MMM-YYYY') as MonthYear.
Then use this new column.
I usualy create some tables like this, crossing years and months: