LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Pivot Tables - Column Fields

I am trying to use a Pivot table to upload information into a Hyperion
Financial Management software program. However for an HFM upload, I need to
have the description on every row even if it replicates. As an example I am
loading PPE. We have three separate rows for cost, depreciation, and net
book value for every company (40 different companies). On my current pivot
table, it shows on 3 separate rows the cost, depreciation, and net book
value, but the company number is listed only on the cost line, I need the
company number entered on every line. Is it possible to change this
formatting?
 
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
Customise Pivot Tables Fields Ash007 Excel Discussion (Misc queries) 0 March 28th 08 05:36 PM
Pivot Tables - how do I add in calculated fields? ColinS via OfficeKB.com Excel Worksheet Functions 0 April 6th 06 05:40 PM
row fields in pivot tables saeed Excel Discussion (Misc queries) 2 May 7th 05 02:46 AM
About Hiding Fields in Pivot Tables bay Excel Discussion (Misc queries) 1 January 27th 05 01:51 PM
Pivot Tables, calculated fields Excel GuRu Excel Discussion (Misc queries) 1 December 21st 04 12:08 AM


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