Duplicate Subtotal Values in Excel Export

Hi Team,

 

When the subtotal is displayed in a separate column, why is the subtotal amount repeated on every detail row in the Excel export, even though it appears correctly only at the subtotal level within the report? Is there a way to ensure the subtotal value is exported only on the corresponding subtotal row?

 

Thanks,

Raveena