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)
B.
(BOB member since 2002-06-20)