Thank you for the detail explanations, but it's quite difficult for me to understand your request.
It is helpful if you can provide some hand-drawing-pictures which illustrate your expectations.
Please see attached image.
The yellow area will show average sales returned for 2015 + 2016
The red line will show 2017 sales returned - I.e. this will be current year
The black line is the 2018 target ( sales returned ceiling target)
The idea is to show historical average for (2015 and 2016) and compare this
with current performance (2017) and to also show how this performance
compares against the target (2018 sales returned ceiling)
Thank you so much for your help
On Wednesday, 25 April 2018, Shinichiro Murakami <
image.jpg 524.3 KB
Thank you so very much
The target dummy data is awful I know its nearly 4am my time here and I just cooked up any numbers
Your help is so invaluable, I cannot thank you enough!
You are very welcome.