9 Replies Latest reply: Jan 19, 2018 8:21 AM by venkata Sreekanth RSS

    Avgs columns in Pivot table

    venkata Sreekanth

      Hi Qlikers,

      I am facing a problems. Its related to pivot table.

      In pivot table right now i can able to show sum(sales) by region and monthyear wise bifurcation.

      Now my problem is i want to get the Averages for region wise As show in below image & highlighted in red color.


        

      Region2016-122017-012017-022017-032017-042017-052017-062017-072017-082017-092017-102017-112017-12AVG
      East3584715865766117147377841,1965,1815,1323,7673,8121,840
      West2142682953045227687096981,1055,3775,9784,8944,0961,941
      South3554134034534975915335319466,8068,7158,1697,4072,755
      North1,9132,8262,9743,3703,2433,9674,0014,3279,20668,88395,21688,50080,85028,406

       

      Dimensions : Region, MonthYear

      Expression : Sum(Sales)


      Kindly help on this how to achieve.


      Thanks in Advance...