1 Reply Latest reply on Jul 12, 2016 1:20 AM by Mark Fraser

    MERGE CELLS AND COLOR CODE

    Jo Zhou

      Hi,

       

       

      I  need help on formatting report in Tableau desktop, thanks in advance.

       

       

      below is the final format I need(created in excel), and I am stuck on 2 things when I working with tableau desktop.

      1, I only want to color code price gain , but in tableau , the whole line was color coded.

      2 . for WINDOW SUBTOTAL PRICE along Base Model Code, I want to merge all cells and only show one number, but in tableau, there were repeated number showed.

       

      I attached the tableau packaged workbook I can do the best.

       

      CategarySensor SizeBase Model CodeFy15 UFy16 UPrice GainVoulme GainWINDOW SUBTOTAL
        PRICE along Base Model Code
      WINDOW SUBTOTAL VOLUME along Base Model Code
      L11''ARA100S988546(6,408)-487,112126,448-1,150,340
      ***100M46849487,192 30,476
      FAGS100M0260 78,880
      H100S2600 -63,496
      LCD100S2,6391,82045,664 -709,088
      1/2''ARA050S1,066442(29,208)-423,280-51,580-1,030,156
      ***050M767416(23,168)-485,572
      LCD050S260130796 -121,304
      1/4''ARA025S1,19670263,288 -381,83628,300-1,472,916
      ***025M1,7421,118(30,568)-888,016
      FAGS025M5200 -75,840
      LCD025S351182(4,420)-127,224
      1/6''FAGS015M35154618,000 473,81218,000473,812
      1/10''***010M3,7311,2227,292 -3,274,2887,292-3,155,816
      FAGS010M1041560 118,472

      many thanks,

      best regards,

      Jo

        • 1. Re: MERGE CELLS AND COLOR CODE
          Mark Fraser

          Hi Jo

           

          I think you're going to struggle with the coloring in its current format... although some behaviors are common between Excel & Tableau, they are different products.

           

          The only way I can think of doing it (and even then, I'm really not sure) is this way

          >> Data Psientist: My Favorite Tableau Trick For Work: MIN(1)

          Effectively you create blank cells, and drop items into them, that way you have more control over formatting

          But as mentioned, I really don't know, you'll just have to try.

           

          really Excel is the tool for what you want to do...

           

          Best of luck

          Mark