Pivot Table

[fmfabbri]

I have the following data

Year Expense
1994 200
1995 250
1996 300
.
.
.
2004 350
2005 350

Now, let's say I want to run a pivot table grouping year 1995 and prior, so it looks this way.

prior 450
1996 300
.
.
.
2004 350
2005 350


I tried creating a new field for year and doing an IF statemet so it groups years prior to 1996 with the name "prior", which groups the data ok, but shows the prior at the bottom right below 2005. Any ideas how to do the same but the "prior" bucket showing up on top?
Tks!

[steven1001]

in your new field populated by the IF statement use something like..
=if(<year> is < 1995,"Prior","Yr"&<year>)
Then the year values will all be strings and "P" comes before "Y"

or create a pivot table showing all years, select 1994 and 1995 with the mouse, right-click and select Group and then change the created label to "1995 and earlier" or equivalent.