1 2 Previous Next 27 Replies Latest reply on Jan 8, 2016 11:29 AM by Jonathan Drummey

    Grand Total Does NOT Update With Top Filter from Calculated Field

    Todd Richards

      Hi,

       

      I've read a lot of posts where the Column Grand Total (GT) of a sheet will not recalculate properly if certain types of filters are used.  I'm currently using what to me seems to be somewhat of a complex filter where I'm filtering the report based on the aggregate of a particular column and taking the top vendors from that list based on using the RANK() function.  I want the grand total to update based on the top records I have selected but I'm not sure how to get that to show up based on how I have the report set up.

       

      Does anyone have an idea on a work around for my attached workbook?

        1 2 Previous Next