When adding a calculated column to give you something like the Avg Price. The column appears across the whole pivot grid. So say you have your totalprice and qty showing for different stores. So the grid groups by stores. When you add the grandtotal calculation you get a new column added to each store.

I don't want the avg price added to each store .. I only want to see the average price in the grand totals section to the right?

Thanks.