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).
