I have a pivot table in Google sheet and would like to filter the top 1 item in the table. What custom formula is needed to achieve this in the filters?

Sheet: https://docs.google.com/spreadsheets/d/1ZQxtbQ47kn8uW9PwpZkC9fklXGDxJXsc1LznoLtEQLg/edit?pli=1#gid=1674700009

Pivot table in Convert tab



Just want to show the latest value like this


  • Your screenshots include an extra (date) column that does not appear in your spreadsheet. Also, your definition of the Top 1 value seems to be based on the latest date. Would you please edit your question to explain/include the data field. Would you please also define what you understand by "the top 1 item in the table". – Tedinoz Aug 19 '20 at 2:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy