4 Replies Latest reply on Mar 25, 2018 5:49 PM by Shobhit Malaviya

    Pivot in tableau

    Shobhit Malaviya

      Hi Everyone,

       

      I have inventory data from different locations. I want to bucket the inventories on the basis of number of locations the inventory is present in. For example

           

      InventoryENTITYcountUNIT_COST
      100101A5919
      100101C5348.78.92
      100101D1051.549.58
      100105A7876.78
      100105C4728.843.23

       

      Using this data I want to show something like a bar graph , with x axis as location count and the Y axis as the number of inventories. So in this case I want to show there in one inventory present in 3 locations and 1 inventory present in 2 locations.  I have attached the data and the view I was thinking of.

       

      Thank you for your help!