[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Green, Marcus, C,15974 | 208.41 | 0.00 | 0.00 | 91.95 | 116.46 |
| Powell, Jonathan,23858 | 4712.74 | 0.00 | 3578.27 | 1134.47 | 0.00 |
| Powell, Jasmine, A,11505 | 846.77 | 0.00 | 0.00 | 105.05 | 741.72 |
| Bennett, Antonio, C,11631 | 707.50 | 0.00 | 0.00 | 216.34 | 491.16 |
| Perry, Samuel,18811 | 100.96 | 0.00 | 0.00 | 100.96 | 0.00 |
| Johnson, Xavier, R,23255 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Ward, Devin, J,15378 | 170.91 | 0.00 | 0.00 | 76.95 | 93.96 |
| Flores, Devin, A,15559 | 172.04 | 0.00 | 0.00 | 86.56 | 85.48 |
| Hernandez, Haley, L,11769 | 478.95 | 0.00 | 0.00 | 0.00 | 478.95 |
| Smith, Austin,13707 | 149.05 | 0.00 | 0.00 | 0.00 | 149.05 |
| White, Greg, C,17403 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Patterson, Hailey, I,11223 | 1155.90 | 0.00 | 0.00 | 267.62 | 888.28 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 86.48 | 912.74 |
| Peterson, Alex, M,13423 | 132.90 | 0.00 | 0.00 | 0.00 | 132.90 |
| Gonzalez, Jackson, S,14480 | 194.94 | 0.00 | 0.00 | 0.00 | 194.94 |
| Scott, Kaitlyn, A,12159 | 218.91 | 0.00 | 0.00 | 133.96 | 84.95 |
| Campbell, Natalie, L,11512 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| She, Alisha, G,24757 | 4343.59 | 0.00 | 3578.27 | 0.00 | 765.32 |
| Taylor, Edward, C,17442 | 319.88 | 0.00 | 0.00 | 230.90 | 88.98 |
| Rubio, Jaime, R,15007 | 209.83 | 0.00 | 0.00 | 49.97 | 159.86 |
| Jackson, Brianna,15377 | 97.91 | 0.00 | 0.00 | 74.98 | 22.93 |
| Bennett, Jennifer, G,13708 | 123.94 | 0.00 | 0.00 | 68.97 | 54.97 |
| Sanchez, Mariah, R,19220 | 66.65 | 0.00 | 0.00 | 38.88 | 27.77 |
| Taylor, Madison, A,11802 | 215.29 | 0.00 | 0.00 | 127.96 | 87.33 |
| Flores, Morgan,19817 | 118.94 | 0.00 | 0.00 | 39.98 | 78.96 |
| Griffin, Jason, L,11200 | 1267.11 | 0.00 | 0.00 | 391.08 | 876.03 |
| Ross, Anna, D,15494 | 275.44 | 0.00 | 0.00 | 29.99 | 245.45 |
| Evans, Jordan,29209 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Blue, Paige,21703 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Prasad, Donald,15413 | 318.92 | 0.00 | 0.00 | 123.98 | 194.94 |
| Flores, Emily,13206 | 163.19 | 0.00 | 0.00 | 69.97 | 93.22 |
| Ramirez, Garrett, M,17388 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| James, Zoe, R,14611 | 304.55 | 0.00 | 0.00 | 0.00 | 304.55 |
| James, Maria,16243 | 91.97 | 0.00 | 0.00 | 69.99 | 21.98 |
| Diaz, Kaitlyn, B,29230 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Hill, Haley, J,16103 | 3142.32 | 0.00 | 0.00 | 792.34 | 2349.98 |
| Peterson, Isabella,28080 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Patterson, Eduardo,11142 | 866.81 | 0.00 | 0.00 | 72.26 | 794.55 |
| She, Kenneth,16096 | 212.01 | 0.00 | 0.00 | 80.96 | 131.05 |
| Harris, Samuel, M,24771 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| James, Jeremiah, S,11661 | 287.70 | 0.00 | 0.00 | 0.00 | 287.70 |
| Roberts, Rebecca,28000 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Thomas, Zachary, D,28045 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Richardson, Charles, I,12114 | 4719.02 | 0.00 | 0.00 | 2325.96 | 2393.06 |
| Mohamed, Samantha, A,29277 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Phillips, Mackenzie,12444 | 228.43 | 0.00 | 0.00 | 113.96 | 114.47 |
| Garcia, Patricia,11651 | 226.43 | 0.00 | 0.00 | 99.97 | 126.46 |
| Foster, Jessica,26069 | 51.46 | 0.00 | 0.00 | 51.46 | 0.00 |
| Hughes, Caroline, C,28302 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Alexander, Taylor,17482 | 146.94 | 0.00 | 0.00 | 76.97 | 69.97 |
| Garcia, Rachel, L,12986 | 4823.01 | 0.00 | 0.00 | 2369.97 | 2453.04 |
| Moreno, Lance, A,29229 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sanders, Allison, B,18852 | 268.25 | 0.00 | 0.00 | 0.00 | 268.25 |
| Gutierrez, Neil, L,21489 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sanders, Sean,14341 | 175.15 | 0.00 | 0.00 | 0.00 | 175.15 |
| Henderson, Ashley,11185 | 1381.37 | 0.00 | 0.00 | 232.80 | 1148.57 |
| Jai, Luis, A,18320 | 185.92 | 0.00 | 0.00 | 0.00 | 185.92 |
| Flores, Hannah,19525 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Davis, Marcus, T,17337 | 123.91 | 0.00 | 0.00 | 86.95 | 36.96 |
| Richardson, Erin, R,16331 | 88.85 | 0.00 | 0.00 | 38.88 | 49.97 |
| Peterson, Mason, A,18570 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Sharma, Kathryn,20740 | 140.94 | 0.00 | 0.00 | 0.00 | 140.94 |
Generated 2025-11-03 16:30:28.324 UTC