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
