ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 302
- Office Version
- 2016
- Platform
- Windows
I have created a power pivot using 2 separate tables with the same headers, Table 1 is for Sales, Table 2 is for production. (My table would ha
I am simply trying to create a sum of sales and production for each facility filtered by the Fiscal year. Is there a way for 1 slicer to filter out the Fiscal year for Production and sales.
I am simply trying to create a sum of sales and production for each facility filtered by the Fiscal year. Is there a way for 1 slicer to filter out the Fiscal year for Production and sales.
Table 1 (Sales) | |||
---|---|---|---|
Fiscal Year | Facility 1 | Facility 2 | Total |
2019 | 100 | 150 | 250 |
2020 | 110 | 150 | 260 |
Table 2 (Production) | |||
Fiscal Year | Facility 1 | Facility 2 | Total |
2019 | 120 | 150 | 270 |
2020 | 115 | 145 | 260 |