UC知道关于数据透视表的问题，急！！！答的好再加100分
来源：百度知道 编辑：UC知道 时间：2024/05/14 20:43:30
题目是这样子的。。
Leave an empty column after the Number of People column and then add a new heading of Percent of State Totals. Under this heading, create one formula that works for all data rows in this column. The formula should calcuate the ratio of the Number of People in the row to the Total Number of People in the pivot table for the same State as listed in the row.
The formula should display the ratio as a percentage with two decimal places WHEN the Age Range in the row matches that at the top of the pivot table; otherwise, it should display the text Wrong Age Range.
越快越好，分越多，尽量写详细点
我是说如何解决这道题。。不是说如何翻译。。呵呵，不过还是谢谢了
Leave an empty column after the Number of People column and then add a new heading of Percent of State Totals. Under this heading, create one formula that works for all data rows in this column. The formula should calcuate the ratio of the Number of People in the row to the Total Number of People in the pivot table for the same State as listed in the row.
The formula should display the ratio as a percentage with two decimal places WHEN the Age Range in the row matches that at the top of the pivot table; otherwise, it should display the text Wrong Age Range.
越快越好，分越多，尽量写详细点
我是说如何解决这道题。。不是说如何翻译。。呵呵，不过还是谢谢了
在G2单元格内输入或复制以下公式：
=IF(F2=0,"Wrong Age Range",TEXT(F2/SUMIF(A:A,A2,F:F),"0.00%"))
下拉复制G2单元格即可。
下拉复制的方法：
G2单元格输入公式后->回车，然后选中G2单元格-》鼠标指向G2单元格的右下角-》当鼠标变成“黑十字”形状时-》按住鼠标左键向下拖拽。
g2单元格输入 =f2/count(A:A,a2)
选中G2单元格，双击G2单元格右下角的小黑点，完成公式的填充
设置G列的数据格式为百分数。
离开后的空白栏中的人的数目列，然后添加一个新的标题占国家总数。本项下，创建一个公式，适用于所有的数据列在此列。该公式应calcuate的比例的人的数目在连续的人口总数中的数据透视表的同一国家中所列行。
该公式应显示的百分比率的小数点后两位当年龄范围的连续比赛，在上方的数据透视表，否则，它应该显示的文字错误的年龄范围。