test data incresing sales

[felcar2013]

Hi community

i generated sample data (approx. 90.000 records) for a Dashboard purpose, but need increasing sales per month, and keeping some variability in the daily data as i also need weekly data.

Do you know any automatic way to alter the data so that i can get this result?

thanks

felipe

[tresesco]

You can use Rand() or simply:

Load

          Rowno() as Data

Autogenerate  10000000;

Or a little bit of modification to it to fit your requirement, may be.

[felcar2013]

i attached the file i am using. due to different requirements on the user Interface i needed to create the data like that. I Need the the sales data (Umsatz) for all years 2014,15,16 and 17 Looks like for 2014, increasing. Is there any way to achieve this without doing Trial and error?

thanks