ClearCollect(Devices,
{DeviceName: "DEVICE01", User: "John" },
{DeviceName: "DEVICE02", User: "Paul" },
{DeviceName: "DEVICE03", User: "Melinda" },
{DeviceName: "DEVICE04", User: "Susan" },
{DeviceName: "DEVICE05", User: "Tom" },
{DeviceName: "DEVICE06", User: "Emily" },
{DeviceName: "DEVICE07", User: "Janet" },
{DeviceName: "DEVICE08", User: "Bill" },
{DeviceName: "DEVICE09", User: "Emily" },
{DeviceName: "DEVICE10", User: "Anthony" },
{DeviceName: "DEVICE11", User: "Emma" },
{DeviceName: "DEVICE12", User: "Bill" },
{DeviceName: "DEVICE13", User: "Stephen" },
{DeviceName: "DEVICE14", User: "Emma" });
ClearCollect(Users,
{Country: "USA", User: "John" },
{Country: "USA", User: "Paul" },
{Country: "USA", User: "Melinda" },
{Country: "UK", User: "Susan" },
{Country: "USA", User: "Tom" },
{Country: "UK", User: "Emily" },
{Country: "CANADA", User: "Janet" },
{Country: "CANADA", User: "Bill" },
{Country: "MEXICO", User: "Anthony" },
{Country: "USA", User: "Emma" },
{Country: "MEXICO", User: "Peter" },
{Country: "UK", User: "Stephen" });
ClearCollect(COL,ShowColumns(AddColumns(GroupBy(AddColumns(RenameColumns(Devices,"User","User2"),"Country",LookUp(Users,User=User2,Country)),"Country","DeviceName"),"Total",CountRows(DeviceName)),"Country","Total"))