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

      Hi,

       

      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

       

      2017-10-25_11-57-21.png

       

       

      Attached my worksheet.

       

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

       

      Best,

       

      T