[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 374 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wu, Eugene, P,22414 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Chandra, Ann,18209 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Yuan, Melvin,29331 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Perez, Richard, L,13808 | 4406.74 | 0.00 | 3578.27 | 0.00 | 828.47 |
| Blanco, Erik, J,29093 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Ruiz, Melody,13621 | 167.40 | 0.00 | 0.00 | 0.00 | 167.40 |
| Williams, James, J,11152 | 2294.99 | 0.00 | 0.00 | 2294.99 | 0.00 |
| Sanders, Timothy, L,22073 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Turner, Eric, B,19428 | 1878.57 | 0.00 | 699.10 | 1179.47 | 0.00 |
| Rodriguez, Deanna,25611 | 564.48 | 0.00 | 0.00 | 564.48 | 0.00 |
| She, Louis,14136 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Vance, Pamela,14193 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Raji, April, L,14981 | 71.27 | 0.00 | 0.00 | 0.00 | 71.27 |
| Tang, Priscilla, J,12479 | 4401.41 | 0.00 | 0.00 | 2071.42 | 2329.99 |
| Carter, Mary,16821 | 7221.35 | 0.00 | 0.00 | 2443.35 | 4778.00 |
| Malhotra, Jillian,23624 | 62.97 | 0.00 | 0.00 | 0.00 | 62.97 |
| Brooks, Catherine, J,20181 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Vazquez, Diana,24096 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Parker, Lucas,25869 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Martinez, Gerald,21433 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Richardson, Ariana, B,18847 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Richardson, Anna, R,15533 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| White, Sarah,16670 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Arun, George, J,14763 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Mitchell, Jonathan, L,22109 | 5971.33 | 0.00 | 3578.27 | 2393.06 | 0.00 |
| Long, Sydney,27921 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Shan, Austin,21465 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Raje, Latoya, L,17953 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Suri, Ronald,18214 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Diaz, Caroline,20572 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Arun, Roy, W,23620 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Sanz, Marvin,19612 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Russell, Angela,12049 | 171.44 | 0.00 | 0.00 | 0.00 | 171.44 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Martin, Dana, K,16231 | 2525.94 | 0.00 | 0.00 | 2525.94 | 0.00 |
| Jackson, Samantha,25074 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Serrano, Anne,24244 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Alexander, Xavier, A,13017 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Zeng, Louis,18903 | 4143.74 | 0.00 | 3578.27 | 565.47 | 0.00 |
| Goel, Karl,18705 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Saunders, Micheal,17513 | 4260.24 | 0.00 | 3578.27 | 681.97 | 0.00 |
| Alvarez, Mathew, L,17494 | 111.96 | 0.00 | 0.00 | 0.00 | 111.96 |
| James, Timothy,21331 | 2670.89 | 0.00 | 0.00 | 2670.89 | 0.00 |
| Perry, Ana,11215 | 1155.52 | 0.00 | 0.00 | 0.00 | 1155.52 |
| Long, Grace, J,15492 | 3117.45 | 0.00 | 0.00 | 782.99 | 2334.46 |
| Torres, Melanie, L,19171 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Wood, Jennifer, L,26274 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Alonso, Danny, S,18217 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Alvarez, Robin, V,11243 | 7164.25 | 0.00 | 3399.99 | 2364.98 | 1399.28 |
| Allen, Luke,11316 | 2349.98 | 0.00 | 0.00 | 2349.98 | 0.00 |
| Rai, Jenny, D,11275 | 5955.23 | 0.00 | 3578.27 | 2376.96 | 0.00 |
| Miller, Alexander,26307 | 2848.76 | 0.00 | 0.00 | 2848.76 | 0.00 |
| Thomas, Olivia, R,23688 | 1214.85 | 0.00 | 0.00 | 1214.85 | 0.00 |
| Thomas, Jasmine, M,13424 | 4807.31 | 0.00 | 2443.35 | 0.00 | 2363.96 |
| Shen, Katie, A,20283 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Gao, Randy,25113 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Green, Kevin, D,24358 | 2418.05 | 0.00 | 0.00 | 0.00 | 2418.05 |
| King, Aaron, L,11739 | 4758.03 | 0.00 | 0.00 | 2359.98 | 2398.05 |
| Davis, Hunter,11088 | 3176.78 | 0.00 | 0.00 | 2366.46 | 810.32 |
| Munoz, Rebekah,28396 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Chandra, Stanley, A,20836 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Collins, Bailey,11970 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Xu, Grant, M,19266 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| She, Wayne,23607 | 2451.30 | 0.00 | 0.00 | 2451.30 | 0.00 |
| Serrano, Diane, E,14857 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Peterson, Marcus, L,16803 | 1759.97 | 0.00 | 0.00 | 1759.97 | 0.00 |
| Black, Wayne, E,25056 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Carter, Amanda, M,11041 | 2380.47 | 0.00 | 0.00 | 2380.47 | 0.00 |
| Alexander, Jocelyn,11165 | 102.49 | 0.00 | 0.00 | 0.00 | 102.49 |
| King, Gabriel, V,28122 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hu, Alan,11676 | 91.28 | 0.00 | 0.00 | 0.00 | 91.28 |
| Perez, Logan, L,22968 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Martin, Edward, W,28336 | 138.97 | 0.00 | 0.00 | 0.00 | 138.97 |
| Green, Eric,27380 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Rogers, Jade, I,14332 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Ward, Rachel, C,22126 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Tang, Johnny,15119 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Lopez, Ronald,17855 | 189.96 | 0.00 | 0.00 | 0.00 | 189.96 |
| Barnes, Kaitlyn, Z,15162 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
| Cox, Megan, A,11657 | 178.96 | 0.00 | 0.00 | 0.00 | 178.96 |
| Luo, Rafael, A,26903 | 800.82 | 0.00 | 0.00 | 0.00 | 800.82 |
| Sai, Erick, L,11484 | 4985.38 | 0.00 | 2071.42 | 2364.98 | 548.98 |
| Tang, Franklin, N,26940 | 1273.83 | 0.00 | 0.00 | 0.00 | 1273.83 |
| Hill, James, S,29317 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Ruiz, Krista, C,13081 | 6772.15 | 0.00 | 0.00 | 2049.10 | 4723.05 |
| Flores, Isabella,25161 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Jimenez, Gerald, E,23963 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Zhou, Jorge, M,22319 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Hill, Jonathan, E,11171 | 6716.55 | 0.00 | 3578.27 | 2381.95 | 756.33 |
| Nara, Andres, A,12332 | 10789.53 | 0.00 | 3578.27 | 0.00 | 7211.26 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Huang, Eugene, L,11001 | 6383.88 | 3374.99 | 0.00 | 2419.93 | 588.96 |
| Clark, Abigail,12772 | 5913.24 | 0.00 | 3578.27 | 0.00 | 2334.97 |
| Ramirez, Jacqueline, R,21487 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Sai, Regina,21192 | 4229.32 | 0.00 | 2443.35 | 0.00 | 1785.97 |
| Hernandez, Adrienne, Y,22668 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Huang, Randy,24007 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Vance, Tina,26862 | 1249.84 | 0.00 | 0.00 | 1249.84 | 0.00 |
| Bell, Isaiah, W,27197 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Torres, Maria,16792 | 1735.98 | 0.00 | 0.00 | 1735.98 | 0.00 |
| Vazquez, Nelson, D,22076 | 65.95 | 0.00 | 0.00 | 0.00 | 65.95 |
| Phillips, Andrea,18573 | 83.74 | 0.00 | 0.00 | 0.00 | 83.74 |
| Morgan, Riley, R,26530 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Torres, Zoe, E,22348 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Russell, Sydney,19760 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Hu, Gilbert, L,28767 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Mitchell, Jesse, C,15776 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ye, Ernest, A,22558 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhang, Alisha, G,28394 | 4555.47 | 0.00 | 3399.99 | 0.00 | 1155.48 |
| Zhang, Jose,23905 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Wu, Dennis, G,11503 | 61.78 | 0.00 | 0.00 | 0.00 | 61.78 |
| Shan, Jordan, C,16207 | 7226.37 | 0.00 | 0.00 | 2443.35 | 4783.02 |
| Yang, Jon, V,11000 | 8248.99 | 3399.99 | 0.00 | 2341.97 | 2507.03 |
| Rodriguez, Hannah,13286 | 4516.53 | 0.00 | 0.00 | 2181.56 | 2334.97 |
| Ma, Cedric, W,11094 | 235.89 | 0.00 | 0.00 | 0.00 | 235.89 |
| Davis, Austin, E,13366 | 4749.04 | 0.00 | 0.00 | 0.00 | 4749.04 |
| Zhao, Gilbert,23119 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Gutierrez, Lawrence, M,19564 | 5293.24 | 0.00 | 3578.27 | 0.00 | 1714.97 |
| Andersen, Mario, J,20977 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Chander, Tasha,15073 | 4143.26 | 0.00 | 3578.27 | 0.00 | 564.99 |
| Romero, Jerome,11337 | 8162.00 | 0.00 | 3374.99 | 2388.96 | 2398.05 |
| Suarez, Lori,12484 | 4441.04 | 0.00 | 0.00 | 2049.10 | 2391.94 |
| Suri, Ebony, A,22808 | 2478.34 | 0.00 | 0.00 | 2478.34 | 0.00 |
| Wright, Jenna,11291 | 5873.26 | 0.00 | 3578.27 | 2294.99 | 0.00 |
Generated 2025-12-24 07:17:42.311 UTC