Hi,
I want to have "custom order" in the Report Filter of pivot table.
Example1:
I have Geography filter & has filter values at different levels as Country, State & City.
In the raw data (for Pivot table); I have sorted in below order for a particular month. But the pivot table, is displaying it in alphabetical order.
Is there any way to display in custommized format?
Format Needed:
USA (Country)
New York (State)
New York City (City)
Buffalo (City)
California (State)
San Mateo (City)
San Jose (City)
Germany (Country)
Currently Displayed:
Buffalo (City)
California (State)
Germany (Country)
New York City (City)
New York (State)
San Jose (City)
San Mateo (City)
USA (Country)
Example2:
Time is getting displayed in below format:
August 2011
July 2011
June 2011
When I would like it to be displayed as:
June 2011
July 2011
August 2011.
Any ways to have it in pivot table report filter?
Thanks
Bookmarks