LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Day
 
Posts: n/a
Default "Cumulative" column based on a pivot table sum column?

I'm trying to create a rollup column based on a pivot table data column. The
GETPIVOTDATA function includes static field and index ("item") references,
and so can't be copied (the copies reference the original pivot field/item
pair). Is there a better way to create a cumulative column than building it
cell-by-cell? I'm using Excel 2003. Thanks -
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot table rmsterling Excel Discussion (Misc queries) 5 November 14th 05 04:40 PM
pivot table created from another pivot table Kreed Excel Worksheet Functions 6 October 26th 05 04:16 PM
Sort a Column of Dates in Pivot Table Linny Excel Worksheet Functions 2 September 23rd 05 01:24 AM
Pivot Table -- Add column to average Grand Total Lynn Excel Worksheet Functions 1 August 30th 05 03:59 PM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM


All times are GMT +1. The time now is 05:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"