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