4 Replies Latest reply: Jan 21, 2012 11:39 AM by the fourth RSS

    Calculate Avg grouped by 2 dimensions

      Hi, i need to obtein the average grouped by Period and Country like show the following table. Can you help me?

      Thanks in advance

       

      chart.PNG

        • Re: Calculate Avg grouped by 2 dimensions
          Stefan Wühl

          Hi,

           

          it seems I have some problems reading your table. The last column is what you want to achieve?

           

          In your sample data,  I would expect to see the same value for any given combination of Period and Country, if you want to group by these 2 dimensions.

          It looks to me that your last column is an average grouped by 3 dimensions (Period, Country and Type or Products).

           

          What is the field / value you want to average? If you could post some lines of raw data, this might help in finding a solution for you.

           

          edit:

          If you just want to give it a try:

          =avg(total<Period, Country> Value)