title: How to filter and get data from Pivot table based on dropdown (without vba) - Excel
body: <p>I have covid data and I am creating a dashboard on it. I created a pivot table and I know how can I filter record on the basis of country, both by using 'Filters' section and slicer. <a href="https://i.stack.imgur.com/9gsU7.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9gsU7.jpg" alt="Pivot Table" /></a></p>
  <p>I want to create a dropdown list of countries in dashboard page, and then filter and get data of that particular country from pivot table based on dropdown selection. I can create dropdown of countries using data validation option and taking countries list from original data.</p>
  <p>I dont want to use slicer in my dashboard.</p>
  <p>Kindly let me know how can I link my dropdown list in dashboard to the filter here in pivot table?</p>