GUIDO22
Registered User.
- Local time
- Today, 04:54
- Joined
- Nov 2, 2003
- Messages
- 515
I have a Sales report grouped by Customer that shows annual sales figures for each. When the report runs - the database user is prompted for the 'Start Year'. The reports retrieves data for all years from Start to present year...
I wish to be able to visually illustrate the Trend for each Customers' sales pattern over this period.
Either :
a) a graph embedded in the report, linked to that customers annual Sales figures (Sales against Year) - to graphically show the trend
b) if a) is too difficult, what is the mathematical expression I could use from the annual sales totals to determine the overall trend of sales for that customer...
for example: if the figures over a 10 year period are more or less, decreasing year on year - is there a function that can determine the overall trend and output a result of say : >>Trend DOWN .
Thanks in advance for any help/advice offered.
I wish to be able to visually illustrate the Trend for each Customers' sales pattern over this period.
Either :
a) a graph embedded in the report, linked to that customers annual Sales figures (Sales against Year) - to graphically show the trend
b) if a) is too difficult, what is the mathematical expression I could use from the annual sales totals to determine the overall trend of sales for that customer...
for example: if the figures over a 10 year period are more or less, decreasing year on year - is there a function that can determine the overall trend and output a result of say : >>Trend DOWN .
Thanks in advance for any help/advice offered.
