2 Replies Latest reply: Jun 28, 2011 10:21 PM by bharadwaj pavuluri RSS

    How to do Pivot table totals ,Sort & Rank

      Hello,

       

      We just bought QV and getting our hands around it.

       

      I have a pivot table as shown below

      Header 12010
      2011
      Total ?

      ProductQtyAmtQtyAmtQtyAmt
      DVD 1440.00550????
      Book 2840630????
      CD  5330550????
      Book 811002200????
      Total ?????????????

       

      Here are my questions

      1. How do I do totals and grand totals

      2. Is it possible to sort by 2011 Amt

      3. Does QV picot table allow multi sort ex. Sort by Total Amount, then by 2011 Amount?

      4. is there any way I could add rank (based on amount) for 2010 as well as for 2011

       

      Thanks in advance!

       

      Aji.