Is it possible to create a reverse treemap?

[Anonymous]

Hi,

I was wondering if it's possible to create a treemap where the lowest values have the biggest portions on the treemap as opposed to how it is now?

For example, if I have 5 names and values like:

Billy - 5,

Chris - 4,

Josh - 3,

Lily - 2

Thomas - 1

then treemap will assign the biggest portion for Billy, and the lowest one for Thomas.

But what if I want to assign the biggest portion to Thomas, the guy with the lowest points? Is it possible to make a "reverse-treemap"?

[lbendlin]

Add a calculated column "6 - value" and use that for the treemap.

[bartlet]

6 - value as a formula...seems not working...am I missing somehting perhaps?

[lbendlin]

Name	Value	Reverse Treemap Value
Billy	5	1
Chris	4	2
Josh	3	3
Lily	2	4
Thomas	1	5