Chart question

[#1]

I have a table that contains an amount of sold items, in another table the unit for the sold items are located, they are connected with a field for salesman,

If I make a chart it will be displayed like this:

100100

Salesman	Amount	Unit
Mr A	Volvo
Mr A	BMW

Is there a way with set analysis to make it display as this?

100

Salesman	Amount(Volvo)	Amount(BMW)
Mr A	100

[ecolomer]

use a pivot table with dimension Salesman and Amount, and expression sum(Unit)

[awhitfield]

HI Henrik,

you would use a pivot chart:

See the attached simple example

HTH Andy