2 Replies Latest reply: May 18, 2011 2:07 PM by Sander Goudsblom RSS

    Calculate share on total grouped by another value

      Hello all,

       

      I have the following data;

       

      Product,Category,Value

      A,X,46

      A,X,89

      B,X,69

      B,X,62

      C,X,84

      C,X,65

      D,X,1

      D,X,64

      E,Y,7

      E,Y,4

      F,Y,87

      F,Y,20

      G,Y,97

      G,Y,30

      H,Y,24

      H,Y,63

      I,Y,60

      I,Y,2

      J,Y,19

      J,Y,51

       

      As a result I want the next table.

       

      2011-05-18 16.3208.gif

      The share is  based on the total grouped by category, but i do not want the category in the table. Every product has one category.

      see the atached QV example.

      Can anybody help me out here, thnx in advance!!