1 Reply Latest reply on Dec 11, 2012 4:37 PM by Tracy Rodgers

    Grand Total not affected by INDEX() filter ?

    Stephen Smirl

      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 ?