My report is January - December sales trends. I have "quanity", "dollar" and "average" fields that subtotal. How do I get the "average" field to actually do an average of the sum of total "dollars"/total "quanity"? It seems that Excel will not allow me to use formulas a pivot form. Must I go back to the query level and include it there?
Thanks, in advance, for any help!
Thanks, in advance, for any help!