In the pivot table, put Original CS in the Row area, Updated CS in the
Column area, and Count of Original CS in the Data area.
The Grand Total at the right will show the original totals per grade.
The Grand Total at the bottom will show the updated totals per grade.

Or, instead of using a pivot table, use the COUNTIF function to
summarize the data. For example, list the grades in cells G2:G6, then in
cell H2, enter the following formula, to summarize the original CS:

Original CS
A+ =COUNTIF(B:B,$G2)
A
B
C
D


HERNAN wrote:
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





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