Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have a list box that I am wanting to display as a selection menu at the top of the screen and there are some values within this field that have no data. I want to remove all the values that have no data from the list box but allow for them to appear if they ever get data added to them (so I can't hard code the options in).
I have ticked the 'Hide Excluded' option but now it just looks horrible and I ideally want to only see the proper options and no grey..
Is this possible?
Thanks
When you say don't have data... what exactly do you mean? Can you elaborate on this? May be Try this
Aggr(FieldName, FieldName)
Sorry I mean there are some category numbers that are null so won't be able to be clicked on anyway like this:
I just want to get rid of the null ones
They are null because they have been excluded based on certain selections, right? What selections have you made here?
There is no descriptions that have been generated for those categories at all within the dashboard so there is just literally nothing to select. I have flat files loaded in that list them as possibly categories in the future