In NSAW, how do I create a pivot table to count lines on sales orders? I want to know by week and shipping location, how many orders are processed with one line, two lines, 3 lines, etc. I can count lines with a count(distinct) function when the order is in the table, but I loose it when I take the order out, and show at a higher level.