Thanks for the response Massimo!
My charts are already in a container. I have 5 charts in one container: Market Share by Year, Market Share by Quarter, 12 Month Rolling Share, 6 Month Rolling Share, and 3 Month Rolling Share.
I need it so that when the user is viewing a chart in the container, "Market Share by Year" for example, they can switch it to a pivot table and see the underlying data (Market Share and Sales). It would be preferable not to manage more charts and have the pivot table as a part of the chart they are currently viewing.
As a last resort I have considering creating a second container that has pivot table versions of the 5 respective line charts mentioned above. Although, I don't want to risk the user viewing the line chart "Market Share by Quarter," while forgetting to switch to the corresponding pivot table in the second container and misinterpreting the data.
EDIT -- One possible alternative solution is to have two containers, but have the containers linked. Where when you select Chart 1 in Container 1, it also selects Pivot 1 in Container 2. Is that possible?
Container 1 (Line Chart): Market Share by Year (Chart 1), Market Share by Quarter (Chart 2), 12 Month Rolling Share (Chart 3), 6 Month Rolling Share (Chart 4), and 3 Month Rolling Share (Chart 5).
Container 2 (Pivot Table): Market Share by Year (Pivot 1), Market Share by Quarter (Pivot 2), 12 Month Rolling Share (Pivot 3), 6 Month Rolling Share (Pivot 4), and 3 Month Rolling Share (Pivot 5).
You could put chart1/pivot1 in a container and nest that in the main container. And so on for the rest of the pairs.
Unfortunately, I don't know of any indicator that you can test to find out which chart type you've fast changed to. That would be a useful feature because then you could disable/enable Dimensions and Expressions.