3 Replies Latest reply on Aug 13, 2018 12:38 AM by Kashish Bhola

    calculation

    Kashish Bhola

          Hello Guys!

                               I am having a issue I need this format.

       

       

                                                 sample2.PNG

       

      but I'm getting this both cust id and vertical are coming together.

       

       

                                      sample.PNG

       

      Regards

      Kashish Bhola

        • 1. Re: calculation
          John Sobczak

          Have you tried putting ALL your dimensions on the Rows shelf with nothing on the Columns shelf?

          • 2. Re: calculation
            Kashish Bhola

            Yes But all the customer names are coming but I need a one liner format, I think I'll have to make changes at the database level.

            Thank you!

            • 3. Re: calculation
              Jim Dehner

              good morning

              I would like to see the TWBX workbook and the form of the data

              but from your vis you created a partition on the columns - Think like a 2 level hierarchy

              you asked tableau to first break out by Vertical des  then break out within that grouping by cust ID

               

              further your "Wanted view" implies that there is a one to one relationship between Cust name and client ID

               

              but what you got says there are many cust ids per client ID

               

              Jim

              If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

              1 of 1 people found this helpful