I want the text box to show only the result that user selects out of the 3 dropdowns, Finance,Rollup,DH.
Right now the below formulae shows all the results that come up and are connected when user selcts one dropdown.
eg: If user selects Finance = "abc", then since bcz of associtivity Rollup = "xyz" and DH = "wdf" also gets printed on the text box. Another user can select Rollup = "xyz. Basically in textbox I want to select the green value, i.e the one selected out of the above 3 dropdowns
if(GetSelectedCount([Finance])=0 and GetSelectedCount([Rollup])=0 and GetSelectedCount([DH])=0, 'Overall View', [Finance] & [Rollup ] & [DH])