What is the syntax to aggregate a sum of a measure over a dimension?
I’m trying to calculate YoY Price – Volume – Mix impact. Hierarchy is Customer, Part Number. The calculation works for every part number but the result at a Customer level is the sum of the results of each part number.
I think what you’re looking for can be found in the properties of the measure. If you look at the properties of the measure (right click on the measure header, last option is properties, or open the View Explorer and double click on the measure) the last property is ‘Total:’, change this from from Total (which preforms the calc for the measure) to Sum (this will sum the entries in the column).
Let me know if this works or is not what you are looking for.
This reply was modified 1 year, 8 months ago by Frank.