VBA to filter one pivot based on another (cell) pivot

V

Vjalvim

New Member
Joined
Apr 23, 2020
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
I have two pivot tables in a file with the same database. I'm trying to filter the second pivot based on information from cell values in a first pivot. Clarifying, when I select cell E6 at first pivot (that is related to [Customer Name] = "Company C" and [Period] = "3", the second pivot will filter the [SalesPersons] and [Sum of Revenue] related to cell E6 (Company C and Period 3).
 

Attachments

  • Example.PNG
    Example.PNG
    29.8 KB · Views: 4

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

ajjava
  • Question
Procedure to find MAX VALUE in a SPECIFIC pivot table value field, in the case of MULTIPLE pivot table value fields
Replies
0
Views
814
ajjava
ajjava
S
  • Question
VBA, OLAP cube pivot : refer to parent of selected filter?
Replies
1
Views
279
srgexcel
S
T
  • Question
Slicer disconnects from pivottable when programatically filtering items in pivot fields
Replies
2
Views
714
Telefonstolpe
T
sanantonio
  • Question
VBA, filtering pivot table based on cell value
Replies
3
Views
465
Alex Blakenburg
A
S
  • Solved
VBA for Pivot to filter on cell value not working
2
Replies
18
Views
869
Alex Blakenburg
A

Forum statistics

Threads
1,214,584
Messages
6,120,384
Members
448,956
Latest member
JPav

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top