[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2625 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xie, Mindy, J,16285 | 76.94 | 0.00 | 0.00 | 0.00 | 76.94 |
| Guo, Alan,12265 | 2385.95 | 0.00 | 0.00 | 0.00 | 2385.95 |
| Griffin, Alexia, W,18027 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Ramirez, Melissa,28019 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Cai, Clarence, L,22609 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Torres, Philip, S,18941 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Morris, Kaitlyn,16093 | 554.97 | 0.00 | 0.00 | 0.00 | 554.97 |
| Butler, Angela, L,11082 | 3110.81 | 0.00 | 0.00 | 2329.99 | 780.82 |
| Sharma, Cameron, L,17832 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Raheem, Tommy, A,15674 | 3053.32 | 0.00 | 0.00 | 2443.35 | 609.97 |
| Mitchell, Gabrielle,14584 | 3040.04 | 0.00 | 699.10 | 0.00 | 2340.94 |
| Coleman, Caroline,16568 | 69.97 | 0.00 | 0.00 | 69.97 | 0.00 |
| Rivera, Abigail, D,14717 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Watson, Destiny, W,24593 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Mehta, Kari, V,12322 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Foster, Justin,21575 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Navarro, Philip,26403 | 41.93 | 0.00 | 0.00 | 0.00 | 41.93 |
| Morris, Jared,13052 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Wood, Devin, A,17530 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Smith, Robert,15113 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Peterson, Amanda,23404 | 624.97 | 0.00 | 0.00 | 0.00 | 624.97 |
| Perez, Alexandra, M,28855 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Richardson, Hailey, W,15873 | 3123.93 | 0.00 | 0.00 | 782.99 | 2340.94 |
| Robinson, Carol,16003 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Washington, Fernando, E,18117 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Zhang, James,14684 | 54.99 | 0.00 | 0.00 | 0.00 | 54.99 |
| Martin, David, B,27135 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Torres, Jade,25358 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Sandberg, Isabella, D,21429 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Anderson, Austin, E,26053 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Powell, Olivia, B,25345 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Martinez, Erick,17970 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Zheng, Nuan,13604 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Edwards, Andrea,28004 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Pal, Andres, S,14931 | 6980.85 | 0.00 | 0.00 | 2181.56 | 4799.29 |
| Bell, Brianna, R,17538 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rai, Yolanda,27047 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Ye, Colin,22501 | 2566.80 | 0.00 | 0.00 | 0.00 | 2566.80 |
| James, Gabrielle,12725 | 127.28 | 0.00 | 0.00 | 0.00 | 127.28 |
| Foster, Dylan, D,15156 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Perez, Marco,18910 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Blanco, Darren,14382 | 3373.91 | 0.00 | 0.00 | 1000.44 | 2373.47 |
| Alonso, Philip, L,22303 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Long, Carol, J,27044 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Morris, Katherine, T,23877 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Sara, Chelsea, S,14204 | 71.58 | 0.00 | 0.00 | 71.58 | 0.00 |
| Wang, Thomas,21271 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Mehta, Cynthia,14175 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Walker, Marcus,20032 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Campbell, Kyle, S,14293 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Ruiz, Jimmy, E,22486 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Ramirez, Jesse,15487 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Sanders, Marcus, J,13186 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Clark, Wyatt, M,25077 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Carlson, Mallory, A,19281 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| He, Jeffery,27924 | 2525.94 | 0.00 | 0.00 | 0.00 | 2525.94 |
| Roberts, Ian, M,25424 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Foster, Julia, A,26238 | 3298.94 | 0.00 | 2049.10 | 0.00 | 1249.84 |
| Ruiz, Michele,16458 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Moreno, Ebony, J,16409 | 4925.17 | 0.00 | 0.00 | 2443.35 | 2481.82 |
| Garcia, Clifford,12267 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Hall, Alexandra, M,16830 | 7138.68 | 0.00 | 0.00 | 2443.35 | 4695.33 |
Generated 2025-12-18 02:12:36.165 UTC