Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to create a selector in the App, which should display two dimensions. These two dimensions are available in two different tables.
Table1:
Metric Value
Estimated/Final Pat Rev ,100
Table2:
Final Net Pat Rev Value
Final Net Pat Rev, 1002
I tried with if condition, which displays but when we make the selection, it will select both the dimensions because they are both are present in the table
if(Metric='Estimated/Final Pat Rev',Metric,if([Final Net Pat Rev]='Final Net Pat Rev',[Final Net Pat Rev]))
Kindly, please help me to resolve the issue.