Row numbers

[BORUCH]

I have a sales table which has customer #, customer name, sales $, salesman,etc.

I would like to create a pivot table which has row numbers as the first Column so if I filter the table by salesman the row numbers reorganize themselves

line # customer # sales amt s/m[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]a[/TD]
[TD]100[/TD]
[TD]jack[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]b[/TD]
[TD]100[/TD]
[TD]jack[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]c[/TD]
[TD]100[/TD]
[TD]joe[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]d[/TD]
[TD]500[/TD]
[TD]david[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]e[/TD]
[TD]500[/TD]
[TD]jack[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]f[/TD]
[TD]500[/TD]
[TD]joe[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]jack[/TD]
[/TR]
</tbody>[/TABLE]

 

[BORUCH]

I have a sales table which has customer #, customer name, sales $, salesman,etc.

I would like to create a pivot table which has row numbers as the first Column so if I filter the table by salesman the row numbers reorganize themselves

line # customer # sales amt s/m[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]a[/TD]
[TD]100[/TD]
[TD]jack[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]b[/TD]
[TD]100[/TD]
[TD]jack[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]c[/TD]
[TD]100[/TD]
[TD]joe[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]d[/TD]
[TD]500[/TD]
[TD]david[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]e[/TD]
[TD]500[/TD]
[TD]jack[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]f[/TD]
[TD]500[/TD]
[TD]joe[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]jack[/TD]
[/TR]
</tbody>[/TABLE]

I would appreciate any suggestions it must be possible somehow

 

[BORUCH]

I would appreciate if anybody on the panel can find a solution to my problem.
All I’m looking for is simple line numbers, as the first Column on my pivot table which dynamically updates based on any filter I use

THANKS