How to calculate an Aggregated Sum?


This topic contains 1 reply, has 2 voices, and was last updated by  Frank 1 year ago.

  • Author
  • #555
     Joaquin Sanchez 
    • Topics Started - 2
    • Replies Written - 0

    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.

  • #560
    • Topics Started - 63
    • Replies Written - 50

    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 ago by  Frank.

You must be logged in to reply to this topic.


We're not around right now. But you can send us an email and we'll get back to you, asap.


©2020 KLEO Template a premium and multipurpose theme from Seventh Queen

Log in with your credentials


Forgot your details?