Pivot Report - Remove 'Sum of'

Giganews Newsgroups
Subject: Pivot Report - Remove 'Sum of'
Posted by:  Marlyn
Date: Wed, 24 May 2006


I am wanting to remove the function in the name of a pivot table field.

If i go to rename and remove 'Sum of' it rejects based on the pivot report
already having that variable.

Any clues?

By the way when you use an auto format, this function is appllied - ie it
gives you the title Volume rather than Sum of Volume.