Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Usually a table shows 'it all' before any selections has been made - is there a way to have the opposite? Starting with a blank table, I make a selection somewhere else, the table gives me exclusive entries related to the selection. And so on - for each new selection.
Hi,
I hope that is not possible since unless and untill if there is no dimension in the table it will not display values .but there i sanother way like
u Can add the dimensiona in the table and mean while Create the Listboxes for those Dimension addded in the table ,Now on the selection of the values in the Listbox the chart can be visible else it will be invisible. i.e if u select any value in the listboc then only the Table BOx appears.
Here u need to put a condition in the Sheet Properties Conditional Show in Layout Tab
In this way we can achieve a part of Your Requirement but not complete one.
Regards
Ajay
There could be 2 ways to solve your problem:
1. Show/Hide the table chart based on the current selection count (you can use GetFieldSelections to find that)
2. Have a calculated dimension based on GetFieldSelections, which would return a NULL when no selections are made, and 'Suppress when Value is Null' option selected for the dimension