
1. Re: Need to subtract filtered result from fixed result
Andrea Hage Nov 21, 2016 1:20 PM (in response to Brian Shaw)Hi Brian,
I think I may have fixed the problem. I edited Calculation1 slightly:
AVG({FIXED [Birth Month Name], [County]: AVG([Num Of Births])})
And then I created an additional calculated field called PP Diff (percentage point difference) to find the difference between the chosen year's average and the fixed average:
[Calculation1] / TOTAL([Calculation1])AVG([Num Of Births]) / TOTAL(AVG([Num Of Births]))
Take a look at the attachment and see if this is what you were aiming for. Hope this helps!
 Andrea
P.S. I recently had to do this for my work and found it was helpful to add a + sign to the positive changes. I also changed the notation to "pp" to indicate that it wasn't a percent change, but rather a change in percentage points. I did this by slightly editing the PP Diff calculation and also custom formatting the number, which I included in the attachment in case you are interested!

2. Re: Need to subtract filtered result from fixed result
Brian Shaw Nov 22, 2016 8:29 PM (in response to Andrea Hage)Hi Andrea,
This works really well! I don't exactly understand how it works, but it's exactly what I was trying to do. I have much to learn about Tableau.
Thanks so much for your help.
Brian