0 Replies Latest reply: Jul 10, 2012 2:26 AM by Gerard Carvalho RSS

    Cutomize pivot table

      Hi All,

       

      I have attached a QV application, which will have a pivot table.

       

      Below is the format of a excel which need to be achieved in pivot table. Spend category field is categorized as shown in the picture and sub total has been

      calculated.

       

      1.png

      But the pivot table i have created in QV is as below

       

      2.png

      How can we get the exact format of excel in pivot table for spend category.

       

      Either we need to get the order of spend category for dept 860030 or we need to get the exact excel format.

       

      US TM Outside Counsel Fees & Exp.
      US TM Gov't Fee
      Int'l TM Reg./Pros. Fees & Disb.
      Int'l TM Gov't Fee
      Int'l TM Renewals

      Agreements
      Misc./General Advice
      Opinions
      Domain Names
      Acquisitions/Divestitures
      Other

       

      Please a solution for this.

       

      Regards,

      Gerard