My req is i have a column called order methods and the values are A,B, C and D. I want to classify the values based on no.of orders and no.of order lines.
My question here is how to display the filed values as columns and get the no.of orders and no.of order lines for each method A,B, C and D. Am calculating no.of orders based on a order number which is a direct column from DB and same for No.of order lines.
