group accumulate function



  • Official comment
    Joel Stewart

    Hi Matthew, the GROUPACCUMULATE function should be exactly what you're looking for. It's important to note that it pairs specifically with a group series function (i.e. GROUP_SORT_ASC). For example using the data that you provided, here are the columns that I would create in a new sheet to replicate the Running Total value that you have above:

    • GROUPBY(#SheetName!Food)
    • GROUP_SORT_ASC(#SheetName!Slices)
    • GROUPACCUMULATE(#SheetName!Slices; #SheetName!NumberOfOrders)


    Comment actions Permalink
  • Matthew Burns

    Thank you, the sort part seemed to be what was causing my issues

    Comment actions Permalink

Please sign in to leave a comment.