[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 686 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Kumar, Mindy, R,12700 | 6860.44 | 0.00 | 0.00 | 2071.42 | 4789.02 |
| Torres, Carolyn,15261 | 70.74 | 0.00 | 0.00 | 0.00 | 70.74 |
| Goel, Bradley,15803 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Suarez, Meredith,15032 | 3800.08 | 0.00 | 0.00 | 2049.10 | 1750.98 |
| Chen, Rosa,23435 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Sullivan, Carla, A,20611 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Prasad, Jarrod,11359 | 4960.07 | 0.00 | 3374.99 | 0.00 | 1585.08 |
| Kapoor, Summer,28353 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Fernandez, Nancy,14854 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Sai, Martin, L,21221 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Wu, Alisha,23654 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Cai, Vincent, L,11757 | 58.05 | 0.00 | 0.00 | 0.00 | 58.05 |
| Chander, Misty,17333 | 80.94 | 0.00 | 0.00 | 0.00 | 80.94 |
| Blue, Richard,12006 | 144.74 | 0.00 | 0.00 | 0.00 | 144.74 |
| Lal, Corey, H,23313 | 2906.03 | 0.00 | 0.00 | 2181.56 | 724.47 |
| Reed, Steven,24373 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Xu, Jessie, R,27517 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Martinez, Stanley, Z,13668 | 114.21 | 0.00 | 0.00 | 78.98 | 35.23 |
| Carlson, Jose,19954 | 74.45 | 0.00 | 0.00 | 60.47 | 13.98 |
| Martin, Ricky, C,16608 | 101.57 | 0.00 | 0.00 | 0.00 | 101.57 |
| Hernandez, Audrey,18290 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Navarro, Kellie, I,21873 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Dominguez, Josue, R,15600 | 4590.40 | 0.00 | 0.00 | 2071.42 | 2518.98 |
| Patel, Cynthia, M,15222 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Lu, Crystal, A,15145 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Raji, Damien, K,24282 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Deng, Colin, B,18299 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Foster, Madison,14038 | 6819.12 | 0.00 | 0.00 | 2049.10 | 4770.02 |
| Rana, Pedro, F,13970 | 6843.14 | 0.00 | 0.00 | 2049.10 | 4794.04 |
| Huang, Lisa, L,14102 | 3667.23 | 0.00 | 0.00 | 2071.42 | 1595.81 |
| Tang, Louis, A,18292 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Carlson, Theresa, L,19629 | 109.44 | 0.00 | 0.00 | 0.00 | 109.44 |
| Saunders, Brandy,11946 | 4697.31 | 0.00 | 3399.99 | 0.00 | 1297.32 |
| Zeng, Wesley,20460 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Patel, Jillian,26667 | 1390.95 | 0.00 | 0.00 | 782.99 | 607.96 |
| Navarro, Kristy, J,19570 | 74.94 | 0.00 | 0.00 | 0.00 | 74.94 |
| Sanchez, Marie,22924 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Black, Tonya, M,21254 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Martin, Felicia, L,15018 | 112.46 | 0.00 | 0.00 | 0.00 | 112.46 |
| Goel, April, C,16166 | 108.85 | 0.00 | 0.00 | 0.00 | 108.85 |
| Rai, Tonya,25243 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| She, Tamara, M,14224 | 5621.22 | 0.00 | 0.00 | 2049.10 | 3572.12 |
| Shan, Johnny,11999 | 7043.27 | 0.00 | 3399.99 | 0.00 | 3643.28 |
| Munoz, Darren,23539 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Jai, Clayton,12339 | 6865.46 | 0.00 | 2071.42 | 0.00 | 4794.04 |
| Green, Jennifer,12571 | 2641.39 | 0.00 | 2071.42 | 0.00 | 569.97 |
| Ashe, Jimmy, S,28959 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Serrano, Dana, S,12678 | 341.43 | 0.00 | 0.00 | 0.00 | 341.43 |
| Andersen, Rafael, E,12691 | 247.46 | 0.00 | 0.00 | 0.00 | 247.46 |
| Xie, Drew, A,20218 | 104.69 | 0.00 | 0.00 | 0.00 | 104.69 |
| Raji, Derek, D,19591 | 63.42 | 0.00 | 0.00 | 0.00 | 63.42 |
| Anand, Alícia, J,29113 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Serrano, Lori,17066 | 105.75 | 0.00 | 0.00 | 0.00 | 105.75 |
| Garcia, Monica, D,20267 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Flores, Katherine,21180 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Xu, Edwin, J,25272 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Bradley, Emma,14211 | 5662.90 | 0.00 | 0.00 | 2049.10 | 3613.80 |
| Nath, Kara, S,21177 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Madan, Geoffrey, M,15241 | 51.91 | 0.00 | 0.00 | 0.00 | 51.91 |
| Chen, Clarence, R,15147 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| Gill, Gary, B,25108 | 2199.41 | 0.00 | 0.00 | 1000.44 | 1198.97 |
| Gill, Byron, J,18483 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Weber, Levi, A,13120 | 205.39 | 0.00 | 0.00 | 0.00 | 205.39 |
| Weber, Jarrod, M,14859 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Lopez, Carla, G,28326 | 2442.54 | 0.00 | 0.00 | 0.00 | 2442.54 |
| Simpson, Tara, K,28107 | 810.32 | 0.00 | 0.00 | 0.00 | 810.32 |
| Jai, Ethan,15217 | 41.26 | 0.00 | 0.00 | 0.00 | 41.26 |
| Chen, Claudia, R,16627 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Yang, Kevin, F,20605 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Yuan, Ricardo,16674 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Zhang, Tiffany, R,17318 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Blanco, Kari,19627 | 41.75 | 0.00 | 0.00 | 0.00 | 41.75 |
| Mehta, Carolyn,28205 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Raje, Lindsey,24614 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Andersen, Roger,24469 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Huang, Amy, C,12244 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Rodriguez, Dylan, E,16611 | 75.53 | 0.00 | 0.00 | 0.00 | 75.53 |
| Shan, Sheena, J,21565 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Nara, Katrina, Z,24608 | 2120.93 | 0.00 | 1000.44 | 0.00 | 1120.49 |
| Moore, Natalie, W,18273 | 6104.21 | 0.00 | 3578.27 | 0.00 | 2525.94 |
| Suri, Holly, M,18286 | 141.55 | 0.00 | 0.00 | 0.00 | 141.55 |
| Zheng, Shannon, M,14678 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Arthur, Tammy, L,21363 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ramos, Gloria, A,21365 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Liang, Margaret,17254 | 147.48 | 0.00 | 0.00 | 0.00 | 147.48 |
| Zhu, Vincent, E,24899 | 105.45 | 0.00 | 0.00 | 0.00 | 105.45 |
| Chander, Marshall,19090 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Lal, Julie, A,28309 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| She, Stacey,26748 | 1357.97 | 0.00 | 0.00 | 782.99 | 574.98 |
| Vazquez, Lawrence,19632 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Raman, Allen, R,25129 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Nath, Ricardo, C,12039 | 8213.00 | 0.00 | 3374.99 | 0.00 | 4838.01 |
| Blanco, Ricky, F,16606 | 67.17 | 0.00 | 0.00 | 0.00 | 67.17 |
| Navarro, Latasha, L,11100 | 8172.51 | 0.00 | 3374.99 | 0.00 | 4797.52 |
| Chander, Russell, E,29067 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Stewart, Margaret, C,29096 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Zeng, Ernest, M,12992 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| Ashe, Kathryn,16168 | 80.11 | 0.00 | 0.00 | 0.00 | 80.11 |
| Vazquez, Byron,11122 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Carlson, Armando,17484 | 126.96 | 0.00 | 0.00 | 0.00 | 126.96 |
| Baker, Luke, J,22952 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Kovár, Donald, M,24277 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Li, Kristen, R,15153 | 113.97 | 0.00 | 0.00 | 0.00 | 113.97 |
| Sun, Karen, C,28208 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 2294.99 | 2419.06 |
| Garcia, Jermaine,21566 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Jai, Karla,18263 | 126.94 | 0.00 | 0.00 | 0.00 | 126.94 |
| Adams, Sydney,27367 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Mrs., Nara, Barbara,12704 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Zhang, Willie, T,16023 | 166.89 | 0.00 | 0.00 | 0.00 | 166.89 |
| Alvarez, Marc, B,18221 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Kumar, Luke,24161 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Sanz, Orlando,14309 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Henderson, Wyatt,16697 | 87.08 | 0.00 | 0.00 | 0.00 | 87.08 |
| Vazquez, Joe, C,20418 | 4207.24 | 0.00 | 3578.27 | 0.00 | 628.97 |
| Madan, Jay, L,20156 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Carlson, Kristy,28217 | 2408.29 | 0.00 | 0.00 | 0.00 | 2408.29 |
| Nelson, Carol,13520 | 4551.36 | 0.00 | 0.00 | 2071.42 | 2479.94 |
| Sharma, Jodi, N,18260 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Zeng, Heather, E,18287 | 72.16 | 0.00 | 0.00 | 0.00 | 72.16 |
| Chen, Alisha, J,14225 | 5603.92 | 0.00 | 0.00 | 2049.10 | 3554.82 |
Generated 2025-12-22 02:34:03.060 UTC