水晶报表中有条件总和的公式
问题描述：
先生，
在我的Crystal Report中，我已经完成了以下报告
sir,
In my Crystal Report i have done following report
AMOUNT TAX% TAXAMOUNT
--------------------------------------
1000 2 20
2000 5 100
3000 5 150
4000 2 80
现在从上面的报告中，我想显示AMOUNT和TAXAMOUNT的总和，如下所示，按税种％
分组
now from above report i want to show sum of AMOUNT AND TAXAMOUNT as follows that is group by TAX %
TAX % ON AMOUNT TAX AMOUNT
--------------------------------------
2 5000 100
5 5000 250
请帮助我
谢谢您，
Please help me
Thank you,
答
select Tax%, SUM(AMOUNT), SUM(TAXAMOUNT)
from Accounts
group by Tax%
order by Tax%