I think it would be better to have the Container with the 2 Summaerization tables and a Details Table thats only shown when you click a button
create a variable called vShowHide = 1
create a text object and add an action > external > set variable vShowHide = IF($(vShowHide) = 1,0,1)
On the Layout tab of the Detailed Chart add IF($(vShowHide) = 1,0,1) and that should do it.
Visit my Youtube Channel Rustyfishbones, and you will find some videos that will help you do this
Do you use the same type of object to show each summarization and their detail?
If yes, you could hide the dimmentions and expressions that are in detail and not in de summarization tables.
Also, you could try with no using a container. Make two non-linked tables with the following fields and values:
Table 1, field "TableName", values "Expense" and "Revenue"
Table 2, field "TableType", values "Summarization" and "Detail"
Now, the show conditions of each table will be:
Revenue Summarization. : TableName='Revenue" and TableType="Summarization"
Revenue Detail. : TableName='Revenue" and TableType="Detail"
Expense Summarization. : TableName='Expense " and TableType="Summarization"
Expense Detail. : TableName='Expense " and TableType="Detail"
You could put the list box with "TableName" field as the container likes, and create a button to select "Detail" or "Summarization" with the following action:
Make a Selection
Value: If (TableType='Summarization', 'Detail','Summarization')
Dont forget to mark both fields as "Always one selected value"
(sorry for my bad english)
If you are show/hiding charts is there a need to have these in containers at all ?
There is a good blog on buttons with some working examples: