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?
Yes, however, when I select the division, it sum() the PLAN for every metric, when in actuality I want to select a division, and when selected it will compute PLAN for each metric in separate rows of the straight table
IMHO The solution should be in the script and not in the front end calculations. Create a fact table with all the metrics you need and the key fields to the dimensional tables like Division, Calendar. Advantage of this approach is that you don’t have to qualify your fields.