I want to use a pivot and add some measures ignoring the pivot column. I
have data something similar to below.Department OrderID OrderTotal
ItemsSold Quantity Cost Dept1 Order1 600 Item1 6 100 Dept1 Order2 400
Item2 8 50 Dept2 Order3 1200 item2 4 300...