Showing sums in different columns, dependent on certain value

[#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 would like to show these Sums not in Rows but in Columns:

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

Please, can anyone help?

Thank you very much,
Martin

[#2 · Accepted solution]

just click and drag the column to the top of the rows. It will display column wise.

[#3]

Hi Richy,

thank you for the quick response.

But I can not click and drag the column to the top. How can I do this?

I am using QlikView 7.52, is that the problem?

Is that described in the QV help? Topic?

Thanks again,
Martin

[#4]

Oh, wait, now I got it.

I didn't have the right properties ("Presentation") in my Pivot.

I had activated "Show all layers" ("Alle Ebenen sichtbar" in german). And I had deactivated "Interactive Pivot".
After deactivating "Layers" and activating "Interactive" again I could drag like you said.

Thank you very much.
Martin