I have a set of data that I need to display as filtered by 2 factors i.e. Life stage (e.g.Young people) and Car Model (e.g. those driving a Suzuki Swift)
The problem I'm having is that parts of my data that are created from calculated fields don't seem to be factoring in both filters when calculating the figures. When I only use 1 filter on all of my worksheets, the numbers add up fine and the calculated fields work fine, but when I use both filters, the numbers don't add up and it seems like the calculated fields don't seem to be taking both filters into account.
Does anyone know how to get data and calculated fields to factor in multiple filters when calculating numbers?
Please refer to the 'Getting Started' link on the front page of the community for some helpful advice getting started here.
As per that advice, it's really difficult to help you specifically without you providing a Tableau Packaged Workbook including sample data so we can replicate your problem. Please upload a sample and we'll go from there.