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.