I have a table with thousands of rows of data regarding sold properties spanning over the following columns: Ref. number (starting from 1 and ending with the last entry) Agent Postcode Price Date
I am required to display the top 5 agents by sales of properties in the price range £500,000 - £1,000,000 in NW3 in the period 1st April 2018 – 31st March 2019.
How should I go about this? My pivot table does not help me with filtering the price range, unless I put that as a row instead of a filter. The date would also require that and together they are a mess. Not to mention that it displays them all rather than applying that only as a filter.