Multiple Pivot Charts With Linked Filter

Mcook13

New Member
Joined
May 14, 2019
Messages
26
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.

MaterialAverage1-Jan1-Feb1-Mar1-Apr1-May
N548210128.261110121.67093.67111.67
N54821249.28438.6751.1706454.83
N54821412.08251.67001.3310.33
N54821649.68446.3339.33044.1738.17
N5493401177.851194.51373.170972747
N549342617.584401.674900670.83679.17
N35333011.38314.678.8301111.17
N353615269.549613.33558.330288.83201.67
N35600027.166250.67001625
N3560307552.2166504.176654.1706766.337492.83
N356035000000
N3560404724.3665244.55119.504748.674726.5

<colgroup><col><col><col span="5"></colgroup><tbody>
</tbody>
 

Forum statistics

Threads
1,086,204
Messages
5,388,395
Members
402,115
Latest member
ypompoms

Some videos you may like

This Week's Hot Topics

Top