LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default Data Field in Pivot Table

Is it possible to change data field values (i.e. if they all show as "1") to
something else on a per column basis? I have 3 different columns, and did
not put any data in the data field so that I can see when the row & column
data match but I need the 1's that appear for matches to be replaced with a
different word per column. 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
Pivot Table Data Field ... )2 Ken Excel Discussion (Misc queries) 0 May 21st 10 07:39 PM
Pivot table field data Steve 51 Excel Discussion (Misc queries) 1 February 9th 09 08:35 PM
use field data from 1 pivot table in another? fdibbins Excel Worksheet Functions 1 November 6th 06 06:28 PM
use field data from 1 pivot table in another? fdibbins Excel Worksheet Functions 0 November 6th 06 06:15 PM
Pivot Table Field Data Annie Excel Worksheet Functions 4 January 9th 06 03:40 PM


All times are GMT +1. The time now is 11:15 AM.

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

About Us

"It's about Microsoft Excel"