Probably with lot's of zeroes in front?
If you want to keep something that looks like a number as the exact string value it had when you first brought it into your data model, you can either
If this is not describing a solution, please provide fursther details on what you mean by "include a serial number in a pivot" and why you are unable to do so.
Do you have any suggestion to use above serial no. not sensitive with selections. I mean what ever the selection in my pivot table serial no should starts with ONE and ends with the last raw no.
For use in (dynamic) chart objects (tables or graphs) you're on the wrong track with numbering table rows in your script with RecNo().
However, RowNo() can be used in sheet objects as well, and it will dynamically number the currently displayed rows. In a pivot table, use =RowNo() as the first dimension column, or use 'total' as parameter to number from the start.
You can use RowNo() in that case . If you have one dimension, RowNo() function would be fine. If you have more than one dimension, you need to use RowNo(Total). I have attached a sample file for your understanding.
pivot table (raw number)
I thought you were asking for a serial number based on your raw data. (You were mentioned as raw number).