2 Replies Latest reply on Jun 27, 2013 1:35 AM by bart.groots

    Grand average

    bart.groots

      Hello,

       

      I like to have a Grand average instead of Grand total.

      See my workboke.

       

      Can someone help?

       

      Greets

        • 1. Re: Grand average
          Tracy Rodgers

          Hi Bart,

           

          Not sure which value you'd like to be an average, but using a calculated field similar to the following:

           

          IF FIRST()==0 THEN

          WINDOW_avg(sum([Percentage %]),0,IIF(FIRST()==0,LAST(),0))

          END

           

          Then, create a duplicate of Maand (right click on it in the data box and select Duplicate), and place it on the level of detail shelf (as the continuous Month). Then, right click on the calculation and select Compute By...>Maand (copy).

           

          Hope this helps!

           

          -Tracy

          1 of 1 people found this helpful
          • 2. Re: Grand average
            bart.groots

            Tracy,

             

            First of all thanks for your help.

            I have tried your suggest but with no results.

             

            i have add a package workboke. This will make it clear.

            I have one row with grand total. I like to have that row, but not Grand total but the average.

             

             

             

            Sample.png

             

            Thanks