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

    Avg in a cross table

      Hello,

       

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

       

      I have the following data:

       

       

      DIM 1 \ DIM 2XYTotal
      A011
      B101
      Total112


      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!