Hi,
I have a straight table with detail dimension.In detail chart,Parent_Num field should have different name based on the AD_ID dimension.
The requirement is
for AD_ID=5007,5001,5008,5007,5009 Parent_Num column in the "Detail record of A_Available" (Once you click on any AD_Desc, it ll populate detail straight table) should display as KEY_TER
for ID=5003,5004,5005,5006,5010,5011 it should display as Prnt_KEY.For rest others KEY_DTL..
I have tried with some expressions.But when there is two ID, it's not working correctly.
=if(AD_ID=1001 or AD_ID=1032,'KEYONE Count',if((AD_ID>=1005 and AD_ID<=1019) or (AD_ID>=1035 and AD_ID<=1050) ,'Prnt TER','KEY TER'))
Please note: In real scenarios the ID's will be more so please suggest simplified expression.I have tried with
nested IF statement but result already mentioned.
Steve Dark
Thanks in advance.
