I have a Line Chart that is the Sum of Staffing Need (expression) by Quarter Date (dimension). I also have a second dimension that is Drill-able to show the Sum of Staffing Needs by "Region" then "Business" then "Job Function" and so on...
I want to add a reference line to each Drill-able dimension by a Field called "Active" which will act as a baseline for each "Sum of staffing need" by quarter date.
Currently I have Reference Line under the Presentation Tab set to "Active" but it only sets a Reference Line for the last Field Name and possible selection in the Drill-down.
Any ideas on how to solve this???
