Aggregate Grouping Method

  • 1
  • Question
  • Updated 5 years ago
What's the difference between a "simple" and "rollup" grouping method on an aggregate model? I couldn't find it in the documentation and playing around with the two settings didn't seem to give me different results for my model.
Photo of Craig Rosenbaum

Craig Rosenbaum

  • 4,970 Points 4k badge 2x thumb

Posted 5 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 45,308 Points 20k badge 2x thumb
"Simple" will just return the groupings you have defined.  Rollup will add subtotal lines that rollup the values from the aggregation.  If you only have one grouping, it will just add one extra line to the model.  But if you two or three groupings,  each level will have its own subtotal lines. 

Unfortunately this is not a very useful feature, because we do not provide any ability to show that this extra row is a subtotal. 

But now you know..