I have 3 pivot charts each with their own data source. The tables are all set up the exact same way. They have the exact same layout, just different numbers whether it's referencing a 6 month, 12 month, or 2 year projection.
What I am trying to accomplish is I have all 3 pivot charts displayed on a tab, but I want one filter option that when changed, simultaneously changes the charts. That filter should be the material that when changed, the projections change according to that filter. I already can do it for each chart, but that can be annoying hence the need for 1 connected filter.
I put them into the data model, and attempted to link them, but I'm not experienced enough to make the links.
Any help is appreciated.
[TABLE="width: 468"]
<colgroup><col><col><col span="5"></colgroup><tbody>[TR]
[TD]Material[/TD]
[TD]Average[/TD]
[TD]1-Jan[/TD]
[TD]1-Feb[/TD]
[TD]1-Mar[/TD]
[TD]1-Apr[/TD]
[TD]1-May[/TD]
[/TR]
[TR]
[TD]N548210[/TD]
[TD="align: right"]128.26111[/TD]
[TD]0[/TD]
[TD="align: right"]121.67[/TD]
[TD]0[/TD]
[TD="align: right"]93.67[/TD]
[TD="align: right"]111.67[/TD]
[/TR]
[TR]
[TD]N548212[/TD]
[TD="align: right"]49.284[/TD]
[TD="align: right"]38.67[/TD]
[TD="align: right"]51.17[/TD]
[TD]0[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]54.83[/TD]
[/TR]
[TR]
[TD]N548214[/TD]
[TD="align: right"]12.0825[/TD]
[TD="align: right"]1.67[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]1.33[/TD]
[TD="align: right"]10.33[/TD]
[/TR]
[TR]
[TD]N548216[/TD]
[TD="align: right"]49.684[/TD]
[TD="align: right"]46.33[/TD]
[TD="align: right"]39.33[/TD]
[TD]0[/TD]
[TD="align: right"]44.17[/TD]
[TD="align: right"]38.17[/TD]
[/TR]
[TR]
[TD]N549340[/TD]
[TD="align: right"]1177.85[/TD]
[TD="align: right"]1194.5[/TD]
[TD="align: right"]1373.17[/TD]
[TD]0[/TD]
[TD="align: right"]972[/TD]
[TD="align: right"]747[/TD]
[/TR]
[TR]
[TD]N549342[/TD]
[TD="align: right"]617.584[/TD]
[TD="align: right"]401.67[/TD]
[TD="align: right"]490[/TD]
[TD]0[/TD]
[TD="align: right"]670.83[/TD]
[TD="align: right"]679.17[/TD]
[/TR]
[TR]
[TD]N353330[/TD]
[TD="align: right"]11.383[/TD]
[TD="align: right"]14.67[/TD]
[TD="align: right"]8.83[/TD]
[TD]0[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]11.17[/TD]
[/TR]
[TR]
[TD]N353615[/TD]
[TD="align: right"]269.549[/TD]
[TD="align: right"]613.33[/TD]
[TD="align: right"]558.33[/TD]
[TD]0[/TD]
[TD="align: right"]288.83[/TD]
[TD="align: right"]201.67[/TD]
[/TR]
[TR]
[TD]N356000[/TD]
[TD="align: right"]27.16625[/TD]
[TD="align: right"]0.67[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD]N356030[/TD]
[TD="align: right"]7552.216[/TD]
[TD="align: right"]6504.17[/TD]
[TD="align: right"]6654.17[/TD]
[TD]0[/TD]
[TD="align: right"]6766.33[/TD]
[TD="align: right"]7492.83[/TD]
[/TR]
[TR]
[TD]N356035[/TD]
[TD="align: right"]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]N356040[/TD]
[TD="align: right"]4724.366[/TD]
[TD="align: right"]5244.5[/TD]
[TD="align: right"]5119.5[/TD]
[TD]0[/TD]
[TD="align: right"]4748.67[/TD]
[TD="align: right"]4726.5[/TD]
[/TR]
</tbody>[/TABLE]
What I am trying to accomplish is I have all 3 pivot charts displayed on a tab, but I want one filter option that when changed, simultaneously changes the charts. That filter should be the material that when changed, the projections change according to that filter. I already can do it for each chart, but that can be annoying hence the need for 1 connected filter.
I put them into the data model, and attempted to link them, but I'm not experienced enough to make the links.
Any help is appreciated.
[TABLE="width: 468"]
<colgroup><col><col><col span="5"></colgroup><tbody>[TR]
[TD]Material[/TD]
[TD]Average[/TD]
[TD]1-Jan[/TD]
[TD]1-Feb[/TD]
[TD]1-Mar[/TD]
[TD]1-Apr[/TD]
[TD]1-May[/TD]
[/TR]
[TR]
[TD]N548210[/TD]
[TD="align: right"]128.26111[/TD]
[TD]0[/TD]
[TD="align: right"]121.67[/TD]
[TD]0[/TD]
[TD="align: right"]93.67[/TD]
[TD="align: right"]111.67[/TD]
[/TR]
[TR]
[TD]N548212[/TD]
[TD="align: right"]49.284[/TD]
[TD="align: right"]38.67[/TD]
[TD="align: right"]51.17[/TD]
[TD]0[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]54.83[/TD]
[/TR]
[TR]
[TD]N548214[/TD]
[TD="align: right"]12.0825[/TD]
[TD="align: right"]1.67[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]1.33[/TD]
[TD="align: right"]10.33[/TD]
[/TR]
[TR]
[TD]N548216[/TD]
[TD="align: right"]49.684[/TD]
[TD="align: right"]46.33[/TD]
[TD="align: right"]39.33[/TD]
[TD]0[/TD]
[TD="align: right"]44.17[/TD]
[TD="align: right"]38.17[/TD]
[/TR]
[TR]
[TD]N549340[/TD]
[TD="align: right"]1177.85[/TD]
[TD="align: right"]1194.5[/TD]
[TD="align: right"]1373.17[/TD]
[TD]0[/TD]
[TD="align: right"]972[/TD]
[TD="align: right"]747[/TD]
[/TR]
[TR]
[TD]N549342[/TD]
[TD="align: right"]617.584[/TD]
[TD="align: right"]401.67[/TD]
[TD="align: right"]490[/TD]
[TD]0[/TD]
[TD="align: right"]670.83[/TD]
[TD="align: right"]679.17[/TD]
[/TR]
[TR]
[TD]N353330[/TD]
[TD="align: right"]11.383[/TD]
[TD="align: right"]14.67[/TD]
[TD="align: right"]8.83[/TD]
[TD]0[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]11.17[/TD]
[/TR]
[TR]
[TD]N353615[/TD]
[TD="align: right"]269.549[/TD]
[TD="align: right"]613.33[/TD]
[TD="align: right"]558.33[/TD]
[TD]0[/TD]
[TD="align: right"]288.83[/TD]
[TD="align: right"]201.67[/TD]
[/TR]
[TR]
[TD]N356000[/TD]
[TD="align: right"]27.16625[/TD]
[TD="align: right"]0.67[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD]N356030[/TD]
[TD="align: right"]7552.216[/TD]
[TD="align: right"]6504.17[/TD]
[TD="align: right"]6654.17[/TD]
[TD]0[/TD]
[TD="align: right"]6766.33[/TD]
[TD="align: right"]7492.83[/TD]
[/TR]
[TR]
[TD]N356035[/TD]
[TD="align: right"]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]N356040[/TD]
[TD="align: right"]4724.366[/TD]
[TD="align: right"]5244.5[/TD]
[TD="align: right"]5119.5[/TD]
[TD]0[/TD]
[TD="align: right"]4748.67[/TD]
[TD="align: right"]4726.5[/TD]
[/TR]
</tbody>[/TABLE]