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!


      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!