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.
Try it with rowno() respectively rowno(TOTAL) as expression.
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.
Simple, what Marcus suggested you
Retrieving data ...