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

# Nested analysis problem

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

• ###### Re. :Nested analysis problem

hello,

I think you can do that if you use a chart and location is a dimension :

`Total weighted=Sum(Value)/Sum(TOTAL <Location> Value)`

Martin