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

1	a	100	jack
2	b	100	jack
3	c	100	joe
4	d	500	david
5	e	500	jack
6	f	500	joe

<tbody>
</tbody>

jack

<tbody>
</tbody>

 

[Sinon]

You can use ROW() in your source table to get the row number and then use that in your pivot.

 

[BORUCH]

You can use ROW() in your source table to get the row number and then use that in your pivot.

The row function doesn’t work, in doesn’t even work in regular excel table when you filter, all I want is simple line number, so if I filter by anything in that table like customer # etc. the line numbers should recalculate per the number of entries there are for that filter .

 

[BORUCH]

the row function doesn’t work, in doesn’t even work in regular excel table when you filter, all i want is simple line number, so if i filter by anything in that table like customer # etc. The line numbers should recalculate per the number of entries there are for that filter .

any updates?

 

[63falcondude]

Try this

Excel 2010
	A	B	C	D
1	line #	Customer	Sales Amt	s/m
2	1	a	100	jack
3	2	b	100	jack
4	3	c	100	joe
5	4	d	500	david
6	5	e	500	jack
7	6	f	500	joe
Sheet3

Cell Formulas
Range	Formula
A2	=SUBTOTAL(3,D$2:D2)

 

[63falcondude]

Filtered on "joe"

Excel 2010
	A	B	C	D
1	line #	Customer	Sales Amt	s/m
4	1	c	100	joe
7	2	f	500	joe
Sheet3

 

[BORUCH]

Filtered on "joe"

Excel 2010

	A	B	C	D
1	line #	Customer	Sales Amt	s/m
4	1	c	100	joe
7	2	f	500	joe

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet3​

I need a dax formula not an excel formula I’m tryingto use this in a power pivot

 

[63falcondude]

I need a dax formula not an excel formula I’m tryingto use this in a power pivot

Oh my mistake. I didn't notice what sub-forum this was in.

 

[BORUCH]

Oh my mistake. I didn't notice what sub-forum this was in.

Is there any way it can be done I doubt that power pivot is limited

 

[63falcondude]

Is there any way it can be done I doubt that power pivot is limited

I don't know the first thing about power pivots so unfortunately I can not help you there.