I didn`t fully validate but you could try to replace your parameter filter with

if [Select County & COC] = [County (copy)] then 'True'

elseif [Select County & COC] = 'All' then  'True'

end

If you select a specific County, the first line will catch it , and if you select All , since you don`t  compare with any [County] the SUM(Value) will apply for all.

Michel

Hello, Kim, since you are using a list, and there is no value in the list that is "All", you need a wildcard of sorts. I've dug around a bit in the community, and found http://community.tableau.com/thread/119626. There's got to be a way to continue working the parameter and calculated field idea to get the result you want.

Kim,

If i have red carefully, i would have seen that the complication was actually with the %Cases over 2 years worksheet.

I didn't fully understand all the logic between the calculation 4 and calculation 2 and Class to keep,  but i made some changes in the Class to keep and calculation 2. It doesn't work completely but it may give you some hint on how to pursue

On the two other worksheets i made the changes i mentioned in the previous post.  Here is the result, but i am not sure if it is exactly what you are looking for.