Hi,
I’m encountering an issue where the Subtotal row disappears when a filter is applied.
When the filter is set to “All”, the subtotal row is visible. However, when I filter the data (showing only specific values), the subtotal row disappears.
This behavior is consistent across Excel 2007, Office 365, and when saving in ODF format. Attached is picture of the problem I’m experiencing.
Interestingly, this does not happen in Excel—the subtotal row remains visible even when filters are applied.
Has anyone experienced this before or knows why this happens?
Thanks.
Henry
