Is there a way of activating a different calculated field based on a quick filter selection?
Say if the quick filter is set to (All)
use Calculation 1
If quick filter is set to a subset of All
then use Calculation 2
If quick filter set to a subset of All
then use Calculation 3
You could use a parameter. Create a parameter with 3 possible values (Calc 1, Calc 2 and Calc 3)
Then create a calculated field:
if [parameter] = "Calc 1" then [Calculation 1]
elseif [parameter] = "Calc 2" then [Calculation 2]
[parameter] = "Calc 3" then [Calculation 3]
end
add the calculated field and parameter control to the sheet. Use the parameter control instead of a filter.