I want to know how to show only the lines shown in the black circles. I wrote a calculation to get values of 'dips' (e.g: Feb, April, July, oct, dec), but those are just point. I can't figure out how to make the line.
I want this so i can make the negative parts of the line chart to be an area (With use of dual axis). Like this
5 answers
Also, if you want the chart NOT to show the bars where there was a positive increase over the past month and no decrease in the next month, you could adjust your Sales column to replace these values with NULL:
Sales Adjusted:
IF SUM([Sales]) > LOOKUP(zn(SUM([Sales])),-1) AND
SUM([Sales]) < LOOKUP(zn(SUM([Sales])),1)
THEN NULL
ELSE SUM([Sales])
END
Thanks,
Jennifer
