Month, but not as serial + sort

[Egg 'n' Bacon]

Hi, I've been asked to produce a pivot chart(in 2007) that has the title; "Supplier Performance Month Year" (with the month and year supplied form data) eg "Supplier Performance May 2010"

I've currently got;
=IF(A6="","","Supplier Perfomance " & MONTH(A6) & " " & YEAR(A6))
but of course, this gives the month serial, not the word of the month.

Secondly (this has been SO long since I played with pivots), how to sort the data according to result, i.e. lowest scores first

[HansV]

You can use the TEXT function to get the month name:

=IF(A6="","","Supplier Perfomance " & TEXT(A6,"mmmm") & " " & YEAR(A6))

or use the TEXT function to get both month name and year:

=IF(A6="","","Supplier Perfomance " & TEXT(A6,"mmmm yyyy"))

[HansV]

BTW, shouldn't it be "Performance" instead of "Perfomance" in the formula?

[Egg 'n' Bacon]

Hans, just what I was after

I thought I had figured the sort, but no. Is there a setting to sort the results on refresh?

[Egg 'n' Bacon]

BTW, shouldn't it be "Performance" instead of "Perfomance" in the formula?

As one of our girls says; Ive got silly fingers today. Doh!

[HansV]

Is there a setting to sort the results on refresh?

Click in any cell of the data area.
Click the Sort button in the ribbon.

[Egg 'n' Bacon]

Ah, I thought I remembered something in the pivot settings.

Ho hum