Splitting report data across multiple Excel tabs

You can use the Sheet Break feature in the template configuration. The Sheet Break function allows you to split the output file into different sheets.

The split is triggered whenever the value in the selected column changes. You would apply the ‘Sheet Break’ option to the Legal Entity column to achieve the desired segmentation.

It is located in the section defining the Displayed Columns, alongside the ‘Aggr.’ and ‘Sort Order’ settings.

Yes, it organizes the data output. Remember that Blitz Report can also handle very large row counts by automatically overflowing data exceeding 1,048,576 rows to additional sheets, even without a configured Sheet Break.