Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi,

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

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi,

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

Not applicable
Author

Gr8 Thanks it works!

You made my day!