2 Replies Latest reply on Apr 23, 2012 1:03 PM by Lee Feinberg

    How to show Grand Total only for the select items?

    Edwin Mulianto

      Hi Guys,


      This is my first post in the forum, and I hope you can help me with the problem I am facing.  It's very simple but I can't seem to find the solution. If you look at my print screen below: what I want to do is to not show 'All Other Providers' and 'Null' data in my table, and have the Grand Totals of units and percentages to show only those of the top 10 referring providers in the table (they will be less than 693 and 100%, respectively).  I could simply exclude them from my data; however, that will mess up my percentages because it will calculate the percentages of only the 10 referring providers listed in the table.  That's not what I want.  I could also simply hide them, but that won't change the grand totals of units and percentages.  In other