1 Reply Latest reply on Jul 20, 2018 9:20 PM by Ankit Bansal

    Count Part Number

    Evaldas Jazbutis

      I have table below. Tryng to do, something like group per supplier and left part.  Last column is what i woul like to have tableau to display as oppose to 1.1.1.1.... Does anyone know how can this be done in Tableau?  Thank you

       

      Suplier                  Left Part1     Part2  Part1Value  Part2Value  CountPerSupplier (left)    Desired CountPer Supplier (left)

         Apple                    123             3214  10               100                    1                                                   2

         Apple                    123             5987  11                101                   1                                                   2

         Apple                    128             2222  11                101                   1                                                   1

       

         peac                     444             3214  10                100                    1                                                   2

         peac                     444             5987  11                101                    1                                                   2

         peac                     128             2222  11                101                    1                                                    1