3 Replies Latest reply on Dec 11, 2012 6:42 AM by Darren Evans

    How to display top 10 by total sales when each order is the level of detail shown

    Donna Coles

      I have a visualisation that shows sum(sales) by customer but where the bar representing the amount is segmented based on each order (orderid is level of detail).  The data can be filtered by product category.  I only want to show the top 10 customers according to the product category selected, but can't get this to work correctly when the order id is added to the level of detail shelf.  I have attached an example.

       

      I accept what I'm trying to do may not be possible.