I have created a parameter to switch the view between two values.
Actual vs Index:
Actual is % values, and
Index is decimal points
Is there a way I can dynamically set the data type to show % when view by is Actual and decimal points when view by is Index?
Thank you for providing the workaround Imran…
Though, I don’t think the workaround is feasible in my case as I have a big table with multiple calculated fields… so, basically I’d have to duplicate the entire table thus affecting the load time after every filter change…