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?
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.
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 :(
Exactly