1 Reply Latest reply on Mar 10, 2017 9:24 AM by PJ S

    Blending vs Filters

    PJ S

      Hi all,

       

      I have data from 2 sources

      Source1 - Cat, SubCat, Sales, Date

      Source 2- Date, CatGoals

      (we don't have any goals for SubCat)

       

      when I try to make a viz- Date vs Sales and Goals (dual axis- Sales- Bar and Goals-Line)

      color by SubCat on Sales Bar

      Filters - Cat, SubCat

       

      when I filter SubCat, tableau automatically calculates goals for SubCats, is there a way to avoid this and just have CatGoals on my viz while filtered by SubCat.