Hi Guys
Currently trying to have Australian Postcode Boundary data (House sales) aggregated down to SA1 boundary's (about 100 household). The SA1 have number of houses, so house_sales_cnt for Postcode should be proportion of SA1 House_Cnt's
I don't believe ArcGis "Spatial Join" can re-calculate on the fly based on attributes (eg House_cnts or area). Is there any other ArcGis tools that can?