6 Replies Latest reply on Jun 22, 2018 7:37 AM by Paco Matt

    Tracking Percentage Goals

    Paco Matt

      Hi, how can I create some calculated conditions based on these premises:

      • Car Colors (red, blue, yellow, white)  "Car Colors is the column name in the table and the actual colors are the rows"
        • I need to sum all colors (Grand Total) "I have the Total option in the Analysis Tab but I prefer to create a Calculated Field"
        • Then sum only selected colors like: red, blue & white
        • and finally create a percentage: Sum of selected colors / Grant Total

       

      After this; How can I create a percentage target and color code my results base on predetermined color coding?

      Thanks