如何计算SQL Server中分组结果集的聚合列的百分比

I have a query where I get a result set of transaction totals grouped by a date, a store and a type. Where I'm stuck is: I want to calculate the percentages as well, I would've simply done it in Excel, but due to bad naming conventions, my number of rows per store is inconsistent and my result set is pretty big.I have a query where I get a result set of tran