Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a table that will only show two dimensions (title and description), no measures. How can I filter the table to only show a certain type of records? (e.g. I have a table of player positions in various sports and a description of the position. I want to filter out rugby and baseball and only show football)
Thanks in advance!
Thanks Karthik! It's actually even easier than that, the answer was staring me in the face
In the field to enter the dimensions, use an if statement:
=IF( [FieldName] = 'DesiredFieldValue', [FieldName] )
Hi Katherine,
You can create a list box and use the option under appearance, check in
Always One Selected Value*
[Define your values that to be listed in the TAB]
Disable the - Show titles
Reduce the size of the table to it's minimum and try to hide it in a corner.
Then add in your dimensions in your straight table. This will be a temporarily solution until conditions is enabled.
Hope this helps
Many Thanks
Karthik
Thanks Karthik! It's actually even easier than that, the answer was staring me in the face
In the field to enter the dimensions, use an if statement:
=IF( [FieldName] = 'DesiredFieldValue', [FieldName] )
Hi Katherine,
Can you post a screenshot of your table?
Did you try to use a set analysis dimension in which you show only your selection from the list box?
Regards,
MB