I am uploading simple sample with my issue. I have created PIVOT and visually formatted it as I want. Now, I need to add column before first pivot column with auto increment number. I can add it and auto fill it, but it is not part of PIVOT, and also it is not colored as pivot. I am asking is it possible to add it to be part of pivot, also when I add new data in Base table, that column should be auto filled ad long as there is new rows.