1 Reply Latest reply on Jul 20, 2016 5:13 PM by Patrick A Van Der Hyde

    Actual and Target at different level




      My actual is at a more granular level than the Target. I have attached a workbook. Target is at quarterly level where as Actuals are Segment level.


      The challenge that I am having is, when i try to plot both of them in a chart and give an option to select segments, targets at annual level are also being shown. How can we hide it when a user selects a segment. The data source is an excel and I also have flexibilty to manipulate the data source but no idea how. I have attached both the data source as well as the tableau workbook.


      Any help is greatly appreciated.


      Thank you for your time.