2 Replies Latest reply on Jul 11, 2017 12:13 PM by venkat.ram.1

    Color Code Issue on Text Measure Values

    venkat.ram.1

      Hi Guys,

       

      I have below requirement need to present in tableau. Attached screen shot for reference and workbook.

       

      Used Sales Supper Store:

      Created 4 different measures.

      1. East Sales

      2. West Sales

      3. Central

      4. South Sales

       

      Formula need to apply in my workbook:

       

      If sum(east sales)< sum(west sales) then "Green" else "Red" end.

       

      In my sheet, I need to color color code for only two measure and remaining would be black color text.

       

       

       

       

                                                                                                                                                                                                                                                                                                    

      CategorySub-CategoryColor CodeSalesSouth SalesWest Sales Central SalesEast Sales
      FurnitureBookcasesred$114,88010,89936,00424,15743,819
      FurnitureChairsgreen$328,44945,176101,78185,23196,261
      FurnitureFurnishingsgreen$91,70517,30730,07315,25429,071
      FurnitureTablesgreen$206,96643,91684,75539,15539,140
      Office SuppliesAppliancesred$107,53219,52530,23623,58234,188
      Office SuppliesArtgreen$27,1194,6569,2125,7657,486
      Office SuppliesBindersgreen$203,41337,03055,96156,92353,498
      Office SuppliesEnvelopesred$16,4763,3464,1184,6374,376
      Office SuppliesFastenersgreen$3,024503923778820
      Office SuppliesLabelsgreen$12,4862,3535,0792,4512,603
      Office SuppliesPapergreen$78,47914,15126,66417,49220,173
      Office SuppliesStoragered$223,84435,76870,53345,93071,613
      Office SuppliesSuppliesgreen$46,6748,31918,1279,46710,760
      TechnologyAccessoriesgreen$167,38027,27761,11433,95645,033
      TechnologyCopiersred$149,5289,30049,74937,26053,219
      TechnologyMachinesred$189,23953,89142,44426,79766,106
      TechnologyPhonesred$330,00758,30498,68472,403100,615