
1. Re: Comparing two treemaps by size
Larry Newdorf Jun 17, 2016 2:38 PM (in response to Carolina Hollmann)I am pretty new, so I am sorry if I misunderstand your intentions, but you could create a calculated field that computes the probability multiplied by the total value and drop that field into "Size". It looks like you already are doing this in the lower sheet.
Is the problem that the sizes of the two sheets will be the same when displayed?
One way to offset this is if you are making a dashboard with both worksheets you might want to figure out the sum of the total probability values (adding up all the values * probability percentage) and then the sum of the total values. You could set both worksheets to float and then reduce the top worksheet width/length by the sum of the total probability divided by the sum of the total values. For example if the contract value probability is 67% of the total contract values, you could reduce the height and width by 1/3 for that treemap in the dashboard.
It wouldn't be exact, and would take some editing on your part but it would have the effect you are looking for.
Hope this helps!

2. Re: Comparing two treemaps by size
Carolina Hollmann Jun 21, 2016 7:54 AM (in response to Larry Newdorf)Hi Larry,
Thank you very much for your help. The solution that you proposed works!
It is not a perfect solution though because the idea is that, when the data changes (new projects in the company or probability changes), that the graphs would be updated automatically, as well of the size of it. This meanthat wth the solution that we have now we would have to calculate the difference between the total of both boxes and then change the size of the box according to this difference manually. There is no way to put a formula into the size tool, only numbers, to our knowledge.
Anyway thanks again for your help, this solution makes it much better already!

3. Re: Comparing two treemaps by size
Larry Newdorf Jun 23, 2016 6:57 AM (in response to Carolina Hollmann)Great! Glad it helped! If you find a better way, please let me know.