I have the following expression that I'm trying to get to calculate correctly over a Summary Level cyclic group (Summary Level 4, Summary Level 1, Cost Element, highest to lowest) in a stacked bar chart. I can get it to show what look like the correct numbers for Cost Element, but it won't do it for the higher level values - Summary Level 4 and Summary Level 1. Below is what I have:
The BUILD numbers are broken out by month and by cost element in the data model. I think I somehow need to aggregate the build numbers to levels higher than cost element in the denominator, but I can't add another SUM() there, and moving the placement of the SUM() within the denominator doesn't seem to work. Does anyone have any ideas?
Robin, is this a document you can post for review? It looks like your AGGR statement might just need some formatting, but it is hard to tell without data to test.
Based on the parentheses as placed, I see only two AGGR levels, $(=GetCurrentField(SummaryLevelCyclic)) and QTR).
Try adding your third level after QTR (e.g., "...QTR, next level).
