Hi All,
In UI while I am trying to give calculated dimension and selected filter as "No", result is showing all values
Table 1 :
If([Sub]='1' and [DOC] ='1','Yes', 'No') as [Product]
noconcatenate
Table 2 :
If([Text]='1' and [CHNL] ='0','Yes', 'No') as [Text]
In the UI while i am trying to give calculated dimension
=if([Text]='Yes' and [Product]='Yes','Yes',
if(([Text]='No' and [Product]='Yes') or ([Text]='No' and [Product])='No' ,'No'))
I can able to filter the values for Yes , But while trying to select No, It is selecting all.
Please help me, how to select "No" values.
Note: We have option to combine those two tables but, due to large volume of data i couldn't combine it.
I am trying to show as calculated dimension
Thanks,
Krishna
