Compare Calculation for Dimension Value Against Another Dimension Value

[#1]

I am trying to compare a calcuation for the dimension value of my row against another value within the same dimension.  For example, I have the dimension of locations and they have 5 locations (location a, location b, location c, location d, location e) and I want to compare the total billed amount for location a, b, c, d to that of location e so that it would look something like the below:

LOCATION	TOTAL BILLED (SELECTED LOCATION)	TOTAL BILLED (LOCATION E)
A	$100.00	$250.00
B	$275.00	$250.00
C	$75.00	$250.00
D	$325.00	$250.00

Can someone please tell me how I can accomplish this?

Thanks!

[nagaiank]

An example for accomplishing what you want to do is attached.

Hope this helps.

[#3]

Thank you.  Your solution does exactly what I need it to do, but I can't seem to get it to work with my data structure.  Will look into it some more. 

Thanks again!