Pivot Table Practice Problem

Brought to you by PivotXL

[Link]

🎯 What This Workbook Teaches

This practice workbook is designed to help you master pivot tables in Excel using realisti

You’ll learn how to:

Summarize transactions by region, product, department, and category
Group data by months, quarters, and years for time-based analysis
Build multi-level financial statements like P&L and Balance Sheets
Create calculated fields for metrics like margins, variances, and retained earnings

💡 Next Step: Automate It with PivotXL

This template is a starting point. PivotXL takes these same steps and automates them a
Excel to your accounting data, managing mappings, and refreshing your reports in seco

📬 Sign up for Free

[Link]
e Practice Problems
by PivotXL

ables in Excel using realistic business data.

category
alysis
eets
d retained earnings

ps and automates them across systems — connecting

hing your reports in seconds.
Pivot Table Practice Problems

Beginner
1. Summarize Sales by Region - Create a pivot showing total sales per region.
2. Count Transactions by Month - Group by month and count the number of transactions.
3. Total Expenses by Category - Show total spend by expense category.
4. Filter by a Specific Value - Show sales by product for only the 'West' region.

Intermediate
5. Trial Balance Summarization - Show net balances for each account.
6. Group Accounts by Statement Type - Show totals by Statement type.
7. Year-over-Year Revenue Comparison - Compare each year's revenue side by side.
8. Expense Breakdown by Department - Department in rows, Expense Category in columns.

Advanced
9. Multi-Level P&L Statement - Statement → Line Item hierarchy, grouped by month.
10. Balance Sheet as of Month-End - Show as-of balances for each month-end.
11. Retained Earnings Calculation - Display retained earnings in a pivot.
12. Margin Analysis by Product - Calculate Gross Margin % per product.
13. Variance Analysis - Show variance amount and variance % in a pivot table.

Expert
14. Custom Sorting of P&L Lines - Apply a custom order in the pivot.
15. Multi-Dimensional Cube Simulation - Slice and dice data by different combinations of dimensions.

For Solutions -- see link below

[Link]
Transaction ID Date Region Product DepartmenCategory Statement Statement Amount
1 ### West Product B OperationsCOGS Balance ShNet Incom 4499.13
2 ### West Product B Marketing COGS P&L Gross Profi 2023.53
3 ### East Product A Marketing COGS P&L Revenue 1341.48
4 ### West Product B Sales COGS P&L COGS 6093.83
5 ### South Product A Marketing Operating P&L Net Incom 8271.96
6 ### North Product B Marketing COGS Balance ShCOGS 6402.4
7 ### East Product B Sales Operating Balance ShNet Incom 3129.96
8 ### West Product A Marketing COGS P&L Net Incom 8157.29
9 ### South Product A OperationsRevenue P&L Gross Profi 1956.32
10 ### West Product A Marketing COGS P&L Net Incom 3297.58
11 ### North Product C OperationsOperating Balance ShGross Profi 4401.25
12 ### East Product A OperationsRevenue Balance ShNet Incom 7558.21
13 ### West Product A OperationsCOGS P&L Revenue 4093.73
14 ### West Product C Marketing Operating P&L COGS 1612.84
15 ### North Product A Sales Operating Balance ShGross Profi 8861.86
16 ### East Product B OperationsOperating Balance ShGross Profi 7281.14
17 ### East Product A OperationsRevenue P&L COGS 6698.13
18 ### West Product B OperationsOperating Balance ShRevenue 8728.77
19 ### South Product A OperationsCOGS P&L Operating 6679.3
20 ### South Product A Sales COGS Balance ShNet Incom 8453.3
21 ### East Product A Marketing COGS P&L Net Incom 7268.5
22 ### North Product C Marketing Operating Balance ShCOGS 8465.28
23 ### East Product B Sales Operating P&L Operating 9425.76
24 ### West Product B OperationsOperating Balance ShRevenue 5085.06
25 ### North Product A Sales Revenue P&L Revenue 2939.18
26 ### West Product A Sales COGS Balance ShGross Profi 1898.88
27 ### South Product A Marketing COGS P&L Gross Profi 3512.24
28 ### East Product C Sales Revenue Balance ShCOGS 7032.82
29 ### East Product C OperationsOperating P&L Net Incom 4514.27
30 ### North Product B OperationsRevenue Balance ShOperating 2466.71
31 ### West Product C Sales COGS Balance ShNet Incom 7667.9
32 ### North Product A Sales Operating P&L Net Incom 5782.49
33 ### East Product C Sales Operating P&L Gross Profi 3342.31
34 ### North Product A OperationsCOGS Balance ShNet Incom 3286.58
35 ### East Product B OperationsCOGS P&L COGS 4179.55
36 ### North Product C OperationsOperating P&L Operating 8158
37 ### North Product C Marketing Revenue Balance ShRevenue 8476.64
38 ### North Product A Marketing COGS P&L Operating 5147.38
39 ### North Product A Marketing Revenue P&L Gross Profi 1416.15
40 ### East Product A OperationsOperating Balance ShRevenue 1322.69
41 ### North Product C OperationsRevenue P&L Gross Profi 5875.96
42 ### North Product A OperationsOperating Balance ShNet Incom 7895.26
43 ### North Product A Sales Operating Balance ShRevenue 7845.96
44 ### South Product A Sales COGS P&L Revenue 2163.35
45 ### South Product A OperationsCOGS Balance ShCOGS 7930.84
46 ### East Product B OperationsCOGS P&L Operating 8665.94
47 ### West Product C OperationsCOGS P&L Revenue 3108.99
48 ### East Product C Marketing COGS Balance ShRevenue 4786.42
49 ### West Product C Marketing COGS Balance ShNet Incom 9435.86
50 ### North Product B Marketing COGS Balance ShRevenue 7322.18
51 ### East Product B Sales Operating Balance ShGross Profi 4041.7
52 ### North Product B OperationsOperating Balance ShOperating 9252.11
53 ### South Product B Sales Operating P&L Operating 5069.41
54 ### North Product A OperationsCOGS P&L Net Incom 6515.66
55 ### East Product A Marketing COGS P&L Revenue 3689.2
56 ### East Product C Marketing Operating Balance ShOperating 4420.36
57 ### West Product A Marketing Revenue Balance ShNet Incom 9788.08
58 ### North Product A Sales Revenue P&L COGS 5672.15
59 ### South Product A Marketing Operating Balance ShOperating 5067.8
60 ### North Product A Sales Operating Balance ShOperating 6885.58
61 ### North Product B OperationsOperating Balance ShCOGS 4697.67
62 ### North Product C OperationsOperating P&L COGS 9520.72
63 ### North Product C OperationsRevenue Balance ShOperating 6292.4
64 ### East Product C OperationsCOGS Balance ShRevenue 4093.01
65 ### North Product A OperationsRevenue Balance ShOperating 9303.67
66 ### West Product C Sales Operating Balance ShRevenue 4812.97
67 ### East Product B OperationsCOGS Balance ShNet Incom 3155.14
68 ### North Product B OperationsCOGS P&L Operating 7060.54
69 ### South Product A Sales Revenue Balance ShNet Incom 2561.96
70 ### East Product C Sales Revenue P&L COGS 5646.71
71 ### East Product A Marketing Revenue P&L Gross Profi 4591.01
72 ### South Product B Marketing Revenue Balance ShCOGS 9829.28
73 ### North Product B Marketing Operating Balance ShGross Profi 1934.15
74 ### North Product A Sales Revenue P&L Gross Profi 5509.96
75 ### South Product C OperationsOperating P&L Net Incom 2792.4
76 ### East Product B OperationsCOGS P&L Operating 4240.61
77 ### West Product B Sales Operating P&L COGS 8971.36
78 ### West Product C Sales COGS P&L Gross Profi 6052.93
79 ### North Product B OperationsRevenue P&L COGS 5370.31
80 ### North Product B Marketing Operating P&L COGS 1893.84
81 ### North Product B Sales COGS P&L Operating 5498.04
82 ### North Product B Marketing COGS P&L Revenue 5023.72
83 ### West Product B Sales Revenue Balance ShOperating 1890.46
84 ### North Product A Sales COGS P&L Revenue 4768.61
85 ### South Product A Marketing Revenue Balance ShCOGS 4222.8
 86 ### West Product B OperationsOperating Balance ShRevenue 1657.79
87 ### West Product A Sales Revenue P&L Net Incom 2933.99
88 ### South Product B Marketing Revenue Balance ShCOGS 4403.35
89 ### East Product B Marketing Revenue P&L Net Incom 8388.98
90 ### West Product B Marketing COGS Balance ShNet Incom 5473.34
91 ### North Product A Sales COGS P&L Operating 6788.83
92 ### North Product C Sales COGS P&L Gross Profi 3196.79
93 ### South Product C Marketing Operating Balance ShOperating 4982.41
94 ### East Product C OperationsOperating P&L COGS 3752.08
95 ### East Product B Sales Operating Balance ShNet Incom 5613.9
96 ### South Product C Sales Revenue P&L Gross Profi 1504.27
97 ### North Product C Marketing Operating Balance ShCOGS 6127.37
98 ### South Product B Marketing Operating P&L Gross Profi 4062.32
99 ### East Product A Sales Revenue Balance ShNet Incom 7197.78
100 ### South Product B Marketing COGS P&L COGS 3167.93
101 ### South Product C Marketing Revenue P&L Operating 6912.75
102 ### East Product A Sales COGS Balance ShNet Incom 3070.21
103 ### South Product C Sales COGS P&L Net Incom 6297.36
104 ### South Product A Marketing Operating Balance ShRevenue 6274.41
105 ### North Product C Sales Operating Balance ShNet Incom 2165.24
106 ### East Product B OperationsRevenue Balance ShNet Incom 7090.96
107 ### South Product B OperationsCOGS Balance ShGross Profi 6271.22
108 ### South Product C Sales Operating P&L Revenue 8078.41
109 ### West Product B Sales Operating P&L Revenue 5884.81
110 ### East Product C Marketing Operating Balance ShOperating 8298.44
111 ### South Product B OperationsRevenue P&L Operating 8307.75
112 ### East Product C OperationsCOGS P&L COGS 7108.14
113 ### South Product B Sales Revenue P&L Revenue 9175.43
114 ### West Product A Sales Revenue P&L Revenue 4953.46
115 ### South Product C OperationsRevenue Balance ShNet Incom 8551.59
116 ### West Product A OperationsCOGS Balance ShNet Incom 6856.2
117 ### East Product C Sales Revenue P&L COGS 4001.38
118 ### West Product C OperationsRevenue P&L Gross Profi 8219.26
119 ### West Product C Sales Revenue P&L COGS 4244.06
120 ### West Product B OperationsCOGS P&L Net Incom 1382.24
121 ### South Product A Sales Operating P&L Operating 6849.38
122 ### West Product A OperationsOperating P&L COGS 5127.9
123 ### East Product C Sales COGS Balance ShNet Incom 5511
124 ### North Product A Sales Operating P&L Revenue 5429.84
125 ### North Product A Sales Operating P&L Revenue 4112.51
126 ### West Product B Marketing Revenue Balance ShOperating 2447.7
127 ### South Product C Marketing COGS P&L Gross Profi 5748.15
128 ### East Product C Sales Revenue P&L Net Incom 3068.45
129 ### North Product A Marketing COGS Balance ShNet Incom 1815.95
130 ### South Product C Marketing Operating P&L Revenue 1667.92
131 ### North Product A OperationsRevenue Balance ShCOGS 8572.88
132 ### North Product A Marketing Operating Balance ShGross Profi 5465.24
133 ### South Product A Marketing Operating Balance ShOperating 6955.46
134 ### West Product B Sales Revenue P&L COGS 3655.09
135 ### North Product B Marketing Revenue P&L Gross Profi 5868.25
136 ### East Product B Sales Operating P&L Revenue 7546.91
137 ### West Product A Sales COGS P&L Gross Profi 9010.1
138 ### South Product A OperationsOperating P&L Operating 7848.86
139 ### West Product C Marketing Operating Balance ShRevenue 1857.04
140 ### South Product A Sales Operating P&L Net Incom 4191.3
141 ### North Product B OperationsRevenue P&L COGS 9505.08
142 ### South Product C Sales Operating Balance ShOperating 3440.39
143 ### West Product A OperationsOperating P&L Net Incom 4651.3
144 ### East Product A Sales COGS Balance ShNet Incom 4484.35
145 ### West Product A Sales Operating Balance ShOperating 4869.91
146 ### South Product A Marketing Operating Balance ShGross Profi 2332.78
147 ### North Product B Marketing Operating Balance ShGross Profi 1969.77
148 ### North Product A Sales Operating P&L COGS 9787.61
149 ### East Product A Sales Revenue P&L Operating 7056.53
150 ### South Product C Sales Operating P&L Net Incom 2458.85
151 ### West Product C Marketing Revenue Balance ShOperating 2649.11
152 ### South Product C Sales Revenue Balance ShRevenue 8184.92
153 ### North Product C Marketing Operating Balance ShCOGS 2958.48
154 ### West Product C OperationsCOGS P&L Net Incom 6941.52
155 ### North Product C OperationsRevenue P&L Gross Profi 3291.11
156 ### North Product B Marketing COGS Balance ShOperating 9633
157 ### West Product A Marketing COGS Balance ShGross Profi 1130.75
158 ### East Product B Marketing COGS Balance ShNet Incom 6288.37
159 ### North Product A OperationsOperating Balance ShRevenue 9706.87
160 ### South Product C Marketing COGS P&L Net Incom 8612.62
161 ### North Product C Marketing Revenue Balance ShNet Incom 4701
162 ### South Product C Sales Revenue Balance ShCOGS 1101.55
163 ### East Product A OperationsRevenue P&L COGS 1113.65
164 ### North Product B OperationsOperating Balance ShCOGS 2950.9
165 ### North Product A Sales Operating P&L Operating 3028.4
166 ### North Product C Sales Revenue P&L Revenue 9821.05
167 ### West Product C OperationsOperating P&L Gross Profi 7392.01
168 ### West Product B Sales COGS P&L Gross Profi 9809.41
169 ### West Product C OperationsCOGS P&L Gross Profi 7848.27
170 ### West Product C Marketing COGS Balance ShGross Profi 2470.15
171 ### East Product C Sales Operating P&L Net Incom 9046.84
172 ### East Product B Sales Operating Balance ShCOGS 6839.89
173 ### East Product A OperationsOperating Balance ShNet Incom 6364.26
174 ### South Product C OperationsRevenue P&L Operating 5659.11
175 ### East Product A OperationsRevenue Balance ShGross Profi 2884.54
176 ### East Product A Sales Operating Balance ShOperating 4265.9
177 ### East Product B Sales COGS P&L Revenue 2169.34
178 ### West Product B Marketing COGS Balance ShOperating 8378.52
179 ### West Product C OperationsOperating Balance ShGross Profi 6544.66
180 ### East Product A OperationsOperating Balance ShGross Profi 6468.49
181 ### North Product C Marketing Operating P&L Operating 8314.48
182 ### South Product B Sales Revenue Balance ShOperating 8640.78
183 ### South Product C Marketing COGS P&L Operating 7699.69
184 ### West Product B OperationsOperating Balance ShCOGS 4471.26
185 ### East Product A Marketing Operating Balance ShOperating 4633.99
186 ### South Product B OperationsOperating P&L Revenue 3051.96
187 ### South Product B Marketing COGS P&L Revenue 6111.23
188 ### East Product C OperationsCOGS Balance ShOperating 8150.61
189 ### North Product B Sales Operating Balance ShRevenue 5939.04
190 ### South Product A OperationsCOGS P&L Operating 8995.02
191 ### East Product C Marketing COGS P&L Revenue 9532.48
192 ### North Product B OperationsOperating Balance ShOperating 5027.96
193 ### West Product A Marketing Revenue Balance ShOperating 3456.11
194 ### North Product C OperationsOperating Balance ShCOGS 2110.5
195 ### North Product A Marketing COGS P&L Gross Profi 6678.33
196 ### West Product C OperationsRevenue Balance ShNet Incom 2168.64
197 ### North Product B Sales COGS Balance ShCOGS 3416.56
198 ### East Product A OperationsRevenue Balance ShRevenue 4286.25
199 ### West Product C Sales Revenue P&L Revenue 5497.91
200 ### North Product C Marketing Revenue P&L Net Incom 5354.48
201 ### West Product A Sales Operating Balance ShNet Incom 5260.36
202 ### West Product A OperationsRevenue P&L Operating 5036.47
203 ### South Product C Marketing Revenue Balance ShGross Profi 5919.09
204 ### South Product B OperationsOperating Balance ShOperating 7347.79
205 ### West Product B OperationsOperating P&L Net Incom 6900.46
206 ### East Product C Sales Operating Balance ShRevenue 1744.73
207 ### East Product B Marketing Operating P&L Revenue 7988.98
208 ### North Product B Marketing Revenue Balance ShNet Incom 7470.24
209 ### North Product C Sales Operating P&L COGS 3789.45
210 ### West Product B Marketing Operating Balance ShNet Incom 7372.29
211 ### North Product B Sales Operating P&L Operating 8005.21
212 ### North Product C OperationsOperating Balance ShOperating 4297.06
213 ### North Product C Sales COGS Balance ShNet Incom 4766.38
214 ### North Product A OperationsRevenue Balance ShOperating 1558.84
215 ### North Product B OperationsRevenue P&L COGS 1707.95
216 ### South Product A Sales Operating Balance ShCOGS 2311.48
217 ### North Product C Marketing COGS Balance ShRevenue 3858.81
218 ### West Product A OperationsRevenue Balance ShNet Incom 7105.01
219 ### North Product C Marketing COGS P&L Net Incom 1812.11
220 ### North Product C OperationsOperating Balance ShNet Incom 3225.39
221 ### North Product A OperationsRevenue Balance ShOperating 6881.15
222 ### South Product B OperationsOperating P&L Revenue 1665.02
223 ### West Product B Sales Revenue Balance ShOperating 4390.05
224 ### East Product B OperationsRevenue Balance ShOperating 2099.91
225 ### East Product A Marketing Revenue Balance ShNet Incom 2104.48
226 ### East Product C Sales Operating P&L Revenue 7651.24
227 ### West Product A Marketing COGS P&L Net Incom 6338.45
228 ### East Product B OperationsOperating P&L Operating 5601.38
229 ### East Product A Sales COGS P&L Net Incom 2610.65
230 ### West Product A Marketing Operating Balance ShNet Incom 3464.4
231 ### West Product B OperationsCOGS P&L Net Incom 5032.13
232 ### North Product B Marketing COGS P&L Gross Profi 1198.33
233 ### West Product A Sales Operating Balance ShOperating 2661.98
234 ### North Product B Marketing COGS Balance ShNet Incom 7273.06
235 ### North Product A OperationsOperating P&L Operating 7862.2
236 ### West Product C Sales Operating Balance ShRevenue 3391.59
237 ### South Product B Marketing Operating Balance ShNet Incom 8628.29
238 ### North Product A Sales COGS Balance ShRevenue 3407.65
239 ### West Product B Sales COGS Balance ShRevenue 1725.88
240 ### South Product C Sales Operating P&L Net Incom 6469.89
241 ### East Product A OperationsRevenue P&L COGS 5315.57
242 ### West Product C Sales COGS P&L COGS 8886.12
243 ### West Product B Sales Operating P&L Revenue 5288.53
244 ### East Product A OperationsCOGS Balance ShOperating 6438.63
245 ### South Product B OperationsRevenue Balance ShOperating 3866.51
246 ### East Product C OperationsCOGS Balance ShCOGS 5720.99
247 ### West Product A Marketing Operating P&L COGS 7916.15
248 ### West Product A Marketing Operating Balance ShGross Profi 9290.18
249 ### North Product B Marketing COGS P&L Operating 7078.55
250 ### South Product B Sales Operating Balance ShCOGS 8913.63
251 ### South Product B Sales COGS Balance ShRevenue 4002.2
252 ### South Product A Marketing Operating Balance ShOperating 5759.42
253 ### South Product C Sales Operating P&L Net Incom 6280.45
254 ### West Product B Sales COGS P&L Operating 9160.78
255 ### North Product B Sales COGS P&L Operating 8874.48
256 ### South Product C Marketing Operating P&L COGS 8887.48
257 ### North Product B OperationsCOGS Balance ShNet Incom 9479.51
258 ### South Product A Marketing Operating Balance ShOperating 4887.61
259 ### North Product A Marketing COGS P&L COGS 9067.82
260 ### East Product A Sales Operating Balance ShRevenue 1789.84
261 ### North Product A OperationsOperating Balance ShCOGS 8880.42
262 ### South Product A OperationsOperating P&L Revenue 4513.45
263 ### East Product B Sales COGS P&L Gross Profi 2296.96
264 ### East Product A Marketing Revenue Balance ShCOGS 3809.08
265 ### North Product A Sales COGS Balance ShOperating 1801.58
266 ### East Product C Sales COGS P&L COGS 9086.89
267 ### North Product C Sales Operating Balance ShNet Incom 3130.96
268 ### East Product C OperationsCOGS P&L Revenue 5431.24
269 ### North Product C Marketing Operating P&L Revenue 4792.45
270 ### East Product C Marketing Revenue P&L Operating 3754.24
271 ### West Product A Sales Revenue Balance ShNet Incom 9103.48
272 ### East Product A Marketing COGS Balance ShCOGS 5762.12
273 ### East Product C Marketing COGS Balance ShNet Incom 1148.57
274 ### West Product A OperationsRevenue Balance ShOperating 7918.03
275 ### East Product A Sales COGS P&L Operating 6008.59
276 ### South Product A Marketing Operating P&L Gross Profi 5596.7
277 ### North Product B Sales COGS P&L Revenue 5735.26
278 ### South Product A Marketing COGS P&L Operating 9039.45
279 ### East Product C Sales Operating P&L Net Incom 9647.51
280 ### West Product C Sales Revenue P&L Revenue 2136.53
281 ### East Product B Sales Operating P&L Net Incom 7104.59
282 ### North Product A Sales Revenue P&L COGS 6321.1
283 ### East Product C Sales COGS P&L Gross Profi 2918.46
284 ### North Product A Sales Operating P&L COGS 5628.92
285 ### North Product C Sales Revenue Balance ShNet Incom 4882.42
286 ### West Product C OperationsOperating P&L Revenue 2721.1
287 ### West Product A OperationsRevenue P&L Gross Profi 6864.24
288 ### North Product C OperationsRevenue Balance ShCOGS 3056.02
289 ### East Product A Marketing COGS Balance ShNet Incom 6776.36
290 ### West Product A OperationsRevenue Balance ShOperating 9429.94
291 ### West Product C OperationsCOGS P&L Operating 2513.87
292 ### North Product B OperationsCOGS Balance ShRevenue 6395.16
293 ### West Product C Marketing COGS Balance ShNet Incom 7123.3
294 ### North Product B Sales Revenue Balance ShNet Incom 2833.7
295 ### South Product B OperationsRevenue P&L Revenue 7991.5
296 ### South Product B OperationsCOGS P&L Net Incom 9113.8
297 ### East Product C Marketing Revenue P&L Net Incom 4359.68
298 ### South Product B Sales Operating Balance ShNet Incom 9739.24
299 ### South Product C OperationsOperating P&L Gross Profi 1527.34
300 ### North Product C Sales COGS P&L COGS 1233.19
301 ### West Product A Marketing Operating P&L COGS 6459.91
302 ### South Product C Marketing COGS P&L Operating 5193.4
303 ### North Product B OperationsCOGS P&L Revenue 9553.4
304 ### West Product A Marketing Operating P&L Operating 3014.6
305 ### West Product C Marketing COGS Balance ShCOGS 6473.64
306 ### South Product C OperationsRevenue P&L Net Incom 4944.97
307 ### West Product B OperationsCOGS Balance ShNet Incom 4134.27
308 ### East Product A OperationsRevenue Balance ShGross Profi 3374.46
309 ### South Product C OperationsOperating Balance ShCOGS 3256.01
310 ### South Product B OperationsOperating P&L COGS 6694.53
311 ### North Product A OperationsOperating Balance ShRevenue 2858.15
312 ### North Product C Sales Operating P&L Net Incom 2851.02
313 ### North Product B Marketing COGS P&L COGS 8552.83
314 ### East Product A Marketing Revenue P&L Operating 5883.46
315 ### East Product C OperationsOperating P&L Net Incom 9418.5
316 ### South Product A OperationsCOGS Balance ShNet Incom 9007
317 ### North Product B Sales COGS Balance ShCOGS 1360
318 ### East Product C Sales Revenue P&L Net Incom 5551.83
319 ### South Product C OperationsOperating Balance ShCOGS 6742.81
320 ### East Product C Marketing COGS Balance ShOperating 9913.43
321 ### North Product B Sales COGS P&L Operating 8567.24
322 ### West Product A Sales Revenue Balance ShCOGS 5869.62
323 ### East Product C OperationsCOGS Balance ShRevenue 4237.22
324 ### North Product A OperationsRevenue P&L Operating 9419.73
325 ### West Product B Sales Operating Balance ShCOGS 2932.93
326 ### South Product C Marketing COGS P&L Operating 3606.27
327 ### North Product B Sales Operating P&L COGS 5461.07
328 ### East Product A Sales Operating P&L Net Incom 3666.99
329 ### East Product C Marketing COGS P&L COGS 5803.36
330 ### South Product A OperationsCOGS Balance ShCOGS 9537.47
331 ### South Product A OperationsOperating Balance ShNet Incom 7830.46
332 ### North Product B OperationsOperating P&L COGS 6675.85
333 ### North Product B Marketing COGS P&L Gross Profi 2290.73
334 ### South Product B OperationsOperating P&L COGS 5366.74
335 ### North Product A Marketing COGS P&L Net Incom 1798.97
336 ### North Product A Sales Revenue P&L Operating 8457.58
337 ### North Product C Marketing Revenue Balance ShOperating 4989.02
338 ### South Product A Marketing Operating P&L Operating 2466.48
339 ### East Product A OperationsRevenue P&L Revenue 1564.61
340 ### South Product C OperationsOperating P&L COGS 9798.15
341 ### East Product A Sales Revenue P&L Net Incom 3893.5
342 ### East Product B Marketing Operating P&L COGS 2535.17
343 ### East Product B OperationsRevenue Balance ShGross Profi 6072.59
344 ### North Product C Sales COGS P&L Operating 2644.26
345 ### West Product C Marketing COGS Balance ShNet Incom 9758.01
346 ### North Product A Sales Revenue P&L COGS 6812.41
347 ### East Product B OperationsCOGS Balance ShOperating 2659.13
348 ### West Product C Marketing Revenue P&L Net Incom 6309.49
349 ### North Product A Marketing Operating Balance ShRevenue 2522.81
350 ### South Product A Sales Revenue Balance ShGross Profi 7417.51
351 ### West Product A Marketing COGS Balance ShNet Incom 4034.19
352 ### North Product A OperationsOperating P&L Net Incom 9639.1
353 ### North Product B Sales Revenue P&L COGS 3001.01
354 ### North Product C Marketing Revenue P&L Revenue 6421.33
355 ### North Product A Sales Revenue Balance ShGross Profi 8366.18
356 ### East Product C Sales COGS Balance ShCOGS 1960.25
357 ### East Product A OperationsOperating P&L Operating 7145.84
358 ### East Product B Marketing Operating P&L Net Incom 5314.06
359 ### South Product C Marketing Revenue Balance ShCOGS 3304.7
360 ### South Product A Marketing Operating Balance ShNet Incom 6373.12
361 ### South Product C Sales Operating P&L Gross Profi 6525.3
362 ### North Product C Sales Revenue Balance ShNet Incom 3512.11
363 ### East Product B OperationsOperating P&L Net Incom 1276.96
364 ### West Product C Marketing COGS P&L Revenue 4892.96
365 ### West Product A Marketing Operating P&L Gross Profi 2770.81
366 ### South Product C OperationsRevenue P&L Revenue 4983.28
367 ### South Product A Sales Revenue Balance ShGross Profi 1736.97
368 ### North Product C OperationsRevenue Balance ShOperating 8660.3
369 ### South Product A Sales COGS Balance ShOperating 9235.54
370 ### South Product A Marketing COGS Balance ShRevenue 1417.66
371 ### South Product C OperationsOperating Balance ShOperating 1030.75
372 ### North Product A Marketing Operating P&L Operating 8538.28
373 ### South Product A OperationsOperating P&L Net Incom 1558.06
374 ### East Product C Marketing Revenue Balance ShGross Profi 1545.49
375 ### South Product C Marketing COGS P&L Gross Profi 5466.53
376 ### South Product C OperationsRevenue P&L Gross Profi 3055.27
377 ### South Product B OperationsRevenue Balance ShRevenue 8082.01
378 ### East Product C Sales Revenue Balance ShCOGS 4505.95
379 ### South Product B Marketing Operating P&L COGS 6928.95
380 ### North Product B Marketing COGS P&L Gross Profi 9891.44
381 ### South Product C Marketing COGS P&L Operating 9093.09
382 ### East Product B Marketing COGS P&L Operating 7594.43
383 ### North Product B Sales COGS P&L Net Incom 3636.15
384 ### North Product A Marketing Revenue Balance ShGross Profi 4318.16
385 ### West Product B Sales Revenue Balance ShCOGS 7934.03
386 ### North Product C Marketing COGS P&L Revenue 6200.93
387 ### East Product C Marketing Revenue P&L Net Incom 2183.77
388 ### North Product A Sales Revenue P&L Gross Profi 4520.13
389 ### East Product A OperationsCOGS P&L Gross Profi 8677.84
390 ### West Product B OperationsCOGS Balance ShGross Profi 7791.63
391 ### West Product C OperationsRevenue P&L Net Incom 3805.62
392 ### East Product C OperationsOperating Balance ShOperating 9290.08
393 ### West Product A Sales Operating Balance ShRevenue 6204.01
394 ### South Product B Marketing Operating Balance ShRevenue 6950.01
395 ### West Product A OperationsRevenue P&L COGS 9530.22
396 ### East Product A Marketing COGS P&L Operating 4729.11
397 ### North Product B OperationsRevenue P&L Revenue 1950.48
398 ### North Product A OperationsOperating P&L COGS 4329.41
399 ### North Product C Sales Revenue Balance ShRevenue 5759.14
400 ### North Product B OperationsRevenue P&L Operating 5629.57
401 ### North Product B Sales COGS Balance ShCOGS 2374.01
402 ### West Product A OperationsRevenue Balance ShGross Profi 4590.38
403 ### West Product A Marketing Operating P&L Revenue 9521.3
404 ### South Product C Marketing Operating Balance ShGross Profi 3599.34
405 ### East Product A Marketing Revenue Balance ShOperating 8697.96
406 ### West Product A Marketing COGS P&L Operating 6880.01
407 ### West Product A OperationsCOGS P&L Revenue 9229.81
408 ### South Product C Sales Operating Balance ShOperating 4210.15
409 ### North Product C Marketing Revenue P&L COGS 6287.08
410 ### South Product A OperationsCOGS Balance ShNet Incom 5065.39
411 ### East Product B Marketing Operating P&L Gross Profi 1206.44
412 ### East Product C Marketing Revenue Balance ShNet Incom 8127.43
413 ### North Product B Sales Revenue Balance ShGross Profi 5265.91
414 ### North Product B OperationsRevenue P&L Gross Profi 5209.3
415 ### North Product A Marketing Operating P&L Gross Profi 5942.19
416 ### North Product A Marketing Operating P&L Operating 3775.56
417 ### North Product A OperationsCOGS P&L Operating 6650.14
418 ### East Product C Sales Operating Balance ShNet Incom 4137.36
419 ### West Product C Marketing COGS Balance ShGross Profi 3112.15
420 ### South Product A Sales Operating P&L Revenue 3520.57
421 ### East Product C Sales Revenue P&L COGS 2129.63
422 ### West Product B Marketing COGS Balance ShGross Profi 7491.45
423 ### East Product B Marketing Operating Balance ShOperating 3200.98
424 ### East Product C Sales COGS P&L COGS 7318.7
425 ### East Product A Marketing Operating P&L Operating 5369.58
426 ### North Product A Marketing Operating Balance ShCOGS 9613.72
427 ### North Product A Sales Operating Balance ShGross Profi 1588.42
428 ### West Product A OperationsRevenue Balance ShGross Profi 5609.96
429 ### South Product B Marketing Revenue P&L Revenue 4628.13
430 ### South Product A Sales COGS P&L COGS 5025.4
431 ### North Product A Sales Operating P&L Gross Profi 7076.05
432 ### North Product C Sales COGS P&L Operating 1362.91
433 ### North Product B OperationsRevenue Balance ShGross Profi 8933.07
434 ### North Product B Marketing COGS Balance ShOperating 1856.44
435 ### East Product C OperationsOperating Balance ShRevenue 9231.61
436 ### North Product B OperationsRevenue P&L Revenue 5635.01
437 ### East Product C Marketing COGS P&L Gross Profi 8737.8
438 ### West Product B OperationsOperating P&L Revenue 6093.06
439 ### East Product A OperationsCOGS Balance ShCOGS 9261.28
440 ### East Product A OperationsOperating P&L Net Incom 1928.43
441 ### North Product B Marketing Operating Balance ShCOGS 7689.7
442 ### East Product B OperationsRevenue P&L Net Incom 9291.71
443 ### South Product B Marketing Revenue Balance ShNet Incom 3545.73
444 ### West Product B Sales COGS P&L Net Incom 9315.29
445 ### East Product B OperationsCOGS P&L Operating 5487.02
446 ### East Product C Marketing COGS Balance ShCOGS 2112.81
447 ### East Product A OperationsCOGS P&L Net Incom 1646.14
448 ### East Product C OperationsCOGS P&L Operating 6015.17
449 ### East Product B Sales Revenue P&L Gross Profi 4276.87
450 ### North Product C Marketing Operating P&L Gross Profi 9435.86
451 ### West Product A OperationsRevenue Balance ShRevenue 2621.93
452 ### West Product B Marketing COGS Balance ShOperating 2865.17
453 ### West Product A Marketing Operating Balance ShOperating 9749.2
454 ### West Product A Marketing COGS Balance ShRevenue 7941.15
455 ### South Product B Sales COGS P&L Revenue 7657.45
456 ### South Product A Sales COGS P&L COGS 4545.21
457 ### South Product A Sales Operating Balance ShRevenue 8509.19
458 ### North Product B OperationsOperating Balance ShRevenue 7744.57
459 ### East Product C Sales COGS Balance ShGross Profi 2808.24
460 ### South Product A OperationsOperating P&L Gross Profi 3369.43
461 ### South Product A OperationsRevenue P&L Revenue 7913.39
462 ### West Product C Sales Operating P&L Operating 9147.16
463 ### West Product C OperationsRevenue Balance ShCOGS 8921.03
464 ### North Product C OperationsOperating P&L COGS 8397.55
465 ### West Product A Marketing COGS P&L Revenue 9558.07
466 ### East Product C OperationsOperating Balance ShRevenue 9561.88
467 ### East Product A OperationsCOGS P&L Operating 8003.82
468 ### East Product B OperationsRevenue Balance ShNet Incom 2563.88
469 ### West Product A Marketing Revenue P&L Gross Profi 9704.06
470 ### East Product A Marketing Operating P&L Operating 1358.25
471 ### South Product C OperationsCOGS Balance ShRevenue 3525.54
472 ### East Product A OperationsRevenue P&L COGS 1458.78
473 ### West Product B Sales Operating P&L COGS 2353.78
474 ### West Product A Marketing Operating P&L Net Incom 2217.48
475 ### North Product A Marketing COGS P&L COGS 7186.8
476 ### West Product A OperationsRevenue P&L Operating 3986.04
477 ### North Product A OperationsRevenue P&L Gross Profi 3534.31
478 ### North Product C Sales Operating Balance ShRevenue 5317.11
479 ### West Product B OperationsRevenue Balance ShRevenue 8124.56
480 ### North Product B OperationsOperating Balance ShRevenue 4456.89
481 ### North Product C Marketing COGS Balance ShCOGS 4160.59
482 ### North Product C Marketing COGS P&L Revenue 1714.39
483 ### South Product B Sales COGS P&L Revenue 4704.76
484 ### South Product A Marketing Operating P&L Net Incom 7485.18
485 ### East Product C Sales COGS P&L Gross Profi 3434.92
486 ### East Product C OperationsCOGS Balance ShGross Profi 1968.84
487 ### South Product C Sales Revenue Balance ShRevenue 5794.32
488 ### South Product C OperationsRevenue Balance ShCOGS 7178.47
489 ### West Product C Marketing Revenue Balance ShRevenue 1184.88
490 ### North Product A OperationsRevenue P&L Revenue 3096.44
491 ### East Product B Sales COGS P&L Net Incom 2628.66
492 ### North Product A Sales Operating P&L Gross Profi 6405.89
493 ### South Product B Marketing COGS Balance ShCOGS 1906.93
494 ### South Product B OperationsRevenue P&L Net Incom 7266.23
495 ### North Product C Marketing Revenue Balance ShOperating 3500.83
496 ### South Product C OperationsRevenue Balance ShCOGS 5871.04
497 ### West Product B Sales Revenue P&L COGS 8731.98
498 ### East Product B Sales Revenue P&L Gross Profi 2897.86
499 ### South Product C Marketing COGS Balance ShGross Profi 1382.4
500 ### North Product C Marketing COGS Balance ShNet Incom 7878.76
Region Sum of Amount
East 635489.41
North 831263.59
South 632817.76
West 627098.86
(empty)
Total Result 2726669.62
Count of Transaction ID
500