8 Replies Latest reply: Feb 13, 2012 4:30 AM by Sebastian Blum RSS

    Avg in a cross table



      I have a problem calculating the right averages in a cross table.


      I have the following data:



      DIM 1 \ DIM 2XYTotal

      I would like to calculate averages based on the total of the whole table (total = 2). So, it must look like:


      DIM 1 \ DIM 2XYTotal
      A0 %50 %50 %
      B50 %0 %50 %
      Total50 %50 %100 %


      I only get it work based on the row totals.

      Searched the other discussions, but still no solution for my problem.


      Can anybody help? Thanks!