How to disconnect data

[sabinawong04]

I got a two tables which connected to another main table, and i would like to create one chart which need to disconnect these two tables with the main table, but after I create that, these two tables need to connect to the main table when I create another chart. How can I do?

[bbmmouha]

in the first chart use sum({1} sales) to detach it  from any selection