Yes I would like something like this:

60 40 75 25
35 65
A+ A+ A A
B B
Original CS Updated CS ; Original CS Updated CS ; Original CS
Updated CS

Total Loans 100, so 60 Loans were A+, and now I have 40 A+, the same with A,
B etc


"Debra Dalgleish" wrote:

Can you type a couple of rows of sample data, and how you'd like that to
appear in the pivot table?

HERNAN wrote:
I need to create a graphic that reflects the credit grades variation of my
clients.

So for each grade I would need two columns, old grades, and Uptdated grade,
ie:

"A+" column should have "old Credit Grades" and "updated credit grades",
then A, B, C and D the same criteria.

I don't know how to put it on my pivot table layout, I try to combine the
data in different ways: column, data and row, but I never get to what I want.
Please Help!!

ps: I also have "loan numbers" and "loan balance" columns that I can use on
the pivots if needed.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html