Dynamic Straight Table Calculations

[#1]

I have a straight table and what to SUM() what is selected within a list box. However, within the list box is only each divisions name, such as Finance, HR, etc. When I originally imported my data from each division I used qualify, thus for a given metric such as PLAN, the field is named Finance.PLAN or HR.PLAN. Thus within my straight table I want to sum PLAN and FORECAST individually. In order to do this I have written the following, however I keep getting an error message that states: Error: Error in expression: Nested aggregation not allowed. Is there anyway to script what I'm trying to do?

=Sum(Concat(getfieldselections([Divisions])&' .Plan'))

[#2]

Engineering Data.Metric

Engineering Data.Plan

Engineering Data.Actual

.

.

.

.

Dixie Chopper Data.Metric

Dixie Chopper Data.Plan

[Qrishna · Accepted solution]

See attached files.

let me know if you have any questions

[#4]

Perfect, well done.

[Qrishna]

Happy Qliking.

[qlikviewwizard]

Nice one. Thank you.