Hi - I have a worksheet that filters for top x customer using a basic INDEX(). The filter works fine, but the grand total includes customer values that have been filtered and no longer appear on the worksheet.
Is there i way i can have the grand total (or subtotal) match with the detail displayed on the screen once the index() filter is applied ?
This is discussed here:
As a workaround, you can select all the members in the view, right click and select Keep Only.
Hope this helps!