Hi Experts,
I have one 30 years weather dataset, include temperature, precipitation.
Then I build a sheet to find out the Max Precipitation for Each month in the 30 years.
Then I want to have tooptip in this sheet so I can check which is the exact date(may have more then 1 dates).
In that tooltip sheet I have the all the dates, I want to filter the sheet with Month(dates) and Precipitation bigger then Max Precipitation of that Month.
I don't know how to achieve filter the tooltip with Precipitation bigger then Max Precipitation of that Month.
Any suggestion to try?
Thanks.
3 answers
Hi Jim,
I have achieved the result by put all the dates for each in the tooltip sheet.
They I can filter it with Month(Dates).
It works.
Thanks