how to generate the serial number as per the data lines uploaded?

[#1]

Dear All,

I have made a scatter chart which shows the contract expiring date, material & its value.

There are many contracts with same contract number linked to a specific material having different value. so we want to show as two different bubbles.

To seperate similar contract number cases, i have added a serial number field as the dimention to show the data.

Every time i have to upload a new excel sheet, I have to update the serial numbers.

Is it possible to generate serial number automatically depending upon the data lines uploaded & use it as a dimention.

Thanks in advance!

Best Regards

Rahul Kale

[Anonymous · Accepted solution]

Hi,

You can auto generate a counter field to a table using Rowno() for example

[#3]

Gr8 Thanks it works!

You made my day!