Did a search, did’nt find what i need.I need to define a variable for a single cell.The variable includes sum of measure where the dimesions come from different tables.

My requirement is to create a variable

=where=(inlist)(A1,A2,A3)+where=(inlist)(b1,b2,b3)+where=(inist)(c1,c2,c3)

and the dimensions(dim1,dim2,dim3) come from tables(T1,T2,T3)

T1-(A1,A2,A3)

T2-(B1,B2,B3)

T3-((C1,C2,C3)

I know that where accepts only constant and the inlist cannot be used.is there a workaround.

Can I use like =If inlist(A1,A2,A3) tHEN 1 else 0 and use it in ( =sum(measure) where =1).

**rocky** *(BOB member since 2005-03-29)*