数据透视表切片器 - 限制选择 [英] Pivot Table Slicers - Limit selection

问题描述

我有一个数据透视表，并希望将切片器选择限制为一个或两个项目。切片器有一个包含100多个项目的字段。

I have a pivot table and would like to limit the slicer selection to one or two items. The slicer has one field with 100+ items.

ie /"Car Number"是字段

ie/ "Car Number" is the field

在Excel 2016中是否有针对此的VBA代码？ 

Is there a VBA code for this in Excel 2016? 

提前感谢您。

推荐答案

嗨蔡，

感谢您访问我们的论坛。

Thanks for visiting our forum.

然后，我们主要关注有关Excel客户端的一般问题。由于您的查询与VBA代码有关，因此我将您的主题移至以下专用于Excel的MSDN论坛：

Then here we mainly focus on general issues about Excel client. Since your query is related to VBA code, I'll move your thread to the following dedicated MSDN forum for Excel:

https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

我们建议适当发布的原因是您将获得最合格的受访者群体，而定期阅读论坛的其他合作伙伴可以分享他们的知识或从您与我们的互动中学习。感谢您的理解。

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

最好的问候，

Yuki Sun

Best regards,
Yuki Sun

< a href ="https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev">

这篇关于数据透视表切片器 - 限制选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！