Treemap - help - order with two values is possible?

[perpor]

I do not know if it is possible with the current version to create a treemap with two levels of values:

I would like a graph where the most external rectangles are sorted by an index1, and the most internal rectangles with index2.

It seems that with the current version, which accepts only one value as 'values', such as index2, the inner rectangles are ordered correctly, while the rectangles outside have an order that I do not understand

thank you

[perpor]

The two values are indices, values tha can not be summed up, eg. 5.61, 5.45, 5.22, 4.98, etc ... for the index of the most external level,
similar values for the most internal index.
The elements of the most internal level are hierarchically dependent on the external layer:

a11, a12, a13, etc. depend on A1
b11, b12, b13, etc. depend on B1
.....

[perpor]

And in the test chart I used the average of that index...

[perpor]

I mean there are currently two datasets, one for the top and one for the level
lower ones that contain the data, index1 in the first and index2 in the second,
even if the data type is the same, for index1 and index2, for example as sales,

values that are indexes anc can not sum up.
I would like to get this type of graph without having to restructure existing datasets
creating for example a unique index, which I think would solve the problem ...

[Anonymous]

Hi @perpor,

Can you please provide some sample data? I will try it if possible to achieve this.

Regards,

Xiaoxin Sheng