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.
|