3 Replies Latest reply: Dec 10, 2014 2:50 AM by Ali Haider RSS

    Mean Deviation in QlikView

    Ali Haider

      I have been trying to find the mean Absolute Deviation for each Account Contract. I have the following information and i have found the deviation for each user for each month in a pivot table. I also have their deviation from their mean for each value.

       


      But my objective is to find the sum of all these deviations and divide it by the count of months to get the mean absolute deviation in a table where the only dimension is Account Contract. This is shown below:

       

      Please help!