How to show grand total at the top of an Access pivot table?

[sampun]

Hi all,

This is probably a stupid question but does anyone know how to show the grand total at the top of the pivot table instead of the bottom?

Many thanks,

Sam

 

[Dennisk]

not unless the pivot is displayed on a form where you can mainipulate the controls.

 

[sampun]

It's shown through a form...does that mean it can be achieved?

 

[Dennisk]

If you open the form in design mode you can change the placement of each control.