How to include two dimensions in TreeMap?

[system]

Hi…

I would like to create a Treemap with two dimensions.
For example consider the below data with four columns.
State| Product | Sales |Profit
ABC | Product1 | $34 | 23%
PQR | Product2 | $12 | 7%
XYZ | Product3 | $12 | 7%
MNO| Product4 | $25 | 15%
DEF | Product5 | $23 | 14%
ccc | Product6 | $12 | 7%

Now how can i populate this data into Treemap?
Values(size) and Values(Color) is we can maintain as Sales and Profit respectively.

But when coming to labels part, how to maintain the State and Product columns.

Please suggest me, to populate data into Treemap if we have more than one dimension.

Thanks,
Ram

---

rbogireddy (BOB member since 2011-06-13)

[system]

On the General Tab, Under “By Series”, click the + button at the bottom of the series and configure your separate series. Your dimensions need some similarity, such as Same State or Same Product. In your example each row is different. Tree maps are not to be used for that purpose.

example of good data:

State	Product	Price	Market Share
MA	Product A	 $10 	5%
MA	Product B	 $21 	14%
MA	Product C	 $27 	15%
MA	Product D	 $36 	7%
PA	Product E	 $33 	12%
PA	Product F	 $15 	21%
PA	Product G	 $35 	26%

---

Cairmor (BOB member since 2008-06-05)