Please refrain from multiposting, continue in the same thread.
I am not doing this because I am a net nanny but because you will have less
chance to get an answer since many regulars routinely flag multipost
messages
as ignore since it is a waste or resources. Since I saw that you were
getting answers from the
person who is IMHO the best authority on pivot tables you probably blew this
one

Given that you "must" use a pivot it makes me think that this is school
work?


--


Regards,


Peo Sjoblom



"HERNAN" wrote in message
...

I need a chart that shows how my client's credit score changed from 2006
to
2007:
I would like to have it in groups by Credit Grades like this:

First column: "A Credits" in 2006: 20 Loans;
... and A credits in 2007: 30 loans.

Second column: "B Credits" in 2006 10 Loans;
...and A credits in 2007: 40 Loans.


Should look like this:

20 30 10 40
A A B B
2006 2007 2006 2007


This chart should come from a pivot table, so what should I have on my
pivot
in order to accomplish that???
Thank you