Skip to main content

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
  1. Jun 22, 2017, 5:33 PM

    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.

    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.RefLine.png

0/9000