screen capture of empty pivot table with regions ready to receive dropped row fields, column fields, and data items
空pivot表的屏幕截图,其中有一些区域用来接收拖放的行字段、列字段和数据条目
the technique of the data query in the first page of medical records based on pivot table is low cost and high efficiency technique. it is worthy of spreading.
为了更加快捷、灵活、方便查询病案首页数据,高效地开发病案信息资源,本文对「数据透视表」这一信息处理技术进行了针对性的探讨。
for example, rene can view an it maintenance pivot table and then generate a graph as shown in figure 7.
例如,rene可以查看一个itmaintenance数据透视表,生成一个如图7所示的柱形图
create a new pivot table or chart.
创建新的数据透视表或图表。
figure 2 shows an empty pivot table with the pivottable toolbar floating over the window.
图2展示了一个空的pivot表,窗口上浮动着pivottable工具栏。
in figure 6, the pivot table shows each of the accounts, their size totals, and a grand total at the end.
在 图6 中,pivot表展示了每一个account、它们的大小total,最后还有一个grandtotal。
but the nice thing is that you can create the pivot table in excel, save it as xml, and then use that xml code as a template for your own code.
但是好在可以在excel 中创建pivot表,保存为xml,然后使用该xml代码作为您自己代码的模板。
that pivot table tab has all the dynamic capabilities available, just as if you created it in excel.
此pivot表标签具有所有可用的动态功能,就像是您在excel 中创建的一样。
screen capture of pivot table with data as originally formatted in the file
pivot表的屏幕截图,带有文件中初始格式化的数据
to build a pivot table in excel, you select the data columns to be used in the pivot table, then select the pivottable report menu item from the data menu.
要在excel 中构建pivot表,您需要选择将用在pivot表中的数据列,然后从data菜单选择pivottablereport菜单项。
a pivot table can be generated for a project or a portfolio of projects.
数据透视图表是为一个项目或者项目组合制定的。
a pivot table is a table in which the user can dynamically choose which fields are used as the row headings, the column headings, and what is shown as the data in each cell.
pivot表是这样一种数据表,用户可以动态地选择其中的哪些字段被用作行标题、列标题,以及被显示为每个单元格中的数据。
when you save an excel spreadsheet in xml format, all the data and the pivot table parameters are stored in the xml file.
以xml格式保存excel电子表格时,所有数据和pivot表参数都存储在xml文件中。
to create the pivot table tab, the export_pivot function first creates a worksheet and then adds the table of data, the worksheet options, and the pivottable xml.
为了创建pivot表标签,export_pivot函数首先创建一个工作表,然后添加数据表、工作表选项和pivottablexml。
the pivot table spreadsheet is a little more complex, but the idea is roughly the same.
pivot表电子表格稍微复杂一点,但是思路基本上是相同的。