Ignore dimension in calculation

[#1]

I need to ignore dimension in my calculation.  So for exampe, I have location as my dimension... for location A, i want to be able to create a measure for location A in one column and location B in another column to be able to compare the two side by side.  Any ideas on how I would build an expression for location B on the line for location A?

[johnw]

sum({<Location={'B'}>} Measure)

But I'm betting your real requirement is more complicated than that.

[#3]

I tried to specify the location as you did above, but that doesn't seem to be working.  It may be due to how the data is setup though.

[#4]

You need a Total in there to get out of the dimension.

     sum({<Location={'B'}>} Total Measure)

[#5]

That did get a number to return, but it was the total for everything within that location.  Now, let me add another level of complexity... I have a second dimension of state, so I want the measure for location B, but only within the state on that line item.  I tried the following:

sum({<Location={'B'}>} Total <state> Measure), but no results returned for that.  Any ideas?

[#6]

try using the function dimensionality ( )  ....it should work....

[SunilChauhan]

i believe it simple like i understand

sum(total <State> if(Location='B',Measure))

sum(total <state>if(Location='A',Measure))

thanks

Sunil Chauhan

[#8]

I think dimensionality() func. is better if u have to ignore a particular dimension in any calculation in a pivot or a straight table.

thnxs

vivek

[#9]

I had to use some trickery, but I finally got this to work.  Thanks everyone for your help!