2 Replies Latest reply: Jun 10, 2016 3:50 AM by susant Kumar swain RSS

    How to split dimention in pivit table

    YUN BAI

      Hello there,

       

      The data fields "Month" and  "Receipt Type" will be the dimension.

      Under "Receipt Type" there are "Initial Receipt" and "Follow up Receipt" two different values. "Initial Receipt" value based on "Initial Receipt Date". "Follow up Receipt" based on "Follow up Receipt Date" . Such as,

       

      Month    Receipt Type              Initial Receipt Date             Follow up Receipt Date

      Jan        Initial Receipt                  01/05/2015                                    01/08/2015

      Feb        Initial Receipt                  02/05/2015     

      Mar        Follow up Receipt           03/05/2015                                    03/08/2015

       

      I would like to have the pivit table which can split two values from "Receipt Type" into two columns. Such as,

         

      Month Receipt Type
      Initial ReceiptFollow up Receipt
      Jan11
      Feb1
      Mar

      1


       

       

      How can I do with the Pivit table to create the one shows above? Am I able to do it?

       

      Thanks in advance,

      Becky