Showing sums in different columns, not rows

[#1]

Hi,

I have the following tables:

No | Client | Amount | Kind
1 C1 5 a
2 C2 10 b
3 C1 8 a
4 C1 2 c

Kind | Code
a "60%"
b "80%"
c "100%"

With a Pivot I can show (for example):

Client | Code | Sum(Amount)
C1 "60%" 8+5=13
C1 "100%" 2

But I need these Sums not in Rows but in Columns:

Client | "60%" | "80%" | "100%"
C1 13 0 2

Can anyone help?

Thank you very much,
Martin

[Anonymous]

In the Pivot table that you have designed, drag the code field to the Header. The blue line for "Code" field should change from a vertical line to a horizontal line. Should give you what you want.

JS

[#3]

Yes, thanks, double entry.

See the post "Showing sums in different columns, dependent on certain value"