LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hackensack
 
Posts: n/a
Default Using non standard actions on an Excel 97 pivot table

I have a data table containing 52 weeks data on 20 people e.g. number of
holidays taken in a particular week, Income in a particular week.
I'm using pivot table to summarise the data and need to use a non standard
command to select the last income figure (say week 52) for each of the
persons rather than for example Sum of Income.
Any ideas?
 
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
Referencing Data in a Pivot table. More Excel 2003 misery Incoherent Excel Worksheet Functions 1 March 10th 06 09:43 AM
How do you unlock a pivot table on a protected excel sheet? [email protected] Excel Worksheet Functions 2 September 25th 05 01:01 AM
get SQL Server text data type into Excel pivot table Lee@360Commerce Excel Discussion (Misc queries) 0 August 19th 05 11:37 PM
Excel Pivot Table Question Tom Excel Discussion (Misc queries) 0 August 2nd 05 06:31 PM
Pivot Table Security in Excel JBankson Excel Discussion (Misc queries) 0 February 2nd 05 12:01 AM


All times are GMT +1. The time now is 08:48 PM.

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"