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

    Actual and Target at different level

    arthi.keat

      Hi,

       

      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.

       

      Regards,

      Arthi.