View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KG KG is offline
external usenet poster
 
Posts: 33
Default Pivot Table Grandtotals. All or nothing?

I asked this question befo when selecting Column Grand Totals is it
possible to restrict them to the columns that make sense? I have columns for
volumes of some 50 products, unit prices for each and sales values. Only the
Sales Value Grand Total has any meaning but I am stuck with a sum of all the
unit prices and all the volumes which are not only meaningless, they are also
confusing.