对于填报的数据统计时需要月度合计，而后月度会和同期月度数据比较，每月也会计算年度累计数据，然后和同期年度累计数据比较，根据本月与上月的数据计算环比的增长及增长率，下面通过一个表间公式来实现，可以简化原来需要多个公式进行行列匹配的写法以及支持应用与WEBAPP。

下面作为示例说明可以先行在SQL查询分析器执行

创建表并插入数据

1. CREATE TABLE [dbo].[REPORT](
   
2.         [NAME] [varchar](50) NULL,
   
3.         [DATE] [datetime] NULL,
   
4.         [AMOUNT] [numeric](18, 0) NULL
   
5. ) ON [PRIMARY]
   
6. GO
   
7. 
   
8. 
   
9. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-01-01',1)
   
10. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-02-01',2)
    
11. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-03-01',3)
    
12. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-04-01',4)
    
13. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-05-01',5)
    
14. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-06-01',6)
    
15. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-07-01',7)
    
16. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-08-01',8)
    
17. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-09-01',9)
    
18. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-10-01',10)
    
19. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-11-01',11)
    
20. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-12-01',12)
    
21. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-01-01',13)
    
22. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-02-01',14)
    
23. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-03-01',15)
    
24. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-04-01',16)
    
25. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-05-01',17)
    
26. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-06-01',18)
    
27. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-07-01',19)
    
28. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-08-01',20)
    
29. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-09-01',21)
    
30. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-10-01',22)
    
31. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-11-01',23)
    
32. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-12-01',24)
    
33. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-01-02',1)
    
34. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-02-02',2)
    
35. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-03-02',3)
    
36. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-04-02',4)
    
37. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-05-02',5)
    
38. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-06-02',6)
    
39. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-07-02',7)
    
40. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-08-02',8)
    
41. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-09-02',9)
    
42. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-10-02',10)
    
43. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-11-02',11)
    
44. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2018-12-02',12)
    
45. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-01-02',13)
    
46. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-02-02',14)
    
47. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-03-02',15)
    
48. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-04-02',16)
    
49. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-05-02',17)
    
50. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-06-02',18)
    
51. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-07-02',19)
    
52. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-08-02',20)
    
53. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-09-02',21)
    
54. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-10-02',22)
    
55. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-11-02',23)
    
56. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('E','2019-12-02',24)
    
57. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-01-01',1)
    
58. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-02-01',2)
    
59. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-03-01',3)
    
60. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-04-01',4)
    
61. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-05-01',5)
    
62. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-06-01',6)
    
63. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-07-01',7)
    
64. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-08-01',8)
    
65. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-09-01',9)
    
66. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-10-01',10)
    
67. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-11-01',11)
    
68. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-12-01',12)
    
69. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-01-01',13)
    
70. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-02-01',14)
    
71. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-03-01',15)
    
72. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-04-01',16)
    
73. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-05-01',17)
    
74. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-06-01',18)
    
75. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-07-01',19)
    
76. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-08-01',20)
    
77. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-09-01',21)
    
78. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-10-01',22)
    
79. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-11-01',23)
    
80. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-12-01',24)
    
81. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-01-02',1)
    
82. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-02-02',2)
    
83. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-03-02',3)
    
84. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-04-02',4)
    
85. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-05-02',5)
    
86. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-06-02',6)
    
87. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-07-02',7)
    
88. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-08-02',8)
    
89. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-09-02',9)
    
90. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-10-02',10)
    
91. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-11-02',11)
    
92. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2018-12-02',12)
    
93. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-01-02',13)
    
94. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-02-02',14)
    
95. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-03-02',15)
    
96. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-04-02',16)
    
97. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-05-02',17)
    
98. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-06-02',18)
    
99. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-07-02',19)
    
100. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-08-02',20)
     
101. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-09-02',21)
     
102. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-10-02',22)
     
103. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-11-02',23)
     
104. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('D','2019-12-02',24)
     
105. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-01-01',1)
     
106. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-02-01',2)
     
107. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-03-01',3)
     
108. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-04-01',4)
     
109. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-05-01',5)
     
110. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-06-01',6)
     
111. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-07-01',7)
     
112. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-08-01',8)
     
113. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-09-01',9)
     
114. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-10-01',10)
     
115. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-11-01',11)
     
116. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-12-01',12)
     
117. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-01-01',13)
     
118. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-02-01',14)
     
119. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-03-01',15)
     
120. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-04-01',16)
     
121. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-05-01',17)
     
122. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-06-01',18)
     
123. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-07-01',19)
     
124. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-08-01',20)
     
125. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-09-01',21)
     
126. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-10-01',22)
     
127. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-11-01',23)
     
128. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-12-01',24)
     
129. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-01-02',1)
     
130. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-02-02',2)
     
131. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-03-02',3)
     
132. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-04-02',4)
     
133. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-05-02',5)
     
134. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-06-02',6)
     
135. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-07-02',7)
     
136. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-08-02',8)
     
137. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-09-02',9)
     
138. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-10-02',10)
     
139. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-11-02',11)
     
140. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2018-12-02',12)
     
141. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-01-02',13)
     
142. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-02-02',14)
     
143. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-03-02',15)
     
144. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-04-02',16)
     
145. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-05-02',17)
     
146. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-06-02',18)
     
147. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-07-02',19)
     
148. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-08-02',20)
     
149. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-09-02',21)
     
150. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-10-02',22)
     
151. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-11-02',23)
     
152. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('C','2019-12-02',24)
     
153. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-01-01',1)
     
154. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-02-01',2)
     
155. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-03-01',3)
     
156. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-04-01',4)
     
157. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-05-01',5)
     
158. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-06-01',6)
     
159. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-07-01',7)
     
160. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-08-01',8)
     
161. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-09-01',9)
     
162. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-10-01',10)
     
163. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-11-01',11)
     
164. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-12-01',12)
     
165. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-01-01',13)
     
166. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-02-01',14)
     
167. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-03-01',15)
     
168. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-04-01',16)
     
169. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-05-01',17)
     
170. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-06-01',18)
     
171. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-07-01',19)
     
172. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-08-01',20)
     
173. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-09-01',21)
     
174. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-10-01',22)
     
175. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-11-01',23)
     
176. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-12-01',24)
     
177. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-01-02',1)
     
178. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-02-02',2)
     
179. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-03-02',3)
     
180. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-04-02',4)
     
181. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-05-02',5)
     
182. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-06-02',6)
     
183. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-07-02',7)
     
184. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-08-02',8)
     
185. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-09-02',9)
     
186. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-10-02',10)
     
187. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-11-02',11)
     
188. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2018-12-02',12)
     
189. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-01-02',13)
     
190. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-02-02',14)
     
191. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-03-02',15)
     
192. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-04-02',16)
     
193. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-05-02',17)
     
194. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-06-02',18)
     
195. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-07-02',19)
     
196. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-08-02',20)
     
197. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-09-02',21)
     
198. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-10-02',22)
     
199. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-11-02',23)
     
200. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('B','2019-12-02',24)
     
201. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-01-01',1)
     
202. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-02-01',2)
     
203. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-03-01',3)
     
204. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-04-01',4)
     
205. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-05-01',5)
     
206. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-06-01',6)
     
207. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-07-01',7)
     
208. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-08-01',8)
     
209. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-09-01',9)
     
210. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-10-01',10)
     
211. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-11-01',11)
     
212. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-12-01',12)
     
213. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-01-01',13)
     
214. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-02-01',14)
     
215. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-03-01',15)
     
216. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-04-01',16)
     
217. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-05-01',17)
     
218. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-06-01',18)
     
219. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-07-01',19)
     
220. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-08-01',20)
     
221. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-09-01',21)
     
222. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-10-01',22)
     
223. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-11-01',23)
     
224. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-12-01',24)
     
225. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-01-02',1)
     
226. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-02-02',2)
     
227. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-03-02',3)
     
228. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-04-02',4)
     
229. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-05-02',5)
     
230. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-06-02',6)
     
231. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-07-02',7)
     
232. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-08-02',8)
     
233. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-09-02',9)
     
234. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-10-02',10)
     
235. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-11-02',11)
     
236. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2018-12-02',12)
     
237. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-01-02',13)
     
238. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-02-02',14)
     
239. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-03-02',15)
     
240. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-04-02',16)
     
241. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-05-02',17)
     
242. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-06-02',18)
     
243. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-07-02',19)
     
244. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-08-02',20)
     
245. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-09-02',21)
     
246. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-10-02',22)
     
247. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-11-02',23)
     
248. INSERT INTO [dbo].[REPORT] ([NAME],[DATE],[AMOUNT]) VALUES ('A','2019-12-02',24)

复制代码

计算得到结果    回帖后可见

游客，如果您要查看本帖隐藏内容请回复

得到的结果

1111111111111111111111111111111111

学习一下，看看是怎样操作的

很好
     

来学习，学习

学习一下，哈哈

这个厉害了，我学习下。

不知具体如何操作，高大上！

学习一下，大佬加油

RE: 一个表间公式计算同比、年累、环比的方法 [修改]

1111111111111111111111111111111111

学习一下，看看是怎样操作的

很好
     

来学习，学习

学习一下，哈哈

这个厉害了，我学习下。

不知具体如何操作，高大上！

学习一下，大佬加油

RE: 一个表间公式计算同比、年累、环比的方法 [修改]