8 Replies Latest reply on Sep 20, 2018 4:57 AM by Subhra Sardar

    How to obtain count of different dimensions/measures of a column in a separate column

    Subhra Sardar

      Hello,

       

      I have a table like this:

       

       

      Asset manufacturerAsset_Type
      SWARAJ MAZDA LIMITEDNew
      ASHOK LEYLANDUsed
      TATA MotorsNew
      TATA MotorsUsed
      ASHOK LEYLANDNew
      TATA MotorsweeNew
      Maruti Suzuki India LtdUsed
      TATA MotorsUsed
      TATA MotorsUsed
      HONDA MOTORCYCLE AND SCOOTER INDIA P LTDNew
      ASHOK LEYLANDNew

       

      Now when I am using the ASSET_TYPE dimension so view the individual count of New and Used assets in a single column, the calculation is spreading across all the columns whereas I just want it under one column , Now each column has new and used vehicle count.

      Type.JPG

       

      What I am looking for:

       

       

      image_1.jpg

       

      Is this possible in Tableau? Please find the .twbx file here