View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cindy H Cindy H is offline
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?