how to get rowno in a pivot table

[lmonincx]

Hi,

I am looking for a way to insert a column which is giving each row a number like 1,2,3,4 etc,

it's independant of the content of the sort order of the chart

so row number 1 is always1 etc.

Kind regards,

Linda Monincx

[marcus_sommer]

Try it with rowno() respectively rowno(TOTAL) as expression.

- Marcus

[Siva_Sankar]

Row Number in pivot table

Rowno() in pivot table

Get cell value from a pivot table using rowno() and columnno() - in chart expressions

Utilisation of Rowno function with subgroups of records in a pivot table

Above discussions may help.

[Anonymous]

Simple, what Marcus suggested you