I have a PIVOT TABLE which is set to autominimise when a STRAIGHT TABLE is selected. The pivot table only shows summary information, so it is quite small on the screen, whereas the STRAIGHT TABLE is alot bigger. As the PIVOT TABLE is so small and reveals a large empty space in the application, i have placed a pie chart next to it displaying a percentage of sales for the selected criteria.
What i want to do if possible, is to autominimise the pie chart when the STRAIGHT TABLE is selected. Meaning that when the end user selects the STRAIGHT TABLE, the PIVOT TABLE and PIE CHART would autominimise, and when the end user selects the PIVOT TABLE, the PIE CHART would also re-appear.
Can this be done??
I would probably make it easier, if the space allows (and it sounds like it does).
Make the layer value Bottom for the pie chart, and Top for the straight table (the pivot table can be anything), this means that when the straight table is shown, it will always be on top of the pie chart.
This method works for a small number of objects, because, you should bear in mind that both charts will then be calculating upon selection changes.
Another way to do it would be through buttons to maximise/minimise, using actions to activate objects.
you could create a button 'Toggle View' which changes the value of a variable "varShow" between 0 and 1. (varShow = 1- varShow ... toogles between 0 and 1)
In the charts/ tables you enable the show condition. (varShow=0 for the Pivot and the pie; varShow=1 for the straight table).
That way you can handle the show/ hide of a number of objects.
Afaik hidden objects do not calculate, i.e. you do not risk bad performance due to invisible charts.
The drawback is, that you need the button, i.e. you cannot use the autominize feature.