Number rows in Pivot Table

[acerrhod]

Can pivot table be number each rows? if can do can somebody show how to do

[scott.s.fower]

next to the left hand side of the pivot table, in the first row of data (where you want 1), type the formula =IF(H4="Grand Total","",IF(H4<>"",1+G3,"")) <--in this example my headers start in row 3 (first row of data is in row 4), and the pivot table starts in the H column. the grand total line will also be blank, since there is no reason to have a line number for the total

copy this formula down the length of the pivot table if there is data in the cell to the right it will add 1 to the cell above
Sample Workbook.xlsx

[acerrhod]

it works, thanks

[acerrhod]

[SOLVE] thank you very much

[scott.s.fower]

to actually mark the thread as solved, go up to the top to the thread tools > Mark as Solved