
I have a filter with multi-select drop-down where I only want the user to select two values only on the list. I also need user to select which value should be used a original value so that this formula can be applied
(Original value - Compared to value)/SUM(Original value)
If I use two parameters to control the filter, only one parameter works at a time. So if I can determine which value was clicked on first, would like to set it to Original value, or use a calculated field to indicator if one of the values in the drop-down filter is Original value or not.
sorry - filters don't have that capability - - your statement about using 2 parameters is not the correct interpretation - each parameter can have only a single value - but 2 parameters can each have their own value and those values can bus use to complete the formula you wrote