宏以更改多个限幅器值 [英] macro to change multiple slicer values

问题描述

经过一番搜寻，我很茫然. 我有两个由两个不同的数据源/缓存驱动的数据透视表.来源1是包含部门总费用金额的表，来源2具有相同部门的总拒绝金额.我将从这两个数据中提取数据到数据透视表中，以便可以操纵部门(除其他事项外)来计算百分比.

I am at a loss after some searching. I have two pivot tables driven from two different data source/caches. source 1 is a table with departments' total charged amounts, source 2 has the same departments with the total denied dollar amounts. I am pulling the data from both of these into pivot tables so that I can manipulate the department (among other things) to calculate percentages.

我最初的想法是为每个表设置一个部门"切片器，并为一个切片器分配一个宏，以更改第二个切片器，以便两个数据透视表都可以过滤部门.我也在考虑可能使用一个切片器，并为其分配一个宏以仅过滤第二个枢轴上的部门.

My original thought was to set a "Department" slicer for each table, and have a macro assigned to one of the slicers to change the second one so that both pivot tables filter the department. I was also thinking of possibly using one slicer, and assigning it a macro to simply filter the department on the second pivot.

除了切片器之一以外，这两个表都将被隐藏，并将每个表中的计算数据拉到表的顶部，以便于查看.

both of these tables will be hidden with the exception of one of the slicers and will have the calculated data from each table pulled to the top of the sheet for easy viewing.

工作表/数据源均来自具有完全不同的数据的单独报告&标头.

both sheets/data sources are derived from separate reports with completely different data & headers.

在此先感谢您的帮助.

推荐答案

我终于在 contextures上发现了一些有用的东西

它完全按照我想要的方式工作，我只需将连接到其他4个数据透视表的切片器链接到一个与我的主"切片器/表不同的单独的缓存，然后隐藏链接的切片器即可.当我从主切片器中选择和选项时，它会更新隐藏的切片器，从而过滤所有其他数据透视表.

It works exactly how I want it to, I simply linked the slicer connected to 4 other pivot tables with a separate cache than my "main" slicer/table and hid the linked slicer. When I select and option from the main slicer, it updates the hidden slicer thus filtering all the other pivot tables.

这篇关于宏以更改多个限幅器值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！