It' quite difficult to understand the difference between sample data and your original data.
I duplicated the datasource to make the two different filter possible, but the key is primary data always needs to have wider Date range than secondary data.
In your example, shipping date had longer range, then I used ship date filter on Prime data source and Order Date filter on secondary data source.
I hope this helps.
There's no original data, everything there is sample data, meaning the superstore data provided by tableau.
However, I noticed that you duplicated the data and each filter was applied to its respective measure, thank you. This solves the issues I was dealing with.
I have another question regarding filters that you pointed out, if the primary data does have a shorter range than the secondary data, how does that effect the current setup that you constructed?
When you filter Primary data, All the secondary data is also filtered out because it's linked (Made relationships).
But now I start thinking that if you don't need the yearly value, only need total amount in specific range filtered by secondary data source, that still works without linking "date" fields. .
I mean only link with "Customer Name".
BTW, if you solved the issue, could you mark my answer as correct for other people to know it's answered.
Thank you Shinichiro.