CALC subtotal REMOVE destroys underlying data

how to REMOVE subtotal in CALC?

thank you, i know how to use REMOVE SUBTOTAL, my problem is when I apply REMOVE
my underlying data is DELETED.

Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.

You may consider to abandon the usage of SUBTOTAL().
How to do so is exemplified in the attached Calc document.
disask109686_SubtotalsInExtraColumn.ods (29.0 KB)