1 Reply Latest reply on Jun 27, 2016 2:28 AM by Yuriy Fal Branched to a new discussion.

    Ranking not working properly when displaying Row Grand Total!

    deepesh.moad

      Hi Guys,

       

      I need your help here.

       

      I am not sure what is causing the issue.I am trying to filter Top N Customers but also want to keep Row Grand Total.

       

      On filter Top N,the unwanted rows are still displaying with blank cells.

       

      Ranking Issue.png

      I cannot remove Row Grand Total.Is there any way to overcome this issue.

       

      Attaching workbook.

       

      Thanks a lot!