[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 750 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Richardson, Olivia,20468 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Thompson, Blake,18390 | 141.96 | 0.00 | 0.00 | 0.00 | 141.96 |
| Watson, Olivia, S,13860 | 93.85 | 0.00 | 0.00 | 14.98 | 78.87 |
| Wilson, Christian,27085 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Griffin, Isabelle,24986 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Serrano, Albert, E,13328 | 4708.02 | 0.00 | 0.00 | 0.00 | 4708.02 |
| Bell, Eduardo,27101 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Collins, Xavier, C,16646 | 250.91 | 0.00 | 0.00 | 0.00 | 250.91 |
| Washington, Elijah, L,25016 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lal, Robert, L,14084 | 138.68 | 0.00 | 0.00 | 0.00 | 138.68 |
| Morris, Seth,18959 | 2341.46 | 0.00 | 0.00 | 0.00 | 2341.46 |
| Walker, Emma, M,25209 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Diaz, Angela, K,27259 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Alexander, Thomas,20760 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Stewart, Grace, H,24773 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Jai, Connor, D,27253 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Suri, Carolyn, S,12972 | 175.71 | 0.00 | 0.00 | 0.00 | 175.71 |
| Evans, Dalton, E,12710 | 4774.04 | 0.00 | 0.00 | 0.00 | 4774.04 |
| Diaz, Alyssa,13908 | 4715.33 | 0.00 | 0.00 | 0.00 | 4715.33 |
| Green, Chloe, J,14658 | 92.82 | 0.00 | 0.00 | 0.00 | 92.82 |
| Collins, Nathan, F,19704 | 1143.46 | 0.00 | 0.00 | 0.00 | 1143.46 |
| Alexander, Nathan, A,18795 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Robinson, Julia,28121 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Reed, Catherine, M,20380 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Barnes, Jeremy,21446 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Zhang, Nathan, L,29104 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Ward, Ian,12056 | 213.92 | 0.00 | 0.00 | 0.00 | 213.92 |
| Griffin, Thomas, J,19015 | 125.43 | 0.00 | 0.00 | 0.00 | 125.43 |
| Wilson, Grace,17539 | 205.92 | 0.00 | 0.00 | 0.00 | 205.92 |
| Scott, Gabrielle,27061 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Moore, Jonathan,20478 | 96.46 | 0.00 | 0.00 | 0.00 | 96.46 |
| Butler, Isabel,16241 | 126.96 | 0.00 | 0.00 | 0.00 | 126.96 |
| Phillips, Miguel,20498 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Jai, Edwin,16921 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Williams, Edward, D,14274 | 121.56 | 0.00 | 0.00 | 0.00 | 121.56 |
| Zeng, Jake,18054 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Harris, Matthew,14330 | 806.76 | 0.00 | 0.00 | 0.00 | 806.76 |
| Smith, Alexandra,28292 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Simmons, Dakota, T,14110 | 819.46 | 0.00 | 0.00 | 0.00 | 819.46 |
| Moreno, Marie,27739 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Cox, Katelyn, B,21742 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Morgan, Angela,24665 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Barnes, Emily, G,15996 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Hall, Amber,20106 | 131.95 | 0.00 | 0.00 | 0.00 | 131.95 |
| Green, Blake, P,11719 | 287.20 | 0.00 | 0.00 | 0.00 | 287.20 |
| Stewart, Olivia, B,18749 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Johnson, Anthony, D,27022 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| James, Christina,17409 | 219.92 | 0.00 | 0.00 | 0.00 | 219.92 |
| Sanders, Stephanie, A,19746 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Robinson, Alyssa, C,23134 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martinez, Matthew, L,16009 | 170.45 | 0.00 | 0.00 | 0.00 | 170.45 |
| Evans, Gabriel,23487 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Bradley, Alexandria,17691 | 1779.47 | 0.00 | 0.00 | 0.00 | 1779.47 |
| Clark, William,29021 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Martinez, Kristina, S,21345 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Ross, Elizabeth, E,14118 | 4741.34 | 0.00 | 0.00 | 0.00 | 4741.34 |
| Jackson, Hannah, G,13143 | 2404.97 | 0.00 | 0.00 | 0.00 | 2404.97 |
| Scott, Sean, F,24755 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Brown, Anthony, J,19399 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Foster, Samuel, M,18523 | 160.94 | 0.00 | 0.00 | 0.00 | 160.94 |
| Brown, Morgan,29197 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Long, Chloe,16784 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
Generated 2025-12-21 09:18:32.677 UTC