5 Replies Latest reply on Aug 2, 2013 6:01 AM by Jim Wahl

    Grand totals still show when filtered using last()==0

    Willem Botha

      Hi all,

       

      I use last()==0 to show only the latest period figures in a specific view, but when I add a grand total I see the totals for all periods and the rows for only the latest.

       

      How can I exclude the grand totals for prior periods too? I.e.in the picture below, I don't want to see Feb or March totals.

       

      KeepLast.PNG.png

       

      Thanks,
      W