I am having an issue creating an aggregate report. When creating a Pivot or Aggregate report the QTY & Amount Measures return " The result set is too large and exceeds the max group limit"
Current State: Sample Detailed Sales Order report has 9 rows of data unique identifier is Sales Order Line
Goal: create summary by Sales Order Line with QTY and AMOUNT as measures
Question: how to achieve using Incorta?
There is a limitation in the Incorta and only up to a certain number of rows it can display whenever we use pivot or aggregate reports (especially when the report has to display a large set of rows). the workaround is to put some default filters on the sales order line for your case in the filter and prompt section.
and one more thing, try to increase the Max groups by click the gear icon in settings.
Hi Patrick Ackley please reference the following article and let us know if you still have questions: https://community.incorta.com/t/80jz0k/what-does-it-mean-when-my-insight-says-the-result-set-is-too-large-and-exceeds-the-max-group-limit