6 Replies Latest reply: Dec 8, 2010 4:44 PM by nims1983 RSS

    How to show the weight (share) in a pivot table?

    banciu

      I am trying to solve the following problem, but I just can't figure it out for the moment. I have the sales figures by article. The articles are grouped in classes and the classes in families. I want to present, into a pivot table, the weight (share) of each class into the family, of each article into the class. So my pivot table should look like this:

       

      Family Class Article SalesAmount SalesShare

      A A1 A11 1000 33%

      A12 2000 67%

      A2 A21 1000 12.5%

      A22 3000 37.5%

      A23 4000 50%

      B 20000 100%

       

      When I am collapsing the articles, it should look like this:

       

      Family Class Article SalesAmount SalesShare

      A A1 3000 27%

      A2 8000 73%

      B 20000 100%

       

      Finally, collapsing it should like this:

      Family Class Article SalesAmount SalesShare

      A 11000 100%

      B 20000 100%