very tricky scenario...

[#1]

Brand	Product	code
A	Luk	qwe
A	Shaampoo	erg
A	rin	erl
A	kil	erf
B	Soap	uik
B	Tyn	plo

I need following KPI

Count of codes

Percent share of codes per brand

Percent share of over all codes

Tricky is when i applied filter on brand , Percent share of all codes is becoming brand wise percent  How to controll this.

[HirisH_V7]

Hi ,

I hope i understood your requirement partially or what ,

I think this is what you are expecting.

PFA,

Hope this Helps,

Regards,

Hirish

[settu_periasamy]

Hi,

May be like attached?

[effinty2112]

Hi Uday,

                    The expression in this table will disregard user selections of Brand

Brand	Count(DISTINCT code)/count({$<Brand=>}TOTAL DISTINCT code)
	100.00%
A	66.67%
B	33.33%

If we select Brand 'A' the table returns

Brand	Count(DISTINCT code)/count({$<Brand=>}TOTAL DISTINCT code)
	66.67%
A	66.67%