Hello there guys,
I am running a new database and im facing the following situation. I have 4 large databases each from 2020, 2021. 2022, and 2023.
I have everything sorted by department and the department also has a subdivision, so what Im trying to do is the following.
I want a table that shows department (In this case Production) - and then I would like to see filtered information regarding the subdivisions across 2020, 2021, 2022, 2023.
So would be like
Department. Subdivision Fiscal Year 2020 Fiscal Year 2021 Fiscal Year 2022
Production: Subdivision 1 10,000. 15,000. 20,0000
Subdivision 2. 0 5,0000
Subdivision 3. 0. 0 15,000
Now, these subdivisions are different per fiscal year, so I was considering stacking all the subdivisions into a column and using this column to reflect the values on the databases. And then establishing relationship between those, but I am a bit lost now, any help would be appreciated
