You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to sum up the custom revenue measure in DM

Received Response


I have requirement to sum up the custom revenue measure yearly for all the category and calculate the percentage of revenue for each category based on it.

% category revenue = individual category revenue/Total revenue of all categories*100

i tried summing up the total revenue of all categories using Moving_Total expression but it returns only value for individual categories and not the Total

Is there way we can use the summary from table to calculate

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!