Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to create a calculated dimension which consists fields from different other dimensions:
if(Account_Group_GRLaR = 'GRLactRet','GRLactRet',
if(Account_Group_GRLR = 'GRLtotRet','GRLtotRet',
if(Account_Group_IncbefIC = 'WHVINET','WHVINET',
if(Account_Group_IncbefTax = 'WHVIIBTX','WHVIIBTX',
if(Account_Group_IncIncIC = 'WHVINETIC','WHVINETIC',
if(Account_Group_NetContr = 'WHVINETC','WHVINETC',
if(Account_Group_NetRev = 'WHVCORE','WHVCORE',
if(Account_Group_NetRev = 'WHVIHVNR','WHVIHVNR',
if(Account_Group_OpInc = 'WHVIOPTI','WHVIOPTI',
if(Account_Group_TotRet = 'WHVITOTRTN','WHVITOTRTN',
if(Account_Group_TotRev = 'WHVITREV','WHVITREV',
if(Account_Group_VarContr = 'WHVIVCON','WHVIVCON',
if(Account_Group_VarContr = 'WHVIFIXX','WHVIFIXX',
Null())))))))))))))
I want to use this dimension in a Listbox as a field <Expression>.
My problem at the moment is, that the result looks like this:
a dimension with only 4 members: WHVINET, GRLactRet, WHVINETIC, GRLtotRet.
Do anybody know why I do not see the rest of the calculated dimension?
Regards
Steven