How to calculate an Aggregated Sum?

Tagged: 

This topic contains 1 reply, has 2 voices, and was last updated by  Frank 3 weeks, 5 days ago.

  • Author
    Posts
  • #555
     Joaquin Sanchez 
    Participant
    • 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
     Frank 
    Keymaster
    • Topics Started - 52
    • Replies Written - 47

    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 3 weeks, 5 days ago by  Frank.

You must be logged in to reply to this topic.

CONTACT US

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

Sending

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

Log in with your credentials

or    

Forgot your details?