过滤SharePoint Online列表中的数据 [英] Filtering Data in a SharePoint Online List

问题描述

如何使用"和"在线过滤SharePoint上的列表中的数据？功能改为或"或"？我的SharePoint页面顶部有9个标题，并希望按照每个标题下的不同条件进行过滤。当我选择多个条件时，SharePoint
会使用"或"来过滤它。并显示比我正在寻找的更多信息。例如，如果我从列标题中选择3个条件，我希望结果仅显示具有所有三个认证的结果。我不希望看到
只有1/3标准的结果。 

How do I filter data in a list on SharePoint online using an "and" function instead or "or"? I have 9 headings at the top of my SharePoint page and want to filter by different criteria under each. When I select multiple criteria, SharePoint filters it using "Or" and shows more info than what I am looking for. For example, If I select 3 criteria from a column heading, I want the results to only show results that have all three of the certifications. I don't want to see any results that have just 1/3 of the criteria. 

推荐答案

这是设计共享点使用功能"或"在列下选择不同条件时。

This is by design that sharepoint use function "or" when choosing different criteria under a column.

作为解决方法，您可以通过编辑视图来应用过滤器，如下所示：

As a workaround, you could apply the filter by editing the view, like this:

最好的问候，

Michael Han

Michael Han

这篇关于过滤SharePoint Online列表中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！