I am bringing data from SQL SERVER as data source in my Excel 2010. One of Column on my Data_Source Worksheet is named Fiscal_Quarter. This column has values Quarter1,Quarter2,Quarter3,Quarter4.
I am going to create pivot table from this source data.
I want to see in my pivot table those values not as Quarter1,Quarter2….but as Qrt1,Qrt2,Qrt3,Qrt4.
How to do this.