There is requirement to display the input control value as "All" when you select All Values there. I have tried with below logic which working but the problem is some rows are giving me #Multivalue error when there are multiple values for same dimension for across other dimensions..
=If Length(ReportFilter([Object1])) = NoFilter(Max(Length(ReportFilter(Object1)))) Then "All" Else [Object1]
Can anyone please suggest me here?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.