[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 15 < SKIP 500 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Barnes, Emily, G,15996 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Howard, Morgan, T,22971 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Griffin, Seth, R,17585 | 164.46 | 0.00 | 0.00 | 0.00 | 164.46 |
| Ross, Anna, D,15494 | 275.44 | 0.00 | 0.00 | 0.00 | 275.44 |
| Murphy, Brianna, K,28342 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Allen, Jack, M,29137 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Evans, Connor, J,15402 | 131.55 | 0.00 | 0.00 | 0.00 | 131.55 |
| Luo, Donna, E,24805 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Moreno, Lance, A,29229 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Howard, Isaiah,25981 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Carter, Elijah,21618 | 2611.07 | 0.00 | 0.00 | 2611.07 | 0.00 |
| Murphy, Eduardo, S,16124 | 614.45 | 0.00 | 0.00 | 0.00 | 614.45 |
| Griffin, Xavier,22877 | 5962.34 | 0.00 | 3578.27 | 0.00 | 2384.07 |
| Nelson, James, L,24525 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Yuan, Brendan, S,24744 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Baker, Robert, A,27300 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Flores, Arianna,21727 | 4132.24 | 3578.27 | 0.00 | 0.00 | 553.97 |
| Barnes, Alexandra, P,22268 | 6031.31 | 0.00 | 3578.27 | 0.00 | 2453.04 |
| Mitchell, Xavier, L,26533 | 1629.41 | 0.00 | 0.00 | 1000.44 | 628.97 |
| Ward, Cole,21490 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Miller, Joseph, A,22713 | 4148.19 | 0.00 | 3578.27 | 0.00 | 569.92 |
| Bell, Garrett, J,14265 | 161.23 | 0.00 | 0.00 | 0.00 | 161.23 |
| Perez, Angel, S,21336 | 2628.35 | 0.00 | 0.00 | 2071.42 | 556.93 |
| Rodriguez, Joshua, A,23511 | 4843.11 | 0.00 | 3578.27 | 0.00 | 1264.84 |
| Johnson, James,23498 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Peterson, Kaitlyn, S,13706 | 2337.27 | 0.00 | 0.00 | 0.00 | 2337.27 |
| Chen, Luis, G,21252 | 94.45 | 0.00 | 0.00 | 0.00 | 94.45 |
| Russell, Melanie, B,15478 | 182.83 | 0.00 | 0.00 | 38.88 | 143.95 |
| Robinson, Madison, W,18377 | 2394.97 | 0.00 | 0.00 | 0.00 | 2394.97 |
| Zhao, Karen, L,25408 | 2735.53 | 0.00 | 2181.56 | 0.00 | 553.97 |
| Martin, Nicholas,23362 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Thomas, Zachary, D,28045 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Hughes, Antonio, P,15913 | 712.27 | 0.00 | 0.00 | 0.00 | 712.27 |
| Ye, Alisha, J,22008 | 4141.23 | 0.00 | 3578.27 | 0.00 | 562.96 |
| Jai, Adam,25095 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Powell, Jocelyn, A,21658 | 2641.89 | 0.00 | 0.00 | 2071.42 | 570.47 |
| Gill, Beth,19997 | 5814.98 | 0.00 | 3374.99 | 0.00 | 2439.99 |
| Campbell, Adam, A,21400 | 2688.89 | 0.00 | 0.00 | 2071.42 | 617.47 |
| Wood, Gabrielle, S,28787 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Torres, Dalton,23503 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Parker, Jeremy,28668 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| She, Shawn, J,16902 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Ramirez, Melanie, V,16363 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| Hall, Grace, A,20189 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Evans, Kaylee,19642 | 133.54 | 0.00 | 0.00 | 0.00 | 133.54 |
| Turner, Timothy, C,14641 | 119.86 | 0.00 | 0.00 | 0.00 | 119.86 |
| Johnson, Madison, L,15530 | 846.46 | 0.00 | 0.00 | 0.00 | 846.46 |
| Long, Sarah,17372 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Foster, Abigail,19823 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Young, Adam,12984 | 200.20 | 0.00 | 0.00 | 37.29 | 162.91 |
| Henderson, Abigail,20441 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gonzalez, Jordan,15157 | 213.94 | 0.00 | 0.00 | 123.98 | 89.96 |
| Flores, Julian,15846 | 4943.32 | 0.00 | 0.00 | 0.00 | 4943.32 |
| Sanders, Megan, A,15376 | 136.24 | 0.00 | 0.00 | 0.00 | 136.24 |
| Thomas, William, A,21614 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Washington, Vanessa,23819 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Washington, Miranda,15201 | 4793.02 | 0.00 | 0.00 | 0.00 | 4793.02 |
| Collins, Eduardo,13987 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Washington, Alexandra, E,15498 | 256.52 | 0.00 | 0.00 | 0.00 | 256.52 |
| Gray, Seth, M,20087 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Shan, Logan,18677 | 60.96 | 0.00 | 0.00 | 29.99 | 30.97 |
| Perry, Melissa,22128 | 4142.23 | 0.00 | 3578.27 | 0.00 | 563.96 |
Generated 2025-12-24 06:04:50.420 UTC