Hi,
my date looks like below
Customer Old Grade New Grade
ABC 1 2
DEF 1 2
XYZ 1 3
MNO 1 4
Pqr 2 1
so on....
now my issue is I need a pivot table with columns old grade, new grade and count of customers where grading has been switched from old grade to new grade..
my result should look like
New Grade
1 2 3 ............
old grade 1 2 -------->( here count 2 is there are two customers (ABC,DEF) whose grading has been moved from 1 to 2).
Plesase note : I'm ok if the results can be achieved using anyother chart.
Any help is highly appreciated.
