Migration Chart

[erikzions]

I am trying to make a migration table similar to the one below.

	Low	Med	High	Total
Low	1	5	1	7
Med	3	1	2	6
High	1	1	1	3
Total	5	7	4

I have everything working except for being able to make it a percent of the total.  Becuase I am using calculated dimensions I cannot use count(total <dimension> Key).  I can't think of a way to accomplish this another way.

Attached is a mockup of what I am trying to do.  If anyone can help that would we wonderful.

[swuehl]

Hm, maybe like attached?

[erikzions]

That looks like the solution.  It is acting funny in my app though (random nulls).  I will have to figure that out.

(edit) Min works better than only becuase there can be more than one result.  Though I never would have gotten this far without you.

Thanks swuehl.