2 Replies Latest reply: Jul 7, 2011 11:35 AM by Frank Beunder RSS

    Percentage of a subset

    Frank Beunder

      I have the following data:

      DayLineType productNumber
      11ACard5
      21ACard6
      11ACash4
      21ACash2
      11AOther8
      21AOther10
      12ACard6
      22ACard6
      12ACash8
      22ACash2
      12AOther4
      22AOther10

       

      I want to create the following Chart:

      LineTypeProductTotalAverage (per day)Product segregation(per line)
      1ACard115,531%
      1ACash6317%
      1AOther18951%
      TOTAL:35100%
      2ACard12633%
      2ACash10528%
      2AOther14739%
      TOTAL:36100%

       

      My problem is that I dont know how create a expression for the 'Product segragation' part.

       

      The 31% should be calculated the following way:

      Sum(numbers of  line 1, type A, product Card) / SUM (numbers of Line 1, type A)

       

      In numbers:

            11 / 35 = 31%

       

      Can anyone help me?

       

      Thanks in advance

      Frank