[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1500 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Richardson, Sebastian, C,22365 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Rubio, Frank,28764 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Butler, Riley, M,25844 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| King, Xavier, K,16344 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Hayes, Samantha,23377 | 556.93 | 0.00 | 0.00 | 0.00 | 556.93 |
| Pal, Shaun,24707 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Martinez, Kayla, E,27444 | 31.28 | 0.00 | 0.00 | 0.00 | 31.28 |
| Richardson, Carlos,22190 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Patterson, Dakota, M,14465 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Shen, Tommy, C,25645 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Hernandez, Morgan,11637 | 39.58 | 0.00 | 0.00 | 0.00 | 39.58 |
| Robinson, John, I,19531 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Chandra, Lydia,22462 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Green, Robert, L,18771 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Romero, Rebekah, C,26413 | 58.47 | 0.00 | 0.00 | 0.00 | 58.47 |
| Chande, Kate, J,26412 | 55.91 | 0.00 | 0.00 | 0.00 | 55.91 |
| Henderson, Megan,11195 | 105.75 | 0.00 | 0.00 | 0.00 | 105.75 |
| Alexander, Angela,27996 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Butler, Zachary,22052 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Clark, Xavier, L,18967 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Williams, Nicole, J,18384 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Smith, Olivia, C,18687 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Williams, Fernando, L,15469 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gonzalez, Candace,19327 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Anderson, Julia,21309 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Foster, Vanessa,16372 | 2482.23 | 0.00 | 0.00 | 0.00 | 2482.23 |
| Bryant, Spencer, J,25025 | 2469.05 | 0.00 | 0.00 | 0.00 | 2469.05 |
| Butler, Hailey, D,19865 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Zhu, Alvin,28344 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| White, Ian, M,11649 | 91.28 | 0.00 | 0.00 | 0.00 | 91.28 |
| Simmons, Kelly, S,29049 | 113.46 | 0.00 | 0.00 | 0.00 | 113.46 |
| Phillips, Jordan,25351 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Clark, Olivia,22081 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Guo, Suzanne,25507 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Richardson, Mariah,12410 | 159.99 | 0.00 | 0.00 | 0.00 | 159.99 |
| Sanders, Jasmine, E,22046 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Nara, Jodi, N,23939 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| She, Jodi,22727 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Nelson, Seth,22729 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Gonzalez, Pedro,21780 | 77.92 | 0.00 | 0.00 | 0.00 | 77.92 |
| Clark, Hannah, H,22055 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Richardson, Katherine,14901 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gomez, Billy, R,13596 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Hernandez, Jimmy,21003 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Taylor, Megan, E,11404 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Zhang, Dennis,11231 | 64.26 | 0.00 | 0.00 | 0.00 | 64.26 |
| Brown, Blake,21647 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Xu, Lindsay, A,21030 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Suarez, Desiree, H,21061 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Sanchez, Isaac,23007 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Kelly, Mariah, L,19111 | 609.95 | 0.00 | 0.00 | 0.00 | 609.95 |
| Madan, Tina, M,24347 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Simmons, Carol, L,25343 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Kumar, Priscilla, C,14568 | 54.96 | 0.00 | 0.00 | 0.00 | 54.96 |
| Rivera, Grace, M,14468 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Adams, Eric,24777 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Ye, Jaclyn,23928 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Allen, Elijah, H,28028 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Morris, Devin,15875 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Martin, Nelson,28450 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Bryant, Sarah,11923 | 42.95 | 0.00 | 0.00 | 0.00 | 42.95 |
| Suri, Brandy,14339 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
Generated 2025-12-24 06:48:56.574 UTC