LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Joanne R.
 
Posts: n/a
Default How do I repeat a value in a pivot table in Excel?

I have created a pivot table that lists account numbers, names, and the type
of service. I would like the account number and name to repeat for each
service type within that account (right now it is only showing the one time).
The reason being is that I need to filter on the service type and the
results are misleading if the values are not repeated in the account # and
account name, or the values are just blank.


Account # Account Name Service Category
127366292 S & B TECHNICAL PRODUCTS Express
International
276630709 COWBOY DECOR Express
Ground
International
Home Delivery
312110628 ELI GROUP Express
International

 
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
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
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Excel Pivot Table with Access ExcelQuestions Excel Discussion (Misc queries) 0 April 11th 05 03:37 PM
convert excel list to pivot table GI Excel Discussion (Misc queries) 0 December 6th 04 06:45 PM


All times are GMT +1. The time now is 02:53 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"