I have a line chart that renders the default measure (a calculated percentage) segmented by the values of the field in Series (primary axis). This is working as expected, but I need to add a line to the chart that is a summary of the 3 segmented values (e.g. a 'Total' line). How do I do this? Thanks!
(http://i1305.photobucket.com/albums/s557/PSRNHME/Line%20chart%20-%20how%20to%20add%20series%20summary%20value%20line_zpsubishozj.jpg) (http://s1305.photobucket.com/user/PSRNHME/media/Line%20chart%20-%20how%20to%20add%20series%20summary%20value%20line_zpsubishozj.jpg.html)
Click on your chart and find the Combinations property. Add another line to the primary axis and leave the series empty. It will plot the default measure for the categories.
Thank you!! I have to say though that that is a fairly unintuitive way to achieve this. Thank the powers that be for this forum :)