4 Replies Latest reply: May 3, 2013 5:25 AM by Mohit Sharma RSS

    Average through the last 12 months include the selected month

      Hello,

      i'm novice with QlikView and i need your help

       

      In a Pivot table I have to calculate the average monthly sales for the last 12 months (included the selected month) for each hopital and for selected years as the folowinf exemple. i attached also an Execl for mor explenation

      sales-hopital.bmp.

      Any help will be greatly appreciated

       

      Ghassane