Hi All -
Having a tough time finding a solution for this one. I have 8 tables loaded into the PP data model. From each of those tables, I have created a pivot in Excel. I would like to insert a slicer that would effect all 8 pivots if, for example, the user selected the field 'State' on the slicer. I thought i would be able to accomplish this in Report Connections, but it doesn't seem to change the formulas that are pointing to those pivots. Thanks
Chris
Having a tough time finding a solution for this one. I have 8 tables loaded into the PP data model. From each of those tables, I have created a pivot in Excel. I would like to insert a slicer that would effect all 8 pivots if, for example, the user selected the field 'State' on the slicer. I thought i would be able to accomplish this in Report Connections, but it doesn't seem to change the formulas that are pointing to those pivots. Thanks
Chris