[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 1434
73 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alexander, Logan, E,19116 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Washington, Aaron, L,24649 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Stewart, Cindy,14496 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Thomas, Edward, E,19147 | 133.71 | 0.00 | 0.00 | 0.00 | 133.71 |
| Roberts, Carlos,23196 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Patterson, Abigail, H,14478 | 4795.01 | 0.00 | 0.00 | 0.00 | 4795.01 |
| Hughes, Luis,13084 | 1798.96 | 0.00 | 0.00 | 0.00 | 1798.96 |
| Evans, Elijah, S,25884 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Harris, Jeremiah, B,17023 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Cooper, Brian, L,13760 | 128.84 | 0.00 | 0.00 | 0.00 | 128.84 |
| Hayes, Gavin, A,19400 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Adams, Jennifer,15362 | 4745.02 | 0.00 | 0.00 | 0.00 | 4745.02 |
| Stewart, Melissa,25173 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Moore, Jessica, J,20085 | 76.76 | 0.00 | 0.00 | 0.00 | 76.76 |
| Henderson, Olivia,18859 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Patterson, Aaron, W,19113 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Lee, John,19801 | 193.01 | 0.00 | 0.00 | 0.00 | 193.01 |
| Bradley, Nathaniel,16955 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Adams, Carlos,19822 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Edwards, Logan,25002 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| King, Sara,22354 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ross, David, M,17143 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Cox, Arianna, D,18927 | 89.25 | 0.00 | 0.00 | 0.00 | 89.25 |
| Bell, Brooke, H,23253 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lewis, Morgan,17410 | 168.74 | 0.00 | 0.00 | 0.00 | 168.74 |
| Brown, Anna,16247 | 95.82 | 0.00 | 0.00 | 0.00 | 95.82 |
| Parker, Amanda,18081 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Wang, Zachary,22144 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Moreno, Meredith, D,22285 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Sanchez, Martin, E,21631 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Morris, Abigail, C,28776 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Taylor, Ryan,17025 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Wilson, Hunter, R,27230 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Henderson, Caroline,20082 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Stewart, Julia, L,12902 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Perez, Jordan, A,29267 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Russell, Megan,16220 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Adams, Mackenzie, A,14640 | 812.42 | 0.00 | 0.00 | 0.00 | 812.42 |
| Hall, Charles,23476 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gutierrez, Jerome,12783 | 2420.46 | 0.00 | 0.00 | 0.00 | 2420.46 |
| Scott, Gabrielle,27061 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Thompson, Isabella,18756 | 128.41 | 0.00 | 0.00 | 0.00 | 128.41 |
| Brown, Samantha, G,25147 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jackson, Hannah, G,13143 | 2404.97 | 0.00 | 0.00 | 0.00 | 2404.97 |
| Nelson, Jennifer,17147 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Collins, Alex, S,28781 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Bryant, Brittany,22545 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Hughes, Jasmine,27628 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martinez, Kristina, S,21345 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Scott, Sean, F,24755 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Clark, Miguel, D,16987 | 2414.99 | 0.00 | 0.00 | 0.00 | 2414.99 |
| Evans, Jesse,21916 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rivera, Rachel, S,28996 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Morgan, Marcus, W,28968 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Wilson, Madison, H,19828 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Bailey, Alexandria, V,13209 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Evans, Alexandra,24322 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Gutierrez, Neil, L,21489 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sanchez, Stephanie,17867 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Wilson, Emily,17400 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Butler, Jonathan,26180 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanders, Zoe, L,24825 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hall, Grace, A,20189 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Foster, Alyssa, I,14875 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Parker, Kaylee, M,27738 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Bailey, Maria, C,19150 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Raman, Emmanuel, W,19554 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Bryant, Dakota, L,17613 | 2401.95 | 0.00 | 0.00 | 0.00 | 2401.95 |
| Stewart, Alexandria,17476 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Malhotra, Brenda,13391 | 2405.47 | 0.00 | 0.00 | 0.00 | 2405.47 |
| Diaz, Gabrielle,14893 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Robinson, Madison, W,18377 | 2394.97 | 0.00 | 0.00 | 0.00 | 2394.97 |
| _SUM | 1806517.50 | 14313.08 | 487820.91 | 254117.23 | 1050266.28 |
Generated 2026-01-04 03:14:50.945 UTC