2 Replies Latest reply on Jan 12, 2012 8:08 AM by Matthew Brown

    Order Line Profitability by Customer

    Matthew Brown

      Ok- See attached "picture" of order line profitability. For each customer, what does profitability look like for each order line.  What i want to do is to have a page per customer, which has the profitability calculated for each order line.I'd like to have a pareto type line curve that keeps a running total(I think I know how to do this piece). The problem I have is when I place the Order + Order Line number on the columns shelf, it lists every order + orderline- even it it didn't relate to that customer. My profit margin is running down the Y axis, while my order line numbers are running down the X axis. I want to see a graph that shows only those order lines for that customer(which is the page level filter). Any ideas on how to solve would be great. Thanks matt