3 Replies Latest reply on Jan 25, 2017 1:41 PM by Norbert Maijoor

    Need help with % of total table calculation

    Vincent Baumel

      Hi friends!

       

      I've got a table of data with a sum(sales) column and % of total column. This list is 259 rows, but I'd like to pare it down to the top 10 by sales. This is easy enough to do, but then the percentages shift to accommodate only 10 items (and all percentages jump up accordingly). Any idea how I might retain those initial percentages despite filtering down my list? I'll attach a sample workbook in 10.0.