Best way to make tables populate only when all selections are made?

[stevelord]

Hi Community, does anyone have an ideal approach to making tables hold off on populating until the user indicates they are done making selections?

Presently, I have calculation conditions set for many so they wait until a user picks at least 1 season or other important value, and some tabs rigged with triggers to make the default selections on activate...

As I finish writing this, my brain is telling me to makeup a field called Done with value Done.  Then put a Done listbox on every sheet, and make all of the desired table objects only populate when a value is selected in the Done field...  I will try that actually, but will be back here in case anyone has anything tried and true to share.  Thanks in advance!

[#2]

the easiest way to do that is to use a condition on the object and you can then make a custom message to let the user know they need to make a selection before any data will show

for example  a calculation conditon on the object - 'GetSelectedCount(Customer) = 1 ' this will only populate when at least one selction is made from the Customer dimension.  You can use 'Or' in the condition to allow the table to populate based on the determined dimension selection

You can cusomize your message to display by going to the object - General tab, error message button at the bottom, and click on 'calculation condition not fulfilled'.  In the bottom window type in your message and click OK