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.