I'm not sure this is the easiest way to accomplish your desired result but this view can be accomplished using Data Blending.
Part I. Create a Common Blend field
1. Create a calculated field called "Blend" with the calculation: 'A'
2. This simply creates a common value that you can blend on later, it will be unaffected by filtering
Part II. Duplicate the data source and blend
1. Right-click on the data source and select Duplicate
2. Click on the secondary data source and click the link button next to Blend
Part III. Create the calculation for the difference between the two values
1. Create a calculated field called "Difference" with the formula: [Calc]-[Sheet1 (DSource)].[Calc]
2. Add it to the view.
Part IV. Party because it's Friday.
Hope this helps!
Could you post the revised Tableau worksheets and dashboard? Thanks.
Hi Nicholas. I can't follow your explanation. Could you please add more step detail. For example what is 'A'? Could you please note which data source such as sheet 1 or sheet 2. What is [Calc]? Thanks.
I read this differently from the original responder.
It looks to me as if the question is how to compare numbers on two worksheets when they're drawn from the same data source, and I think the answer was how to compare numbers from two data sources, regardless of whether they're on the same worksheet or not.
If I'm reading it right, I'd approach it from a different perspective and "filter" without filtering.
Set a "flag" calculated field (1/0) based on parameters, then allow the user access to the parameters. element one is based on the flag being 1 and this will vary according to the parameters settings.
However, the data are not actually filtered s so element two can be controlled by a completely separate set of criteria.
This enables both charts to be on the same worksheet, so the original question becomes moot.