1 Reply Latest reply: May 21, 2010 9:31 AM by Martin FAVIER RSS

    Nested analysis problem

    ptspy

      Dear community, I have would like to do the following, which I fell should be easy, but I'm unable to . Can you please help ?

      Nested analysis problem;

      Given the Table:

      Name

      Date

      Value

      Location

      N1

      Jan

      10

      L1

      N1

      Feb

      11

      L1

      N2

      Jan

      5

      L1

      N3

      Feb

      4

      L2

      N4

      Feb

      5

      L2

      N4

      Jan

      10

      L2

      N5

      Jan

      10

      L3

      ..

      ..

      ..

       

       

       

       

       

      I would like to have a table that shows for each NAME the Total VALUE over a pre-select period (easy) but also in the same line the relative weight of this value for all entities on the same location.

      Let's say that the Period is already selected, so the =Sum(Value) gives the correct answer. The problem is how to weight this over all of the same location, since I couldn't find a way to sum over the entire set that as the same Location of the "current line" . In English J :

      Total weighted = Sum (Value) / Sum (select all Values where Location = this line Location).

       

      Any ideas ?

       

      Best regards,

      ptspy