0 Replies Latest reply on Aug 1, 2012 8:25 AM by Jason Strimpel

    Grand Total of Values Within View

    Jason Strimpel

      Greetings,

       

      I've built a view which shows the top 10 companies by sales out of 150 companies, ordered in descending order by sales. When I add the Row Grand Total from the Analysis menu, it shows the total for the entire 150 instead of only those 10 in the view.

       

      I would like to add a row at the bottom of the view which shows the total for only those 10 companies currently within the view.

       

      Further, I would like to display what percentage of sales these 10 make of the entire 150.

       

      Any thoughts on this?