Condition to show the view

[Sona]

Hi, can you, please advise me how to create the expression to show the view only if the column LocationTypeID = 15 in the table Opportunities? Thank you

[1minManager]

Does LocationTypeID = 15 relate to any one row or all rows in the Opportunities table? Or do you want a table which just shows records where LocationTypeID = 15?

[Sona]

Hello Simon, thank you for your reaction. I need a table which shows only those records where LocationTypeId = 15

[1minManager]

So you need to crete a Slice (Date → Slices) with the source table as Opportunities and the Row Filter Condition as [LocationTypeId]=15. Name it something like Opportunities[LocationTypeId]=15

The go into UX and create a new Table view and choose the above slice in For This Data

hope this helps

[Sona]

Thank you very much Simon, this helps.

[Steve]

For reference:

help.appsheet.com

Slices: The Essentials

Display only certain rows or columns of your table with slices.

[Sona]

This helps Steve, thank you!