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

Pivot adjustments
 

Hi,
you can copy the value down, if you have different numbers you can use a
formula like the following, I assume that 67210 is in cell A2, and your
formula in D2 so D2 enter

=if(A2<"",A2,D1)

copy formula down

"walrus" wrote:

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