6 Replies Latest reply: Jul 8, 2013 4:17 AM by Gysbert Wassenaar RSS

    calculating average for each month and summing all calculated averages

    Muhammad Raza

      Hi guyz,

       

      I have the following data and I want to calculate average for each month for specific (or selected) company/ies and display the total of averages.

       

      I have tried avg(aggr(sum(Value),Company, Month(Period))) but I am not getting the desired result. Please guide..

       

       

      Company Period Value
      ADU13-Jan10,162,929
      ADU13-Jan1,539,488
      ADU13-Jan -  
      ADU13-Jan -  
      ADU13-Jan -  
      ADU13-Jan7,000,000
      ADU13-Jan12,115,840
      ADU13-Jan -  
      ADU13-Jan -  
      ADU13-Jan101,742
      ADU13-Jan1,084,655
      ADU13-Jan542,328
      ADU13-Jan2,711,638
      ADU13-Jan -  
      ADU13-Jan4,338,621
      ADU13-Jan -  
      ADU13-Jan -  
      ADU13-Jan -  
      ADU13-Jan -  
      ADU13-Jan -  
      ALU13-Jan -  
      ALU13-Jan -  
      ALU13-Jan -  
      ALU13-Jan -  
      ALU13-Jan6,000
      ADU13-Feb10,162,929
      ADU13-Feb1,539,488
      ADU13-Feb -  
      ADU13-Feb -  
      ADU13-Feb -  
      ADU13-Feb7,000,000
      ADU13-Feb11,925,759
      ADU13-Feb -  
      ADU13-Feb -  
      ADU13-Feb100,000
      ADU13-Feb1,084,655
      ADU13-Feb542,328
      ADU13-Feb2,711,638
      ADU13-Feb -  
      ADU13-Feb4,338,621
      ADU13-Feb -  
      ADU13-Feb -  
      ADU13-Feb -  
      ADU13-Feb -  
      ADU13-Feb -  
      ALU13-Feb -  
      ALU13-Feb -  
      ALU13-Feb -  
      ALU13-Feb -  
      ALU13-Feb6,000
      ADU13-Mar10,162,929
      ADU13-Mar1,539,488
      ADU13-Mar -  
      ADU13-Mar -  
      ADU13-Mar -  
      ADU13-Mar7,000,000
      ADU13-Mar11,911,180
      ADU13-Mar -  
      ADU13-Mar -  
      ADU13-Mar100,000
      ADU13-Mar1,084,655
      ADU13-Mar542,328
      ADU13-Mar2,711,638
      ADU13-Mar -  
      ADU13-Mar4,338,621
      ADU13-Mar -  
      ADU13-Mar -  
      ADU13-Mar -  
      ADU13-Mar -  
      ADU13-Mar -  
      ALU13-Mar -  
      ALU13-Mar38,000
      ALU13-Mar -  
      ALU13-Mar -  
      ALU13-Mar9,677

       

      Regards,

      Raza