View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
walrus walrus is offline
external usenet poster
 
Posts: 29
Default Pivot adjustments

Following is extract from a pivot. All Centre IDs are related to 67210. I
want to show 67210 in each line


Account Centre ID Deptt 1 Deptt 2 Grand Total
67210 2110 0.06 0.06
6015 278.35 278.35
6999 (30.54) (30.54)
8010 131.67 131.67