[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 188 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Perez, Amber, D,13318 | 214.26 | 0.00 | 0.00 | 0.00 | 214.26 |
| Peterson, Steven, L,23449 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Diaz, Ryan, J,16910 | 141.96 | 0.00 | 0.00 | 0.00 | 141.96 |
| Patterson, Eric, A,27384 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| White, James,25331 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hill, Blake,11748 | 131.54 | 0.00 | 0.00 | 0.00 | 131.54 |
| Hayes, Arianna,25991 | 2845.52 | 0.00 | 0.00 | 2181.56 | 663.96 |
| Allen, Allison, A,19757 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Mehta, Rebekah, B,27419 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Carter, Katherine,11861 | 286.30 | 0.00 | 0.00 | 0.00 | 286.30 |
| Hall, Amber,20106 | 131.95 | 0.00 | 0.00 | 0.00 | 131.95 |
| Ruiz, Carrie, D,18644 | 135.44 | 0.00 | 0.00 | 0.00 | 135.44 |
| Martinez, Joseph, E,29214 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Smith, Samuel, D,23083 | 49.90 | 0.00 | 0.00 | 0.00 | 49.90 |
| Walker, Jasmine,13460 | 4693.04 | 0.00 | 0.00 | 0.00 | 4693.04 |
| White, Edward, J,15847 | 205.46 | 0.00 | 0.00 | 0.00 | 205.46 |
| Garcia, Isabella,18382 | 204.94 | 0.00 | 0.00 | 0.00 | 204.94 |
| Coleman, Benjamin, F,23486 | 5343.23 | 0.00 | 3578.27 | 0.00 | 1764.96 |
| Ware, Dennis, L,23725 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Gonzales, Jose,22014 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ramos, Derrick,18449 | 100.94 | 0.00 | 0.00 | 0.00 | 100.94 |
| Martinez, Grace, M,17385 | 208.69 | 0.00 | 0.00 | 0.00 | 208.69 |
| Flores, Isabelle, A,15526 | 188.32 | 0.00 | 0.00 | 0.00 | 188.32 |
| Perry, Samuel,18811 | 100.96 | 0.00 | 0.00 | 0.00 | 100.96 |
| Johnson, Xavier, R,23255 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Flores, Stephanie,25992 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Nelson, Henry,19394 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Martin, Brianna, M,23583 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Gray, Seth, M,20087 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Gray, Cody, C,14459 | 4775.01 | 0.00 | 0.00 | 0.00 | 4775.01 |
| Nelson, Jose,19217 | 185.02 | 0.00 | 0.00 | 0.00 | 185.02 |
| Bennett, Jennifer, G,13708 | 123.94 | 0.00 | 0.00 | 0.00 | 123.94 |
| Sanchez, Mariah, R,19220 | 66.65 | 0.00 | 0.00 | 0.00 | 66.65 |
| Sanders, Allison, B,18852 | 268.25 | 0.00 | 0.00 | 0.00 | 268.25 |
| Foster, Edward, R,18355 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Ramirez, Gabrielle, H,16000 | 4813.95 | 0.00 | 0.00 | 0.00 | 4813.95 |
| Scott, Sean, F,24755 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martin, Xavier,22233 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Howard, Isaiah,25981 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Malhotra, Kristi, S,15175 | 4850.33 | 0.00 | 0.00 | 0.00 | 4850.33 |
| Bailey, Richard, N,22050 | 4160.53 | 0.00 | 3578.27 | 0.00 | 582.26 |
| Bryant, Isabelle,23397 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Powell, Ian,26085 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Perry, Benjamin,29165 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Peterson, Isabella,28080 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Moore, Jessica, J,20085 | 76.76 | 0.00 | 0.00 | 0.00 | 76.76 |
| Rivera, Allison, M,13751 | 224.91 | 0.00 | 0.00 | 0.00 | 224.91 |
| Sanders, Alexa, E,21741 | 4127.25 | 3578.27 | 0.00 | 0.00 | 548.98 |
| Mohamed, Samantha, A,29277 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| White, Nicole,16731 | 155.91 | 0.00 | 0.00 | 0.00 | 155.91 |
| Perez, Charles,26693 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Garcia, Patricia,11651 | 226.43 | 0.00 | 0.00 | 0.00 | 226.43 |
| Foster, Jessica,26069 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Hughes, Caroline, C,28302 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Gonzales, Kayla,21494 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Kelly, Trinity,26095 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Lewis, Brianna, H,14282 | 166.24 | 0.00 | 0.00 | 0.00 | 166.24 |
| Roberts, Wyatt,15900 | 699.97 | 0.00 | 0.00 | 0.00 | 699.97 |
| Simmons, Adam,25327 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Robinson, Dylan, L,14724 | 81.53 | 0.00 | 0.00 | 0.00 | 81.53 |
| Allen, Sean, L,12097 | 159.22 | 0.00 | 0.00 | 0.00 | 159.22 |
| Thomas, Seth,14567 | 161.28 | 0.00 | 0.00 | 96.07 | 65.21 |
| Gonzalez, Logan, J,17483 | 64.50 | 0.00 | 0.00 | 0.00 | 64.50 |
| Powell, Katherine, C,14574 | 177.60 | 0.00 | 0.00 | 0.00 | 177.60 |
| Evans, Connor, J,15402 | 131.55 | 0.00 | 0.00 | 0.00 | 131.55 |
| Henderson, Jordan, C,22996 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Malhotra, Gerald, A,28773 | 127.95 | 0.00 | 0.00 | 0.00 | 127.95 |
| Parker, James,11808 | 610.19 | 0.00 | 0.00 | 0.00 | 610.19 |
| Hayes, Luis,12880 | 200.73 | 0.00 | 0.00 | 0.00 | 200.73 |
| Watson, Cole, A,21768 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Taylor, Madison, A,11802 | 215.29 | 0.00 | 0.00 | 0.00 | 215.29 |
| Moreno, Meredith, D,22285 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Roberts, Thomas, J,21939 | 4163.24 | 0.00 | 3578.27 | 0.00 | 584.97 |
| Price, Miranda,26629 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Long, Natalie,14363 | 192.34 | 0.00 | 0.00 | 0.00 | 192.34 |
| Russell, Samantha,11211 | 723.56 | 0.00 | 0.00 | 64.47 | 659.09 |
| Zukowski, Jake,22058 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Ross, Isabelle, D,18554 | 155.45 | 0.00 | 0.00 | 0.00 | 155.45 |
| Perez, Sydney, C,22117 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Gonzales, Jasmine, C,18392 | 2342.93 | 0.00 | 0.00 | 0.00 | 2342.93 |
| Sanchez, Alex, K,13101 | 4736.03 | 0.00 | 0.00 | 0.00 | 4736.03 |
| Morris, Abigail, C,28776 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Perry, Melissa,22128 | 4142.23 | 0.00 | 3578.27 | 0.00 | 563.96 |
| Reed, Bryan,18884 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| She, Martha, E,22251 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Lee, Emma,16948 | 176.43 | 0.00 | 0.00 | 0.00 | 176.43 |
| Flores, Emily,13206 | 163.19 | 0.00 | 0.00 | 0.00 | 163.19 |
| Washington, Christian, R,26686 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ross, Natalie, J,12916 | 261.22 | 0.00 | 0.00 | 0.00 | 261.22 |
| Roberts, Mason, D,11176 | 1106.68 | 0.00 | 0.00 | 71.58 | 1035.10 |
| Green, Marcus, C,15974 | 208.41 | 0.00 | 0.00 | 0.00 | 208.41 |
| Patterson, Eduardo,11142 | 866.81 | 0.00 | 0.00 | 0.00 | 866.81 |
| Gray, Jesse,14626 | 197.04 | 0.00 | 0.00 | 0.00 | 197.04 |
| Stewart, Hailey,22903 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Long, Jordan,19988 | 4555.47 | 0.00 | 3399.99 | 0.00 | 1155.48 |
| Bryant, Isabella, L,22995 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| James, Jeremiah, S,11661 | 287.70 | 0.00 | 0.00 | 0.00 | 287.70 |
| Sanchez, Lucas, L,23351 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Torres, Haley, W,23283 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Patterson, Nicole,19729 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Powell, Jonathan,23858 | 4712.74 | 0.00 | 3578.27 | 0.00 | 1134.47 |
| Jackson, Joseph, R,23592 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Garcia, Cameron,18641 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Rodriguez, Joshua, A,23511 | 4843.11 | 0.00 | 3578.27 | 0.00 | 1264.84 |
| Sanders, Melissa, R,24284 | 4837.34 | 0.00 | 3578.27 | 0.00 | 1259.07 |
| Chander, Wayne, S,24344 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Wright, Robert, C,15889 | 4848.03 | 0.00 | 0.00 | 0.00 | 4848.03 |
| Hughes, Luke, I,27014 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Hughes, Zachary,12203 | 157.91 | 0.00 | 0.00 | 0.00 | 157.91 |
| Price, Isabelle,20182 | 5749.97 | 0.00 | 3374.99 | 0.00 | 2374.98 |
| Allen, Amanda,22353 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Long, Morgan, H,21352 | 2625.39 | 0.00 | 0.00 | 2071.42 | 553.97 |
| Miller, Alexis, A,12196 | 124.93 | 0.00 | 0.00 | 0.00 | 124.93 |
| Morgan, Timothy,14633 | 242.50 | 0.00 | 0.00 | 0.00 | 242.50 |
| Moore, Matthew, W,13267 | 109.95 | 0.00 | 0.00 | 0.00 | 109.95 |
| Chen, James, D,11641 | 303.20 | 0.00 | 0.00 | 21.49 | 281.71 |
| Young, Kaitlyn, J,25062 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Murphy, Shelby,24489 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Watson, Olivia, S,13860 | 93.85 | 0.00 | 0.00 | 14.98 | 78.87 |
| Anderson, Emma, A,18580 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Kelly, Haley,15511 | 128.56 | 0.00 | 0.00 | 0.00 | 128.56 |
| Flores, Emma, P,15543 | 180.94 | 0.00 | 0.00 | 0.00 | 180.94 |
| Morgan, Jada, A,11520 | 702.99 | 0.00 | 0.00 | 0.00 | 702.99 |
| Martinez, Andrew, C,11530 | 523.81 | 0.00 | 0.00 | 78.48 | 445.33 |
Generated 2025-12-23 07:46:50.499 UTC