PowerPivot:Allocate Amount based on No Of items

[jaggy99]

Hi All,

I'm using excel 2010 with power pivot and like to create a new calculated column to allocate an amount to set of groups based on the no of distinct products in the group. I have uploaded the sample data here in the link below and if you can help me how I can get the same results in the Amount Allocated no of products using power pivot





https://app.box.com/s/f0xy5vluskf8g7bn5wa38edqstwo3ghz


Thanks

 

[scottsen]

Distinct Product Code:=DISTINCTCOUNT(Table2[Product Code])
Distinct Product Code ALL Groups:=CALCULATE([Distinct Product Code], ALL(Table2[Group]))
% of Distinct Products:=DIVIDE([Distinct Product Code], [Distinct Product Code ALL Groups])