List 的计算列如何汇总

forum2621 2010-02-02 06:05:01

如题，创建一个list，创建几个栏，其中一栏是计算值(基于其他栏的计算)，此列怎么汇总？在视图设计页面没看到此栏的信息...

...全文

217 8 打赏收藏举报

写回复

8 条回复

切换为时间正序

当前发帖距今超过3年，不再开放新的回复

发表回复

forum2621 2010-02-10

打赏
举报

引用 7 楼 time_is_life 的回复:

3.用JQuery:
http://www.endusersharepoint.com/2009/01/06/jquery-for-everyone-total-calculated-columns/

效果不错，结贴

time_is_life 2010-02-02

打赏
举报

3.用JQuery:
http://www.endusersharepoint.com/2009/01/06/jquery-for-everyone-total-calculated-columns/

time_is_life 2010-02-02

打赏
举报

有两种方法：
1.用工作流：





Let’s say we have a field called PROFIT that is a calculated field set to subtrack the expense field from the revenue field in our list. ([Revenue]-[Expense])



   1. Create a regular number field (or currency field) called TOTAL PROFIT (or any other name you want) in that list.

   2. Using SharePoint Designer create a workflow for your list that runs when list items are created and when list items are changed.

   3. The workflow will have only one step name it something like set TOTAL PROFIT.Leave the condition field blank.

   4. In the action section choose “Set field in the current item”.

   5. Click on the word “field” and choose TOTAL PROFIT (the name of our column).

   6. Click on the word “value” and click on the “fx” button to do a lookup.

   7. Choose “Current Item” for the source.

   8. Choose “PROFIT” for the field. (This is the calculated column.)

   9. Click Finish.

2. 用SharePoint Desinger:

http://community.bamboosolutions.com/blogs/bambooteamblog/archive/2009/04/24/how-to-total-calculated-columns-in-a-sharepoint-list.aspx

forum2621 2010-02-02