4 Replies Latest reply: Feb 20, 2014 7:32 PM by Ajay Krishnan Prabhakaran RSS

    Avg is Pivot Table


      Hi,

       

      I have 3 dimensions in a pivot table, with Qty as measure. I am sowing sum(Qty) for last 3 months by country and category. Now i would like show avg(Qty) for last 3 months by Country anad Category. I can create two separte tables, and show the last 3 months Qty and avg. But am not able to do in a single table. So the question is, can we do avg by different dimensions instead of sum in a pivot table.

      I have attached my QV and required view for reference.

       

      Thanks