How to calculate an Aggregated Sum?

Tagged: 

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

  • 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 - 67
      • Replies Written - 52

      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, 4 months ago by Frank.
Viewing 1 reply thread

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

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

Log in with your credentials

or    

Forgot your details?