you can duplicate the country field one for avg table, and one for max table as shown below.
I also attached the workbook for your reference.
Hope this helps
workbook_sample_v10.2.twbx 417.5 KB
Thanks a ton! It never clicked to my mind that I can duplicate the variable and apply filter accordingly!
No worries, glad it helps