I need to subtract the values. i.e., Group B - Group A. And then show this difference value on the dashboard. I tried creating two separate calculated fields for Group A and Group B and then subtract those two calculated fields. But I do not see any values. Is this something anyone can help with? Also, I have an additional column in the data which I want to use as a filter (multiple values dropdown). When I use this filter the calculation does not seem to work.
The calculation is not dynamic in nature and only calculates the overall Group B - Group A.
Find the updated tableau workbook for your reference.
2 answers
see the red tab - I converted you formulas to LODs to separate out the A and B vlaues
