Subgroup percentage share or Subgroup total

[CK_WAKE]

Hi There, I want to reproduce the Column C (ACCESSORIES(%)) to a new column Replica of Column C in the below table chart, how can i achieve this.

Please note: Column B is derived using a COUNT DISTINCT FORMULA as shown below.

I tried below example but it is not working because of COUNT DISTINCT.

Sum(Value)/Sum(total <Value> [Month])

Country	Count(DISTINCT(ACCESSORIES))	ACCESSORIES(%)	Replica of Column C
USA	220,196	32.00%
China	241,282	35.00%
Japan	227,249	33.00%
Total	688,727	100%

[TauseefKhan · Accepted solution]

Hello @CK_WAKE,
Check below formulas are correct to calculate the percentage share of distinct accessories:

=Sum(Aggr(Count(DISTINCT ACCESSORIES), Country)) / Sum(TOTAL Aggr(Count(DISTINCT ACCESSORIES), Country))

** When applicable please mark the correct/appropriate replies as "solution". Please LIKE threads if the provided solution is helpful to. **

[CK_WAKE]

Thanks for the help it worked