Hi there,
I would like to use standard deviation analyze as a trigger for upcoming data in the next quarters of the year.
As you can see in the picture, I try to display only the average and SD (1,2,3) of Q1 and extend the lines over the hole sheet.
Unfortunately, I don't find any option to delete the Q2 SD lines, without deleting everything.
Is there any possibility to solve the problem?
I appreciate your help!
Thank you in advance,
David
11 answers
Yes, it's possible to solve the problem and you will need to use LODs to achieve the same. Check out the complete solution in the attached 2019.2 workbook.
Hope this helps.
