2 Replies Latest reply on Aug 27, 2015 3:45 AM by Sankarmagesh Rajan

    How to show all the values of a field

    Ayeesha Farheen

      Hi,

            I have a requirement where in i need to show all the values of field. I have tableau version 8.2

      Ex: i have 10 representatives in a particular region say North. Among 10 reps 3 are selling Mangoes and other are selling different fruits. The challenge is I want to show all the representatives for North region but I want to display selling price only for representatives who are selling mangoes and for the representatives who are not selling Mangoes should show their selling price as 0(Zero). Please find the table below for reference.

      RegionRepProductSP
      NorthRep1Mangoes$120
      NorthRep2Mangoes$80
      NorthRep3Mangoes$100
      NorthRep4Apple0
      NorthRep5Grapes0
      NorthRep6Apple0
      NorthRep7Apple0
      NorthRep8Grapes0
      NorthRep9Grapes0

       

      Please help me to achieve the above table.