83b56307-458a-4db0-8be3-7d493a8a2b32 SQL Data Source=uspgh-scdb-p1;Initial Catalog=TRANS true 11in true 8.5in true 1in 1in 1in 121fae6b-3e56-4018-b2f5-b6a133310554 segment System.String group System.String division System.String division_city System.String inv_year_id System.Double company name System.String carrier_type System.String entry_type System.String 1 System.Decimal 2 System.Decimal 3 System.Decimal 4 System.Decimal 5 System.Decimal 6 System.Decimal 7 System.Decimal 8 System.Decimal 9 System.Decimal 10 System.Decimal 11 System.Decimal 12 System.Decimal TRANS SELECT * FROM ttg_ssrs_reporting_vw2 pivot ( sum([charges]) for [inv_month_id] in ( [1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12] ) ) pvttbl where division = 'lcd' and inv_year_id = '2010' true division System.String location System.String year System.String COGS System.Decimal Trans Billing Amt System.Decimal JAN System.Decimal FEB System.Decimal MAR System.Decimal APR System.Decimal MAY System.Decimal JUN System.Decimal JUL System.Decimal AUG System.Decimal SEP System.Decimal OCT System.Decimal NOV System.Decimal DEC System.Decimal TRANS select * from ttg_monthly_revenue_salespvt_vw where year = 2010 and division = 'lcd' true division System.String location System.String year System.String Sales System.Decimal COGS System.Decimal JAN System.Decimal FEB System.Decimal MAR System.Decimal APR System.Decimal MAY System.Decimal JUN System.Decimal JUL System.Decimal AUG System.Decimal SEP System.Decimal OCT System.Decimal NOV System.Decimal DEC System.Decimal TRANS select * from ttg_monthly_revenue_TRNbillingpvt_vw where year = 2010 and division = 'lcd' true 20in textbox1 1 true 0.36in LCD ScoreCard 2010 YTD TRANS0.36in =Fields!division_city.Value
4 division_city 439 true =Fields!division_city.Value 438 true =sum(Fields!ID1.Value) 437 true =sum(Fields!ID2.Value) 436 true =sum(Fields!ID3.Value) 435 true =sum(Fields!ID4.Value) 434 true =sum(Fields!ID5.Value) 433 true =sum(Fields!ID6.Value) 432 true =sum(Fields!ID7.Value) 431 true =sum(Fields!ID8.Value) 430 true =sum(Fields!ID9.Value) 429 true =sum(Fields!ID10.Value) 428 true =sum(Fields!ID11.Value) 427 true =sum(Fields!ID12.Value) textbox151 426 true =sum(Fields!ID1.Value)+sum(Fields!ID2.Value)+sum(Fields!ID3.Value)+sum(Fields!ID4.Value)+sum(Fields!ID5.Value)+sum(Fields!ID6.Value)+sum(Fields!ID7.Value)+sum(Fields!ID8.Value)+sum(Fields!ID9.Value)+sum(Fields!ID10.Value)+sum(Fields!ID11.Value)+sum(Fields!ID12.Value) 0.25in true division_city textbox387 425 true textbox283 424 true textbox282 423 true textbox281 422 true textbox391 421 true textbox392 420 true textbox393 419 true textbox394 418 true textbox395 417 true textbox396 416 true textbox397 415 true textbox398 414 true textbox399 413 true textbox400 412 true textbox401 411 true textbox402 410 true textbox403 409 true 0.25in true division_city textbox370 408 true 407 true 406 true 405 true 404 true =Fields!ID1.Value JAN 403 true FEB 402 true MAR 401 true APR 400 true MAY 399 true JUN 398 true JUL 397 true AUG 396 true SEP 395 true OCT 394 true NOV 393 true DEC 392 true 2010 YTD 0.25in true division_city textbox353 391 true 390 true 389 true 388 true Grand Total 387 true =sum(Fields!ID1.Value) 386 true =sum(Fields!ID2.Value) 385 true =sum(Fields!ID3.Value) 384 true =sum(Fields!ID4.Value) 383 true =sum(Fields!ID5.Value) 382 true =sum(Fields!ID6.Value) 381 true =sum(Fields!ID7.Value) 380 true =sum(Fields!ID8.Value) 379 true =sum(Fields!ID9.Value) 378 true =sum(Fields!ID10.Value) 377 true =sum(Fields!ID11.Value) 376 true =sum(Fields!ID12.Value) 375 true =sum(Fields!ID1.Value)+sum(Fields!ID2.Value)+sum(Fields!ID3.Value)+sum(Fields!ID4.Value)+sum(Fields!ID5.Value)+sum(Fields!ID6.Value)+sum(Fields!ID7.Value)+sum(Fields!ID8.Value)+sum(Fields!ID9.Value)+sum(Fields!ID10.Value)+sum(Fields!ID11.Value)+sum(Fields!ID12.Value) 0.25in true division_city textbox336 374 true 373 true 372 true 371 true Sales 370 true =Sum(Fields!JAN.Value, "DataSet1") 369 true =Sum(Fields!FEB.Value, "DataSet1") 368 true =Sum(Fields!MAR.Value, "DataSet1") 367 true =Sum(Fields!APR.Value, "DataSet1") 366 true =Sum(Fields!MAY.Value, "DataSet1") 365 true =Sum(Fields!JUN.Value, "DataSet1") 364 true =Sum(Fields!JUL.Value, "DataSet1") 363 true =Sum(Fields!AUG.Value, "DataSet1") 362 true =Sum(Fields!SEP.Value, "DataSet1") 361 true =Sum(Fields!OCT.Value, "DataSet1") 360 true =Sum(Fields!NOV.Value, "DataSet1") 359 true =Sum(Fields!DEC.Value, "DataSet1") 358 true =Sum(Fields!JAN.Value, "DataSet1")+ Sum(Fields!FEB.Value, "DataSet1")+ Sum(Fields!MAR.Value, "DataSet1")+ Sum(Fields!APR.Value, "DataSet1")+ Sum(Fields!MAY.Value, "DataSet1")+ Sum(Fields!JUN.Value, "DataSet1")+ Sum(Fields!JUL.Value, "DataSet1")+ Sum(Fields!AUG.Value, "DataSet1")+ Sum(Fields!SEP.Value, "DataSet1")+ Sum(Fields!OCT.Value, "DataSet1")+ Sum(Fields!NOV.Value, "DataSet1")+ Sum(Fields!DEC.Value, "DataSet1") 0.25in true division_city textbox319 357 true 356 true 355 true 354 true Trans Billing 353 true =Sum(Fields!JAN.Value, "trnbilling") 352 true =Sum(Fields!FEB.Value, "trnbilling") 351 true =Sum(Fields!MAR.Value, "trnbilling") 350 true =Sum(Fields!APR.Value, "trnbilling") 349 true =Sum(Fields!MAY.Value, "trnbilling") 348 true =Sum(Fields!JUN.Value, "trnbilling") 347 true =Sum(Fields!JUL.Value, "trnbilling") 346 true =Sum(Fields!AUG.Value, "trnbilling") 345 true =Sum(Fields!SEP.Value, "trnbilling") 344 true =Sum(Fields!OCT.Value, "trnbilling") 343 true =Sum(Fields!NOV.Value, "trnbilling") 342 true =Sum(Fields!DEC.Value, "trnbilling") 341 true =Sum(Fields!JAN.Value, "trnbilling")+ Sum(Fields!FEB.Value, "trnbilling")+ Sum(Fields!MAR.Value, "trnbilling")+ Sum(Fields!APR.Value, "trnbilling")+ Sum(Fields!MAY.Value, "trnbilling")+ Sum(Fields!JUN.Value, "trnbilling")+ Sum(Fields!JUL.Value, "trnbilling")+ Sum(Fields!AUG.Value, "trnbilling")+ Sum(Fields!SEP.Value, "trnbilling")+ Sum(Fields!OCT.Value, "trnbilling")+ Sum(Fields!NOV.Value, "trnbilling")+ Sum(Fields!DEC.Value, "trnbilling") 0.25in true division_city textbox302 340 true 339 true 338 true 337 true 336 true 335 true 334 true 333 true 332 true 331 true 330 true 329 true 328 true 327 true 326 true 325 true 324 true 0.25in true division_city textbox285 323 true 3 322 true Gross Cost as % to Sales 321 true =Sum(Fields!ID1.Value, "TRANS")/Sum(Fields!JAN.Value, "DataSet1") 320 true =Sum(Fields!ID2.Value, "TRANS")/Sum(Fields!FEB.Value, "DataSet1") 319 true =Sum(Fields!ID3.Value, "TRANS")/Sum(Fields!MAR.Value, "DataSet1") 318 true =Sum(Fields!ID4.Value, "TRANS")/Sum(Fields!APR.Value, "DataSet1") 317 true =Sum(Fields!ID5.Value, "TRANS")/Sum(Fields!MAY.Value, "DataSet1") 316 true =Sum(Fields!ID6.Value, "TRANS")/Sum(Fields!JUN.Value, "DataSet1") 315 true =Sum(Fields!ID7.Value, "TRANS")/Sum(Fields!JUL.Value, "DataSet1") 314 true =Sum(Fields!ID8.Value, "TRANS")/Sum(Fields!AUG.Value, "DataSet1") 313 true =Sum(Fields!ID9.Value, "TRANS")/Sum(Fields!SEP.Value, "DataSet1") 312 true =Sum(Fields!ID10.Value, "TRANS")/Sum(Fields!OCT.Value, "DataSet1") 311 true =Sum(Fields!ID11.Value, "TRANS")/Sum(Fields!NOV.Value, "DataSet1") 310 true =Sum(Fields!ID12.Value, "TRANS")/Sum(Fields!DEC.Value, "DataSet1") 309 true =(sum(Fields!ID1.Value)+ sum(Fields!ID2.Value)+ sum(Fields!ID3.Value)+ sum(Fields!ID4.Value)+ sum(Fields!ID5.Value)+ sum(Fields!ID6.Value)+ sum(Fields!ID7.Value)+ sum(Fields!ID8.Value)+ sum(Fields!ID9.Value)+ sum(Fields!ID10.Value)+ sum(Fields!ID11.Value)+ sum(Fields!ID12.Value))/ (Sum(Fields!JAN.Value, "DataSet1")+ Sum(Fields!FEB.Value, "DataSet1")+ Sum(Fields!MAR.Value, "DataSet1")+ Sum(Fields!APR.Value, "DataSet1")+ Sum(Fields!MAY.Value, "DataSet1")+ Sum(Fields!JUN.Value, "DataSet1")+ Sum(Fields!JUL.Value, "DataSet1")+ Sum(Fields!AUG.Value, "DataSet1")+ Sum(Fields!SEP.Value, "DataSet1")+ Sum(Fields!OCT.Value, "DataSet1")+ Sum(Fields!NOV.Value, "DataSet1")+ Sum(Fields!DEC.Value, "DataSet1")) 0.25in true division_city textbox191 308 true 3 307 true Net Cost as % to Sales 306 true =(Sum(Fields!ID1.Value, "TRANS")-Sum(Fields!JAN.Value, "trnbilling"))/Sum(Fields!JAN.Value, "DataSet1") 305 true =(Sum(Fields!ID2.Value, "TRANS")-Sum(Fields!FEB.Value, "trnbilling"))/Sum(Fields!FEB.Value, "DataSet1") 304 true =(Sum(Fields!ID3.Value, "TRANS")-Sum(Fields!MAR.Value, "trnbilling"))/Sum(Fields!MAR.Value, "DataSet1") 303 true =(Sum(Fields!ID4.Value, "TRANS")-Sum(Fields!APR.Value, "trnbilling"))/Sum(Fields!APR.Value, "DataSet1") 302 true =(Sum(Fields!ID5.Value, "TRANS")-Sum(Fields!MAY.Value, "trnbilling"))/Sum(Fields!MAY.Value, "DataSet1") 301 true =(Sum(Fields!ID6.Value, "TRANS")-Sum(Fields!JUN.Value, "trnbilling"))/Sum(Fields!JUN.Value, "DataSet1") 300 true =(Sum(Fields!ID7.Value, "TRANS")-Sum(Fields!JUL.Value, "trnbilling"))/Sum(Fields!JUL.Value, "DataSet1") 299 true =(Sum(Fields!ID8.Value, "TRANS")-Sum(Fields!AUG.Value, "trnbilling"))/Sum(Fields!AUG.Value, "DataSet1") 298 true =(Sum(Fields!ID9.Value, "TRANS")-Sum(Fields!SEP.Value, "trnbilling"))/Sum(Fields!SEP.Value, "DataSet1") 297 true =(Sum(Fields!ID10.Value, "TRANS")-Sum(Fields!OCT.Value, "trnbilling"))/Sum(Fields!OCT.Value, "DataSet1") 296 true =(Sum(Fields!ID11.Value, "TRANS")-Sum(Fields!NOV.Value, "trnbilling"))/Sum(Fields!NOV.Value, "DataSet1") 295 true =(Sum(Fields!ID12.Value, "TRANS")-Sum(Fields!DEC.Value, "trnbilling"))/Sum(Fields!DEC.Value, "DataSet1") 294 true =((sum(Fields!ID1.Value)+ sum(Fields!ID2.Value)+ sum(Fields!ID3.Value)+ sum(Fields!ID4.Value)+ sum(Fields!ID5.Value)+ sum(Fields!ID6.Value)+ sum(Fields!ID7.Value)+ sum(Fields!ID8.Value)+ sum(Fields!ID9.Value)+ sum(Fields!ID10.Value)+ sum(Fields!ID11.Value)+ sum(Fields!ID12.Value))- (Sum(Fields!JAN.Value, "trnbilling")+ Sum(Fields!FEB.Value, "trnbilling")+ Sum(Fields!MAR.Value, "trnbilling")+ Sum(Fields!APR.Value, "trnbilling")+ Sum(Fields!MAY.Value, "trnbilling")+ Sum(Fields!JUN.Value, "trnbilling")+ Sum(Fields!JUL.Value, "trnbilling")+ Sum(Fields!AUG.Value, "trnbilling")+ Sum(Fields!SEP.Value, "trnbilling")+ Sum(Fields!OCT.Value, "trnbilling")+ Sum(Fields!NOV.Value, "trnbilling")+ Sum(Fields!DEC.Value, "trnbilling")))/ (Sum(Fields!JAN.Value, "DataSet1")+ Sum(Fields!FEB.Value, "DataSet1")+ Sum(Fields!MAR.Value, "DataSet1")+ Sum(Fields!APR.Value, "DataSet1")+ Sum(Fields!MAY.Value, "DataSet1")+ Sum(Fields!JUN.Value, "DataSet1")+ Sum(Fields!JUL.Value, "DataSet1")+ Sum(Fields!AUG.Value, "DataSet1")+ Sum(Fields!SEP.Value, "DataSet1")+ Sum(Fields!OCT.Value, "DataSet1")+ Sum(Fields!NOV.Value, "DataSet1")+ Sum(Fields!DEC.Value, "DataSet1")) 0.25in true division_city textbox231 293 true textbox232 292 true textbox233 291 true textbox234 290 true textbox235 289 true textbox236 288 true textbox275 287 true textbox276 286 true textbox277 285 true textbox278 284 true textbox279 283 true textbox280 282 true textbox286 281 true textbox287 280 true textbox288 279 true textbox289 278 true textbox290 277 true 0.25in true division_city textbox27 276 true 3 textbox8 275 true Mode textbox54 274 true textbox55 273 true textbox56 272 true textbox57 271 true textbox58 270 true textbox59 269 true textbox60 268 true textbox61 267 true textbox62 266 true textbox63 265 true textbox64 264 true textbox65 263 true textbox152 262 true 0.25in
true division_city textbox30 65 true textbox31 64 true textbox32 63 true textbox33 62 true textbox34 61 true textbox35 60 true textbox36 59 true textbox37 58 true textbox38 57 true textbox39 56 true textbox40 55 true textbox41 54 true textbox114 53 true textbox115 52 true textbox116 51 true textbox117 50 true textbox160 49 true 0.25in
=Fields!carrier_type.Value
true division_city textbox3 261 true 3 carrier_type 260 true =Fields!carrier_type.Value 259 true =sum(Fields!ID1.Value) 258 true =sum(Fields!ID2.Value) 257 true =sum(Fields!ID3.Value) 256 true =sum(Fields!ID4.Value) 255 true =sum(Fields!ID5.Value) 254 true =sum(Fields!ID6.Value) 253 true =sum(Fields!ID7.Value) 252 true =sum(Fields!ID8.Value) 251 true =sum(Fields!ID9.Value) 250 true =sum(Fields!ID10.Value) 249 true =sum(Fields!ID11.Value) 248 true =sum(Fields!ID12.Value) textbox153 247 true =sum(Fields!ID1.Value)+sum(Fields!ID2.Value)+sum(Fields!ID3.Value)+sum(Fields!ID4.Value)+sum(Fields!ID5.Value)+sum(Fields!ID6.Value)+sum(Fields!ID7.Value)+sum(Fields!ID8.Value)+sum(Fields!ID9.Value)+sum(Fields!ID10.Value)+sum(Fields!ID11.Value)+sum(Fields!ID12.Value) 0.25in true carrier_type textbox51 246 true textbox67 245 true 2 textbox9 244 true Entry Type textbox70 243 true textbox71 242 true textbox72 241 true textbox73 240 true textbox74 239 true textbox75 238 true textbox76 237 true textbox77 236 true textbox78 235 true textbox79 234 true textbox80 233 true textbox81 232 true textbox154 231 true 0.25in
true carrier_type textbox118 48 true textbox119 47 true textbox120 46 true textbox121 45 true textbox122 44 true textbox123 43 true textbox124 42 true textbox125 41 true textbox126 40 true textbox127 39 true textbox128 38 true textbox129 37 true textbox130 36 true textbox131 35 true textbox132 34 true textbox133 33 true textbox159 32 true 0.25in
=iif(fields!entry_type.value="CRED" or fields!entry_type.value="FRT", "FRT",Fields!entry_type.value)
true carrier_type textbox68 230 true textbox83 229 true 2 entry_type 228 true =First(Fields!entry_type.Value) 227 true =sum(Fields!ID1.Value) 226 true =sum(Fields!ID2.Value) 225 true =sum(Fields!ID3.Value) 224 true =sum(Fields!ID4.Value) 223 true =sum(Fields!ID5.Value) 222 true =sum(Fields!ID6.Value) 221 true =sum(Fields!ID7.Value) 220 true =sum(Fields!ID8.Value) 219 true =sum(Fields!ID9.Value) 218 true =sum(Fields!ID10.Value) 217 true =sum(Fields!ID11.Value) 216 true =sum(Fields!ID12.Value) textbox155 215 true =sum(Fields!ID1.Value)+sum(Fields!ID2.Value)+sum(Fields!ID3.Value)+sum(Fields!ID4.Value)+sum(Fields!ID5.Value)+sum(Fields!ID6.Value)+sum(Fields!ID7.Value)+sum(Fields!ID8.Value)+sum(Fields!ID9.Value)+sum(Fields!ID10.Value)+sum(Fields!ID11.Value)+sum(Fields!ID12.Value) 0.25in true entry_type textbox6 214 true textbox99 213 true textbox100 212 true textbox7 211 true Carrier textbox86 210 true textbox22 209 true textbox28 208 true textbox29 207 true textbox50 206 true textbox52 205 true textbox53 204 true textbox66 203 true textbox69 202 true textbox82 201 true textbox85 200 true textbox87 199 true textbox156 198 true 0.25in
true entry_type textbox134 31 true textbox135 30 true textbox136 29 true textbox137 28 true textbox138 27 true textbox139 26 true textbox140 25 true textbox141 24 true textbox142 23 true textbox143 22 true textbox144 21 true textbox145 20 true textbox146 19 true textbox147 18 true textbox148 17 true textbox149 16 true textbox158 15 true 0.25in
18.25in
true entry_type textbox2 14 true 3 textbox4 13 true =Fields!company_name.Value ID1 12 true =Fields!ID1.Value ID2 11 true =Fields!ID2.Value ID3 10 true =Fields!ID3.Value ID4 9 true =Fields!ID4.Value ID5 8 true =Fields!ID5.Value ID6 7 true =Fields!ID6.Value ID7 6 true =Fields!ID7.Value ID8 5 true =Fields!ID8.Value ID9 4 true =Fields!ID9.Value ID10 3 true =Fields!ID10.Value ID11 2 true =Fields!ID11.Value ID12 1 true =Fields!ID12.Value textbox157 true =sum(Fields!ID1.Value)+sum(Fields!ID2.Value)+sum(Fields!ID3.Value)+sum(Fields!ID4.Value)+sum(Fields!ID5.Value)+sum(Fields!ID6.Value)+sum(Fields!ID7.Value)+sum(Fields!ID8.Value)+sum(Fields!ID9.Value)+sum(Fields!ID10.Value)+sum(Fields!ID11.Value)+sum(Fields!ID12.Value) 0.21in
4 textbox5 453 true =sum(Fields!ID1.Value)+sum(Fields!ID2.Value)+sum(Fields!ID3.Value)+sum(Fields!ID4.Value)+sum(Fields!ID5.Value)+sum(Fields!ID6.Value)+sum(Fields!ID7.Value)+sum(Fields!ID8.Value)+sum(Fields!ID9.Value)+sum(Fields!ID10.Value)+sum(Fields!ID11.Value)+sum(Fields!ID12.Value) table1_Group1 table1 Location textbox10 452 true JAN textbox11 451 true FEB textbox12 450 true MAR textbox13 449 true APR textbox14 448 true MAY textbox15 447 true JUN textbox16 446 true JUL textbox17 445 true AUG textbox18 444 true SEP textbox19 443 true OCT textbox20 442 true NOV textbox21 441 true DEC textbox150 440 true 2010 YTD 0.22in true
1in 1in 1in 1in 2.25in 1in 1in 1in 1in 1in 1in 1in 1in 1in 1in 1in 1in 6.93in
textbox174 82 true textbox175 81 true textbox176 80 true textbox177 79 true textbox192 78 true textbox193 77 true textbox195 76 true textbox196 75 true textbox197 74 true textbox223 73 true textbox226 72 true textbox198 71 true textbox227 70 true textbox225 69 true textbox228 68 true textbox229 67 true textbox230 66 true 0.25in textbox84 99 true textbox169 98 true textbox170 97 true textbox171 96 true 95 true =Fields!ID1.Value JAN 94 true FEB 93 true MAR 92 true APR 91 true MAY 90 true JUN 89 true JUL 88 true AUG 87 true SEP 86 true OCT 85 true NOV 84 true DEC 83 true 2010 YTD 0.25in textbox161 116 true textbox162 115 true textbox163 114 true textbox164 113 true Grand Total 112 true =sum(Fields!ID1.Value) 111 true =sum(Fields!ID2.Value) 110 true =sum(Fields!ID3.Value) 109 true =sum(Fields!ID4.Value) 108 true =sum(Fields!ID5.Value) 107 true =sum(Fields!ID6.Value) 106 true =sum(Fields!ID7.Value) 105 true =sum(Fields!ID8.Value) 104 true =sum(Fields!ID9.Value) 103 true =sum(Fields!ID10.Value) 102 true =sum(Fields!ID11.Value) 101 true =sum(Fields!ID12.Value) 100 true =sum(Fields!ID1.Value)+sum(Fields!ID2.Value)+sum(Fields!ID3.Value)+sum(Fields!ID4.Value)+sum(Fields!ID5.Value)+sum(Fields!ID6.Value)+sum(Fields!ID7.Value)+sum(Fields!ID8.Value)+sum(Fields!ID9.Value)+sum(Fields!ID10.Value)+sum(Fields!ID11.Value)+sum(Fields!ID12.Value) 0.25in textbox165 133 true textbox166 132 true textbox167 131 true textbox168 130 true Sales JAN 129 true =Sum(Fields!JAN.Value, "DataSet1") FEB 128 true =Sum(Fields!FEB.Value, "DataSet1") MAR 127 true =Sum(Fields!MAR.Value, "DataSet1") APR 126 true =Sum(Fields!APR.Value, "DataSet1") MAY 125 true =Sum(Fields!MAY.Value, "DataSet1") JUN 124 true =Sum(Fields!JUN.Value, "DataSet1") JUL 123 true =Sum(Fields!JUL.Value, "DataSet1") AUG 122 true =Sum(Fields!AUG.Value, "DataSet1") SEP 121 true =Sum(Fields!SEP.Value, "DataSet1") OCT 120 true =Sum(Fields!OCT.Value, "DataSet1") NOV 119 true =Sum(Fields!NOV.Value, "DataSet1") DEC 118 true =Sum(Fields!DEC.Value, "DataSet1") textbox194 117 true =Sum(Fields!JAN.Value, "DataSet1")+ Sum(Fields!FEB.Value, "DataSet1")+ Sum(Fields!MAR.Value, "DataSet1")+ Sum(Fields!APR.Value, "DataSet1")+ Sum(Fields!MAY.Value, "DataSet1")+ Sum(Fields!JUN.Value, "DataSet1")+ Sum(Fields!JUL.Value, "DataSet1")+ Sum(Fields!AUG.Value, "DataSet1")+ Sum(Fields!SEP.Value, "DataSet1")+ Sum(Fields!OCT.Value, "DataSet1")+ Sum(Fields!NOV.Value, "DataSet1")+ Sum(Fields!DEC.Value, "DataSet1") 0.25in textbox199 150 true textbox200 149 true textbox201 148 true textbox202 147 true Trans Billing JAN_1 146 true =Sum(Fields!JAN.Value, "trnbilling") FEB_1 145 true =Sum(Fields!FEB.Value, "trnbilling") MAR_1 144 true =Sum(Fields!MAR.Value, "trnbilling") APR_1 143 true =Sum(Fields!APR.Value, "trnbilling") MAY_1 142 true =Sum(Fields!MAY.Value, "trnbilling") JUN_1 141 true =Sum(Fields!JUN.Value, "trnbilling") JUL_1 140 true =Sum(Fields!JUL.Value, "trnbilling") AUG_1 139 true =Sum(Fields!AUG.Value, "trnbilling") SEP_1 138 true =Sum(Fields!SEP.Value, "trnbilling") OCT_1 137 true =Sum(Fields!OCT.Value, "trnbilling") NOV_1 136 true =Sum(Fields!NOV.Value, "trnbilling") DEC_1 135 true =Sum(Fields!DEC.Value, "trnbilling") textbox215 134 true =Sum(Fields!JAN.Value, "trnbilling")+ Sum(Fields!FEB.Value, "trnbilling")+ Sum(Fields!MAR.Value, "trnbilling")+ Sum(Fields!APR.Value, "trnbilling")+ Sum(Fields!MAY.Value, "trnbilling")+ Sum(Fields!JUN.Value, "trnbilling")+ Sum(Fields!JUL.Value, "trnbilling")+ Sum(Fields!AUG.Value, "trnbilling")+ Sum(Fields!SEP.Value, "trnbilling")+ Sum(Fields!OCT.Value, "trnbilling")+ Sum(Fields!NOV.Value, "trnbilling")+ Sum(Fields!DEC.Value, "trnbilling") 0.25in textbox203 167 true textbox204 166 true textbox205 165 true textbox206 164 true textbox220 163 true textbox219 162 true textbox218 161 true textbox217 160 true textbox216 159 true textbox214 158 true textbox213 157 true textbox212 156 true textbox211 155 true textbox210 154 true textbox207 153 true textbox208 152 true textbox209 151 true 0.25in textbox238 182 true 3 textbox239 181 true Gross Cost as % to Sales textbox242 180 true =Sum(Fields!ID1.Value, "TRANS")/Sum(Fields!JAN.Value, "DataSet1") 179 true =Sum(Fields!ID2.Value, "TRANS")/Sum(Fields!FEB.Value, "DataSet1") textbox244 178 true =Sum(Fields!ID3.Value, "TRANS")/Sum(Fields!MAR.Value, "DataSet1") textbox245 177 true =Sum(Fields!ID4.Value, "TRANS")/Sum(Fields!APR.Value, "DataSet1") textbox246 176 true =Sum(Fields!ID5.Value, "TRANS")/Sum(Fields!MAY.Value, "DataSet1") textbox247 175 true =Sum(Fields!ID6.Value, "TRANS")/Sum(Fields!JUN.Value, "DataSet1") textbox248 174 true =Sum(Fields!ID7.Value, "TRANS")/Sum(Fields!JUL.Value, "DataSet1") textbox249 173 true =Sum(Fields!ID8.Value, "TRANS")/Sum(Fields!AUG.Value, "DataSet1") textbox250 172 true =Sum(Fields!ID9.Value, "TRANS")/Sum(Fields!SEP.Value, "DataSet1") textbox251 171 true =Sum(Fields!ID10.Value, "TRANS")/Sum(Fields!OCT.Value, "DataSet1") textbox252 170 true =Sum(Fields!ID11.Value, "TRANS")/Sum(Fields!NOV.Value, "DataSet1") textbox253 169 true =Sum(Fields!ID12.Value, "TRANS")/Sum(Fields!DEC.Value, "DataSet1") textbox173 168 true =(sum(Fields!ID1.Value)+ sum(Fields!ID2.Value)+ sum(Fields!ID3.Value)+ sum(Fields!ID4.Value)+ sum(Fields!ID5.Value)+ sum(Fields!ID6.Value)+ sum(Fields!ID7.Value)+ sum(Fields!ID8.Value)+ sum(Fields!ID9.Value)+ sum(Fields!ID10.Value)+ sum(Fields!ID11.Value)+ sum(Fields!ID12.Value))/ (Sum(Fields!JAN.Value, "DataSet1")+ Sum(Fields!FEB.Value, "DataSet1")+ Sum(Fields!MAR.Value, "DataSet1")+ Sum(Fields!APR.Value, "DataSet1")+ Sum(Fields!MAY.Value, "DataSet1")+ Sum(Fields!JUN.Value, "DataSet1")+ Sum(Fields!JUL.Value, "DataSet1")+ Sum(Fields!AUG.Value, "DataSet1")+ Sum(Fields!SEP.Value, "DataSet1")+ Sum(Fields!OCT.Value, "DataSet1")+ Sum(Fields!NOV.Value, "DataSet1")+ Sum(Fields!DEC.Value, "DataSet1")) 0.25in textbox221 197 true 3 textbox222 196 true Net Cost as % to Sales 195 true =(Sum(Fields!ID1.Value, "TRANS")-Sum(Fields!JAN.Value, "trnbilling"))/Sum(Fields!JAN.Value, "DataSet1") 194 true =(Sum(Fields!ID2.Value, "TRANS")-Sum(Fields!FEB.Value, "trnbilling"))/Sum(Fields!FEB.Value, "DataSet1") 193 true =(Sum(Fields!ID3.Value, "TRANS")-Sum(Fields!MAR.Value, "trnbilling"))/Sum(Fields!MAR.Value, "DataSet1") 192 true =(Sum(Fields!ID4.Value, "TRANS")-Sum(Fields!APR.Value, "trnbilling"))/Sum(Fields!APR.Value, "DataSet1") 191 true =(Sum(Fields!ID5.Value, "TRANS")-Sum(Fields!MAY.Value, "trnbilling"))/Sum(Fields!MAY.Value, "DataSet1") 190 true =(Sum(Fields!ID6.Value, "TRANS")-Sum(Fields!JUN.Value, "trnbilling"))/Sum(Fields!JUN.Value, "DataSet1") 189 true =(Sum(Fields!ID7.Value, "TRANS")-Sum(Fields!JUL.Value, "trnbilling"))/Sum(Fields!JUL.Value, "DataSet1") 188 true =(Sum(Fields!ID8.Value, "TRANS")-Sum(Fields!AUG.Value, "trnbilling"))/Sum(Fields!AUG.Value, "DataSet1") 187 true =(Sum(Fields!ID9.Value, "TRANS")-Sum(Fields!SEP.Value, "trnbilling"))/Sum(Fields!SEP.Value, "DataSet1") 186 true =(Sum(Fields!ID10.Value, "TRANS")-Sum(Fields!OCT.Value, "trnbilling"))/Sum(Fields!OCT.Value, "DataSet1") 185 true =(Sum(Fields!ID11.Value, "TRANS")-Sum(Fields!NOV.Value, "trnbilling"))/Sum(Fields!NOV.Value, "DataSet1") 184 true =(Sum(Fields!ID12.Value, "TRANS")-Sum(Fields!DEC.Value, "trnbilling"))/Sum(Fields!DEC.Value, "DataSet1") textbox172 183 true =((sum(Fields!ID1.Value)+ sum(Fields!ID2.Value)+ sum(Fields!ID3.Value)+ sum(Fields!ID4.Value)+ sum(Fields!ID5.Value)+ sum(Fields!ID6.Value)+ sum(Fields!ID7.Value)+ sum(Fields!ID8.Value)+ sum(Fields!ID9.Value)+ sum(Fields!ID10.Value)+ sum(Fields!ID11.Value)+ sum(Fields!ID12.Value))- (Sum(Fields!JAN.Value, "trnbilling")+ Sum(Fields!FEB.Value, "trnbilling")+ Sum(Fields!MAR.Value, "trnbilling")+ Sum(Fields!APR.Value, "trnbilling")+ Sum(Fields!MAY.Value, "trnbilling")+ Sum(Fields!JUN.Value, "trnbilling")+ Sum(Fields!JUL.Value, "trnbilling")+ Sum(Fields!AUG.Value, "trnbilling")+ Sum(Fields!SEP.Value, "trnbilling")+ Sum(Fields!OCT.Value, "trnbilling")+ Sum(Fields!NOV.Value, "trnbilling")+ Sum(Fields!DEC.Value, "trnbilling")))/ (Sum(Fields!JAN.Value, "DataSet1")+ Sum(Fields!FEB.Value, "DataSet1")+ Sum(Fields!MAR.Value, "DataSet1")+ Sum(Fields!APR.Value, "DataSet1")+ Sum(Fields!MAY.Value, "DataSet1")+ Sum(Fields!JUN.Value, "DataSet1")+ Sum(Fields!JUL.Value, "DataSet1")+ Sum(Fields!AUG.Value, "DataSet1")+ Sum(Fields!SEP.Value, "DataSet1")+ Sum(Fields!OCT.Value, "DataSet1")+ Sum(Fields!NOV.Value, "DataSet1")+ Sum(Fields!DEC.Value, "DataSet1")) 0.25in
9.625in en-US 1in