I have over 171500 rows of data. When I use Subtotal tool, Calc stops working.
Here is the data
https://porssisahko.net/api/internal/excel-export
Store the large document in the native file format of your application. That is Open Document Spreadsheet (*.ods).
Use a pivot table instead of subtotals.