Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Switzerland
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Table & running total (2000k SP1)

    Folks,

    I am looking for a way to obtain running totals in Pivot Tables. I am pretty sure it can be done but I can't figure out how

  2. #2
    New Lounger
    Join Date
    Sep 2001
    Location
    Paignton, Devon, England
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table & running total (2000k SP1)

    alex,
    Right-click on your totals field, select 'Field Settings...', Options, select 'Running Total in..' from the 'Show data as' dropdown, then select Month in the Base Field list. Something close to that should work for you.

    graeme

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Switzerland
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table & running total (2000k SP1)

    Thanks - exactly on the money !

    <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

    --alex

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •