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.
<colgroup><col><col><col span="5"></colgroup><tbody>
</tbody>
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.
Material | Average | 1-Jan | 1-Feb | 1-Mar | 1-Apr | 1-May |
N548210 | 128.26111 | 0 | 121.67 | 0 | 93.67 | 111.67 |
N548212 | 49.284 | 38.67 | 51.17 | 0 | 64 | 54.83 |
N548214 | 12.0825 | 1.67 | 0 | 0 | 1.33 | 10.33 |
N548216 | 49.684 | 46.33 | 39.33 | 0 | 44.17 | 38.17 |
N549340 | 1177.85 | 1194.5 | 1373.17 | 0 | 972 | 747 |
N549342 | 617.584 | 401.67 | 490 | 0 | 670.83 | 679.17 |
N353330 | 11.383 | 14.67 | 8.83 | 0 | 11 | 11.17 |
N353615 | 269.549 | 613.33 | 558.33 | 0 | 288.83 | 201.67 |
N356000 | 27.16625 | 0.67 | 0 | 0 | 16 | 25 |
N356030 | 7552.216 | 6504.17 | 6654.17 | 0 | 6766.33 | 7492.83 |
N356035 | 0 | 0 | 0 | 0 | 0 | 0 |
N356040 | 4724.366 | 5244.5 | 5119.5 | 0 | 4748.67 | 4726.5 |
<colgroup><col><col><col span="5"></colgroup><tbody>
</tbody>