Agg with Set analysis

[swatitomar]

Hi Team , 

I'm trying create the share% on the basis of 2 Dimension in Pivot Table but not getting correct result as needed .

2 Group are there , now i want the share % individually on group basis.

	Count	Share%
Group 1	2705452	100%
Only Customer	2475529	91.5%
Only Partner	142333	5.3%
Only Vendor	87590	3.2%
Group 2	154821	100%
Customer & Partner	112842	72.9%
Vendor & Partner	1795	1.2%
Customer & Vendor	40184	26%

[Kushal_Chawda · Accepted solution]

assuming you have count expression as  count(ID) 

you can try below expression for Share%

=count(ID)/count(total<Group>ID)

[swatitomar]

Thank you!