here is the file, check calculated field name "Multiple Conditions"
in general the rule is that the lowest level rules for the group of the three mentioned in the calculated field Web, Offer Data, and Digital Customer Care.
I am not able to understand what you are trying to achieve. Could you elaborate more on what should be the target state of the viz?
the viz should be like this, it is a scorecard
I have the scorecard built, problem is, calculations are not working as expected.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...