3 Replies Latest reply on Jan 9, 2019 8:32 AM by Paul Wachtler

    To Calculate

    Vinoth kumar T S

      Hi All,

      i Have below mentioned data in my tableau excel, Its a same excel file no joins.

         

      order idSkuSale AmountDebitCredit
      403-4091332-0362759 -53.1-53.1
      403-4091332-0362759N2H0014_H_P1750-103.25646.75
      402-6036969-6479512 -53.1-53.1
      402-6036969-6479512N2H0029_H_P2225-35.7189.3

       

      Here i don't have SKU in same rows of unique order id. But i need to take all SKU wise Sale amount, Debit and Credit values.

      Please help me to resolve.

      the resut should be

      Order Id - SKU - Sum(Sale Amount) - Sum(Debit) - Sum(Credit)

       

      Thanks,

      Vino.

        • 1. Re: To Calculate
          Paul Wachtler

          Hi Vinoth,

           

          Put Order Id field on rows, place Sku next to it, right click Sku and select Measure > Maximum.  This will put the single value next to the Order Id.  Then you can simply put Measure Names on columns and Measure values on your text mark.  Then you can rearrange your measure values as needed.

           

          Here's how it will look:

          Screen Shot 2019-01-08 at 10.30.37 PM.png

           

          This is in the attached workbook too.  Let me know if you have any questions.

           

          Best,

          Paul

          • 2. Re: To Calculate
            Vinoth kumar T S

            Hi Paul,

            Yes its correct and brought the correct value. Now I don't want the order ID. if i remove the order ID it shows the one value of Max SKU.

            I have another method in my mind, Please suggest it might works? Creating an calculated field to make data as looks below.

             

                                                          

            rder idSkuSale AmountDebitCredit
            403-4091332-0362759N2H0014_H_P1-53.1-53.1
            403-4091332-0362759N2H0014_H_P1750-103.3646.8
            402-6036969-6479512N2H0029_H_P2-53.1-53.1
            402-6036969-6479512N2H0029_H_P2225-35.7189.3

            Thanks,

            Vino.

            • 3. Re: To Calculate
              Paul Wachtler

              Hi Vino,

               

              If you don't want to see the order id you can right click on it and deselect Show Header. That'll hide it.

               

              I'm not sure what you're trying to do in this second table you posted. Why do you want a second row for each sku with blank measure values?

               

              Paul