Unfortunately this is a bit complicated to deal with in Tableau....a number of different solutions have been created, see Utilization, Queues, Census, Throughput for Blocks, Floors, Units, Rooms, Offices, etc. - What do you do? for a list.
Any chance you can attach a sample .twbx?
I'd like to create something similar to that + AVG of sales 2011-2015 (which is not shown in this graph)
1. the green line is 2016 sales - in order to do it I added another column to the data base - can I do it without additional separate column?
2. to make sure i have only the max and min showed i had to get rid of the one in the middle manually - do you know how to do it automatically?
3. need to add AVG of sales 2011-2015 line (like 2016 sale but in a diffrent color) and don't know how to do it
(once I remove manually the sales of 2011-2015 to see only the max and min it also remove this data from the avg function calculation)