CAN NOT insert a measure into a combination chart,why?

[lastsummer]

Hi,
I want to insert multi measures into a combination chart, but when i dragged a measure into the chart, there is a error message appeared, 'You hava attempted to place an additional measure in the default measure area.Nest or union additional measures on the appropriate edge.'
How can I do to insert addtional measure into the chart?

[rockytopmark]

Pivot your data first, and I would say a UNION query would be necessary.

Your data looks like this, for example:

Year	Prod	Qty	Rev
2004	ABC	100	50000
2005	ABC	120	60000
2006	ABC	140	70000

But you need this:

Year	Prod	Measure	Value
2004	ABC	Qty	100
2005	ABC	Qty	120
2006	ABC	Qty	140
2004	ABC	Revenue	50000
2005	ABC	Revenue	60000
2006	ABC	Revenue	70000

... so that you can use the Measure query item in the Chart's Series (You can have multiple Series) and your Value item as the Measure.

[lastsummer]

Thanks for your reply.
As you said, I only can have multi series, but can not have multi measures?
I had thought combination chart can has multi measures :(

[rockytopmark]

Exactly