Hi,
How can I add a goal line only to the total - lets say if i have a bar chart of sales by people and my last bar shows the total. I want to add a goal line only to this total - not to the entire table.
Regards,
2 answers
Create a calculated field that checks the dimension you are splitting by, e.g. sales person, to look for one vs. multiple values. In this case I am using Segment. Then put that on the Detail shelf and set your Reference Line to be "Per Cell". These pictures should be enough but I've attached a 10.3 TWBX as well.