5 Replies Latest reply on Oct 25, 2017 4:17 PM by Jonathan Drummey

    Grand Total Does NOT Update With Parameter Top Filter

    Thiago Alpoin



      I'm having a similar issue described in
      Re: Grand Total Does NOT Update With Top Filter from Calculated Field


      Answered by Jonathan Drummey


      However, after hours trying to replicate the steps without success and also reading the article Customizing Grand Totals – Part 2 | Drawing with Numbers , I can't figure it out why the Grand Total doe NOT update.


      Could someone help me out?


      The goal is to update the Grand Total based on the Parameter Top N.


      In the screenshot below; the correct value should be:

      Parameter TOP 1 = 413

      Parameter TOP 2 = 547

      Parameter TOP 3 (ALL) = 629





      Attached my worksheet.


      Thank you so much in advance for any hint and help.