Unique cities based on several criterias

Please provide solution for the above table.

Count of Unique city names should populate in the blue sections based on the following criteria

1)As on Date (which is dependent on the Operational from column)
2)company name
3)zone
4)Type