1 Reply Latest reply on Sep 25, 2013 10:14 PM by . Indumon

    Table Calculation Relative to Hierarchy




      I am relatively new to Tableau but essentially am looking at using the software to solve for some business challenges.  One item that I think I'm close to figuring out but haven't quite gotten there is a Color formatting applied to a cell based on a member of a hierarchy.  For example.  I have a hierarchy with State and City. I have a calculated field that is a percent.  What I would like to see is a simple cross tab with a color formatting that compares the City value to the State.  If the City value is 80% but the State value is 90% then turn the cell red.  If the city value was 95%, turn it green.  I am looking at the relative to options in the table calculation but haven't made it work.  Is this possible to do?