Not easy ! How to do a complex pivot table ??

[zarmoton]

Hello

This is a very light sample to explain my problerm, my database is very huge. So i cannot change to format of the input data., and with creating an intermediate other table

Name seller	Amount	Name Buyer
A	20	C
A	40	A
A	100	B
A	40	B
B	10	A
B	10	A
B	30	C
C	1	A
C	2	D

how to build a pivot to give that, directly link of the table as above ???:

Name	Seller	Buyer
A	200	61
B	50	140
C	3	50
D		2
Total	253	253

Thank you for your help

As you can see the column "Seller" is the result of a pivot table of Name Seller / Sum (Amount)

and the colum "Buyer" is the result of a pivot table of Name Buyer/ Sum (Amount)

[zarmoton]

First thk yu

No, I don’t miss the second table

Your solution is ok for a small table like that, but not enough generic

But now imagine a table with 10 millions of rows, and not with 4 names (A, B C D) but with 5000 names !!!

[Gysbert_Wassenaar]

And that's exactly why you need to fix your data model.

Or compromise and use both fields as dimensions in the pivot table. The totals of the rows and columns give you the buyer and seller totals per name.

[zarmoton]

I’m not at all beginner under qlikview ..

My data model is just very very complex, I have more than 200 tables, application is very huge

I cannot change the model so easily, impact is tremendous!!

I really need to find an answer with the pivot table chart object plug directly on a such data model.