pivot table -->grand total--> rename caption

M

maXim

well i have pivot tabel and showing the grand total in the details section.
can i rename this grand total to sumthing else...???
 
S

strive4peace

try this...

in the query:

field --> Columnname: expression

just preface whatever is in the field cell with "Columnname: "

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Top