This content has been marked as final. Show 2 replies
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!