Calculate Distinct Count for specific Attribute

Hi All,

I am trying to calculate distinct count for specific Attributes while showing non related column. For example

I wanted to show distinct count for Article of "Country, Region, Store" while showing "Country, Region, Store and Banner" column.

Raw Data

Expected Result for (County, Region and Store)

Expected Result for Country, Region, Store and Banner

Anyone have any idea how I can show Distinct Article count for only "Country, Region and Store" while showing "Country, Region, Store and Banner" Column?

Regards,

Kang