I have 2 tables like the below. Let's call one 'Test Table':
| Location | Product | Date | Supply | Demand | Above Target | Below Target |
| 1 | 100 | 1/1/2023 | 50 | 60 | 0 | 10 |
| 1 | 100 | 2/1/2023 | 60 | 50 | 10 | 0 |
| 2 | 100 | 3/1/2023 | 20 | 40 | 0 | 20 |
| 3 | 200 | 1/1/2023 | 35 | 50 | 0 | 15 |
| 3 | 200 | 6/1/2023 | 20 | 20 | 0 | 0 |
| 4 | 100 | 5/1/2023 | 10 | 10 | 0 | 0 |
| 4 | 300 | 1/1/2023 | 70 | 60 | 10 | 0 |
and the 2nd one 'Master Table':
| Planner | Product |
| Name1 | 100 |
| Name2 | 200 |
| Name3 | 300 |
I'd like to create 2 slicers:
1) A slider to determine number of months in the future
2) A slider for the sum of 'Supply' grouped by Location & Product
I want these 2 sliders to affect 2 separate visuals at the same time:
1) A chart showing sum of supply within the sliced number of months of today's date
2) A chart showing sum of 'Above Target' and 'Below Target' separately for each planner name, only for 'Product' that meet the Supply and Date ranges entered in the slicer
I am having a hard time wrapping my head around the logic of connecting the 'Supply' slider result to the 2nd visual (with the above and below target) when supply is not part of the visual.
