Forum Discussion

MarioDias's avatar
MarioDias
Frequent Visitor
5 years ago
Solved

Summarize Running Total that resets as categories changes

I am trying to write a SUMMARIZE function that calculates Running Total based on a determined category:   Table Category 1 Category 2 Total Running Total (goal) Apple Basket 1 5 5 A...
Need Help
  • MarioDias's avatar
    MarioDias
    5 years ago

    Hello  everyone.

    It looks like switching ALLSELECT by ALLEXCEPT solves the problem. Thanks parry2k for all the messages.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

MarioDias what is your end goal? Why do you need to summarize? Can you provide more details?

MarioDias's avatar
MarioDias
Frequent Visitor
5 years ago

Thanks for your message parry2k 
I will used SUMMARIZE to filter rows and get a scalar value. Filters like showing categories with less than specifict totals.