I have a reference line (total) that appears on a worksheet within a dashboard that has a filtering worksheet. When I filter the dashboard, the reference line total changes to reflect the total for the filtered category. I want the overall total for all categories to appear regardless of dashboard filtering. Is this possible?
Based on my understanding of the order of filtering in Tableau, your best bet is to duplicate the data source and then create calculated fields to get the appropriate total, then do a blend to get the total be used as the reference line. That way any filters on the primary data source won't affect the total calculation in the secondary data source.