Search for answers here or ask a question
0

How to reset running total by a dimension value

We want to create a running total over time for each state and we want it to reset for each state.  If I create a running total quick calc off of an existing measure it totals across all states.  I want to only have the running total for each state.

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Ian MacdonaldAdmin
    • Team Lead - Product Management
    • Ian_Macdonald
    • 2 wk ago
    • Official response
    • Reported - view

    Hi Robert,

    Here you go:

    If this is a Pyramid Semantic Model, you could also consider using the (relatively) new semi-additive Cumulative Aggregation option in the Model. This will then handle all scenarios without you having to code a calculation for it:

    This post should really be  in the Q&A forum.

    Hope that helps.

    Ian

    Like 1
    • Ian Macdonald  Moved it to Q&A

      Like
  • Thank you so much Ian Macdonald !!

    Like
Like Follow
  • Status Answered
  • 2 wk agoLast active
  • 3Replies
  • 21Views
  • 3 Following