1 2 Previous Next 27 Replies Latest reply on Apr 11, 2013 10:30 AM by Swee Chua

    Table showing top 10 customers AND sales to "other customers"

    Swee Chua

      Hi, I have sales transactions data showing customers and sale amounts. I would like to show sales to the 10 ten customers AND another line "Other customers" which would be the difference between total sales and sales to the top 10 customers. The grand total at the bottom row would then show the total sales, not just the total sales to the top 10 customers.

      What is the best way of doing this?

      Thanks.

        1 2 Previous Next