I have rows: salesman, products with column number sold and total revenue from sales. I want a column telling me average value of sale. Simple enough, just divide one column by another column. For some reason I can't find any way to do this with an OLAP pivot table.
Any tips how I can get this done? Thanks!
Bookmarks