Hi
Grand Total by Row is always at the far right of the PT
Grand Total by Column is always at the bottom on the PT.
There is no way of changing that.

Regardless of the position, if you use the GetPivotData function, rather
than a cell reference, it will always pick up your totals for you.
For help on the use of GetPivotdata take a look at

http://www.contextures.com/xlPivot06.html
--
Regards
Roger Govier

"houghi" wrote in message
...
Hello,

I run excel 2000 (company policy) and I have the following in a Pivot
table:

User Day Duration
user1 30
Monday 10
Tuesday 20
user2 12
Monday 5
Tuesday 7
Total 42

So the subtotals already are on top. However I would like to have it
like:
User Day Duration
Total 42
user1 30
Monday 10
Tuesday 20
user2 12
Monday 5
Tuesday 7

The reason is then the totals are always in the same place, making it
easier to link to those numbers.

I could use 2 pivot tables, one with the totals and one with the
subtotals. However is it possible to do it with one?


houghi
--
Knock-knock.
Who's there?
Under the Patriot Act, we don't have to tell you that.