I want to use the dual function to put a label by each line in the attached line graph. Having the legend on the right is to hard to follow.
I would like to have the label at the far right of each line. I assume I can use the dual function for this (I know I have seen this done before but can't find the reference.
Add new expression similar to - Dual(If(Date=Max(total Date), <field to be displayed>, ' '),Sum(Sales))
Deselect show legend in presentation and Values on Data points in expression.
Dont set no format for expression else Dual won't work.
Seems you have many other things involved could be making difference here. Try it with sample data and then see how it can be incorporated. I will see if I can share sample here.