为一个月的部门生成报告 [英] Generate report for a month department wise
问题描述
大家好
这是图书馆的重复表格
8/2018                                                              二千〇一十八分之八
文献1      &NBSP ;                        &NBSP ;                        
文献2
部1  (新形式库)           &NBSP ;             部门2
A 8.00                        &NBSP ;                        &NBSP ;         
D 3.00
B        4.00           &NBSP ;                        &NBSP ;                      
E         4.00
C        5.00                        &NBSP ;                        &NBSP ;          F          5.00  
总计 17.00                        &NBSP ;                     
总计 12.00
报告应当在您发布月份时所有记录应如下所示
8/2018
部1                        &NBSP ;                        &NBSP ;    
A 8.00                        &NBSP ;                        &NBSP ;         
B        4.00                                                             
c 5.00                        &NBSP ;                        &NBSP ;        
部2
d    &NBSP ;   3.00
E         4.00
F           5.00  
等...................部门可能是10。
不确定如何您保存了数据(库数据结构),同时根据报告样本检查了excel pivot。
以下是一些演示供您参考。
https://www.tonyishere.co.uk/how-to-show-sharepoint-list-data-in-a-pivot-table/
希望这些会有所帮助,如果你需要帮助,你最好提供有关你的图书馆定义的详细信息(截图会更好)。
< span style ="font-size:10.0pt;行高:105%; FONT-FAMILY:"宋体",无衬线;颜色:#2F5597">最好的问候,
利跨度>
Hi All
This is a repeated table of a library
8/2018 8/2018
Document 1 Document 2
Department 1 (new form library) Department 2
A 8.00 D 3.00
B 4.00 E 4.00
c 5.00 F 5.00
Total 17.00 Total 12.00
Report should be when You selet Month All records should come as follows
8/2018
Department 1
A 8.00
B 4.00
c 5.00
Department 2
D 3.00
E 4.00
F 5.00
etc...................Departments might be 10.
Hi,
Not sure about how you saved your data(library data structure), while you would check excel pivot per your report sample.
Here are some demos for your reference.
https://www.tonyishere.co.uk/how-to-show-sharepoint-list-data-in-a-pivot-table/
https://www.c-sharpcorner.com/article/display-pivot-chart-and-table-from-excel-document-in-sharepo/
Hope these would help, if you need furture help, you’d better provide details about your library definition(screenshot would be better).
Best Regards,
Lee
这篇关于为一个月的部门生成报告的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!