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'
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.
Thanks for taking a look Michel.
I created a calculated field (Parameter All) with the formula you mentioned and added it to the filter shelf. I don't want to replace the other calculated field that references the parameter so that I do not disturb the functionality I already set up. The 'all' on the filter does not work, I am thinking I might not be able to have both functions.
Civil Dashboard - posting.twbx 620.4 KB
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.
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.
Thank you Michel! The integration of the two sets of formula was just what I needed. Appreciate your help!