select ta.*,sku/a2 as SKU占比,销售数量/b2 as 数量占比,含税销售金额/c2 as 金额占比 from [Sheet1$] as ta,(select 子类,sum(SKU) as a2,sum(销售数量) as b2,sum(含税销售金额) as c2 from [Sheet1$] group by 子类) as tb where ta.子类=tb.子类
select ta.*,sku/a2 as SKU占比,销售数量/b2 as 数量占比,含税销售金额/c2 as 金额占比 from [Sheet1$] as ta,(select 子类,sum(SKU) as a2,sum(销售数量) as b2,sum(含税销售金额) as c2 from [Sheet1$] group by 子类) as tb where ta.子类=tb.子类