pivot table report

[arytxer]

Hi I am trying to create a pivot table report to find out how much profit each client has made and I need the total profits to be added up for each client so I can see who has made the most/least.

I have attached a sample ss.

[popipipo]

Something like this?

[jemmers]

I went simplistic and just did Client and total profit.

I do like the separation of the other table though, easy to see which thing profited the most.

[arytxer]

Thank you but I am still struggling with the data.

I need to see a report that returns results as follows so I can see at a glance who is profitable and who is not.

Client Name Client Contract Number
b b11 200.00
c c12 300.00
F F45 800.00
i i34 900.00
a a11 1,200.00
D D33 1,500.00
K K23 2,100.00
u u59 2,100.00
y y90 2,500.00
T T22 2,600.00
S S88 3,200.00
e e23 4,800.00
r r99 6,400.00
W W56 6,500.00