OLAP pivot table filtered by a cell value

F

fri3nd5

New Member
Joined
Apr 5, 2017
Messages
2
Hi Guys!
Please, i need your help ...
I need a code to filter an OLAP Pivot Table based on a value from a cell from another worksheet.

On sheet1 cell c6 i insert the name of the city. On sheet2 i have an OLAP Pivot Table which have a filter "city". I would like to have a code which automatically filter the pivot table based on the name of the city i insert in cell c6 from sheet1.

Can anybody help?!
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
You must log in or register to reply here.

Similar threads

Guinaba
  • Question Question
OLAP Pivot Table and Cube Fuctions
Replies
2
Views
236
Guinaba
Guinaba
H
  • Question Question
VBA code to open an excel workbook, Refresh the query (PQ), once it has finished running, save and close the workbook
Replies
2
Views
848
hananak
H
T
  • Question Question
Clear FIlters of Pivot Table after Cell Value Changes
Replies
4
Views
407
Alex Blakenburg
A
F
  • Question Question
Showing details of Pivot table from Grand total, including Row filtering
Replies
0
Views
65
Francois2France
F
W
  • Question Question
Macro/VBA code code for creating new excel file for each pivot table from a column filter
Replies
1
Views
357
Anthony47
A

Forum statistics

Threads
1,223,230
Messages
6,170,883
Members
452,364
Latest member
springate

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