[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 625 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jimenez, Felicia, L,11075 | 8068.03 | 0.00 | 3374.99 | 2294.99 | 2398.05 |
| Gomez, Felicia, J,18219 | 6038.56 | 0.00 | 3578.27 | 2460.29 | 0.00 |
| Martinez, Tyler, T,28201 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Lal, Katie, E,18210 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Sanz, Cheryl, G,14046 | 5645.24 | 0.00 | 0.00 | 3340.26 | 2304.98 |
| Pal, Gilbert,27744 | 643.95 | 0.00 | 0.00 | 643.95 | 0.00 |
| Torres, Mathew, L,18900 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Ruiz, Julio,11005 | 8121.33 | 3374.99 | 0.00 | 2362.27 | 2384.07 |
| Harris, Eduardo, S,18238 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Ye, Leah,11077 | 8169.03 | 0.00 | 3374.99 | 0.00 | 4794.04 |
| Chande, Franklin, L,20232 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Alonso, Meghan, A,24457 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Gao, Micah, W,25106 | 2170.92 | 0.00 | 0.00 | 1000.44 | 1170.48 |
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 0.00 | 4733.05 |
| Gonzalez, Kristopher, C,19264 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Lin, Wesley,21407 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Gomez, Gary,15640 | 34.57 | 0.00 | 0.00 | 0.00 | 34.57 |
| Sanz, Mathew, L,14557 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Malhotra, Ross, R,29307 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Rowe, Jacquelyn, I,13615 | 146.91 | 0.00 | 0.00 | 0.00 | 146.91 |
| Sun, Rafael,26749 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Sanders, Kaylee, C,20221 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Blue, Richard,12006 | 144.74 | 0.00 | 0.00 | 0.00 | 144.74 |
| Rana, Raymond,25115 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Luo, Shawn,12246 | 3947.25 | 0.00 | 3374.99 | 0.00 | 572.26 |
| Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Fernandez, Ross, R,11763 | 76.65 | 0.00 | 0.00 | 0.00 | 76.65 |
| Sharma, Julie, R,18191 | 94.47 | 0.00 | 0.00 | 0.00 | 94.47 |
| Nelson, Sophia,16664 | 4377.75 | 0.00 | 3578.27 | 0.00 | 799.48 |
| Taylor, Jennifer,18470 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Gonzalez, Veronica, C,23311 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Deng, Kurt, D,13635 | 215.74 | 0.00 | 0.00 | 0.00 | 215.74 |
| Arun, Bryant, C,20453 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Andersen, Kelvin, C,21366 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jiménez, Darren, W,28931 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Suri, Shane, L,25126 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Gill, Billy, L,16700 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Chander, Cassie, M,18258 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Becker, Latoya, W,17330 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Ramos, Kristy,16682 | 66.58 | 0.00 | 0.00 | 0.00 | 66.58 |
| Raman, Brandy,12247 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Moreno, Janet, L,15592 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Kapoor, Patricia, R,21883 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Shen, Jodi, A,22028 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lu, Sandra, N,13521 | 4514.77 | 0.00 | 0.00 | 2071.42 | 2443.35 |
| Martin, Larry,18254 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Serrano, Stacy,24613 | 2148.21 | 0.00 | 0.00 | 1000.44 | 1147.77 |
| Srini, Veronica,11996 | 7058.70 | 0.00 | 3374.99 | 0.00 | 3683.71 |
| Xie, Alvin, M,16617 | 160.55 | 0.00 | 0.00 | 0.00 | 160.55 |
| Nath, Michele, L,11056 | 8207.50 | 0.00 | 3374.99 | 0.00 | 4832.51 |
| Yang, Heather,18275 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Hernandez, Erika,16160 | 2644.07 | 0.00 | 0.00 | 2049.10 | 594.97 |
| Jai, Alvin,19599 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Ortega, Jill, A,20239 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Jimenez, Jimmy,27365 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Sandberg, Kristine,12241 | 3989.46 | 0.00 | 3399.99 | 0.00 | 589.47 |
| Butler, Jose,29064 | 815.81 | 0.00 | 0.00 | 0.00 | 815.81 |
| King, Jesse, J,14665 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Zhu, Damien, M,15822 | 43.21 | 0.00 | 0.00 | 0.00 | 43.21 |
| Perez, Ivan, S,23408 | 4218.82 | 0.00 | 0.00 | 2443.35 | 1775.47 |
| Zhu, Jenny, J,17078 | 186.94 | 0.00 | 0.00 | 0.00 | 186.94 |
| White, Ashley, D,21887 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Martin, Ethan, M,13998 | 245.25 | 0.00 | 0.00 | 0.00 | 245.25 |
| Zheng, Jenny, R,11947 | 4747.30 | 0.00 | 3374.99 | 0.00 | 1372.31 |
| Rivera, Nathaniel, M,14051 | 5606.91 | 0.00 | 0.00 | 2049.10 | 3557.81 |
| Martin, Gerald, K,17284 | 90.25 | 0.00 | 0.00 | 0.00 | 90.25 |
| Ruiz, Leslie, J,26032 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sanchez, Terrance,19584 | 116.74 | 0.00 | 0.00 | 0.00 | 116.74 |
| She, Rafael, I,20152 | 4142.75 | 0.00 | 3578.27 | 0.00 | 564.48 |
| Zhang, Cara,12351 | 117.97 | 0.00 | 0.00 | 0.00 | 117.97 |
| Xie, Derek,14287 | 5141.43 | 0.00 | 0.00 | 2049.10 | 3092.33 |
| Arthur, Cassandra, M,22410 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Martinez, Stanley, Z,13668 | 114.21 | 0.00 | 0.00 | 0.00 | 114.21 |
| Sai, Kari, E,14231 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Hernandez, Audrey,18290 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Gutierrez, Jaime, C,11457 | 8211.48 | 0.00 | 3374.99 | 0.00 | 4836.49 |
| Arun, Cory, O,16527 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Ruiz, Adrienne,13523 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Lopez, Francisco, L,18714 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Lee, Grace, J,28318 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Zheng, Colleen,13026 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Raji, Derek, D,19591 | 63.42 | 0.00 | 0.00 | 0.00 | 63.42 |
| Zhou, Alan,16480 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Jimenez, Teresa, L,24372 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Patel, Kaitlin, L,16615 | 95.84 | 0.00 | 0.00 | 0.00 | 95.84 |
| Romero, Joy, D,24886 | 80.47 | 0.00 | 0.00 | 0.00 | 80.47 |
| Ramos, Albert, E,27716 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Chen, Tiffany, A,23348 | 4167.31 | 0.00 | 0.00 | 2443.35 | 1723.96 |
| Zhang, Brittney, W,19975 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Lin, Sandra, A,25052 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Sai, Bryant, S,22577 | 2743.04 | 0.00 | 0.00 | 2181.56 | 561.48 |
| Cai, Karen,22572 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Coleman, Brittany,15579 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Saunders, Brandy,11946 | 4697.31 | 0.00 | 3399.99 | 0.00 | 1297.32 |
| Russell, Stephanie,20255 | 75.48 | 0.00 | 0.00 | 0.00 | 75.48 |
| Gutierrez, Desiree,15216 | 101.74 | 0.00 | 0.00 | 0.00 | 101.74 |
| Martin, Felicia, L,15018 | 112.46 | 0.00 | 0.00 | 0.00 | 112.46 |
| Carter, Amber, E,16679 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Goel, April, C,16166 | 108.85 | 0.00 | 0.00 | 0.00 | 108.85 |
| Perez, Marie,13996 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Zhu, Colleen,17252 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Chandra, Cesar, R,20236 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Ramos, Sabrina, L,29082 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Luo, Darrell, J,21187 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Johnston, Tamara, H,18492 | 218.26 | 0.00 | 0.00 | 0.00 | 218.26 |
| Prasad, Brett, A,20262 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Cook, Kaylee,11904 | 8214.50 | 0.00 | 3399.99 | 0.00 | 4814.51 |
| Huang, Alejandro,11464 | 8128.51 | 0.00 | 3374.99 | 0.00 | 4753.52 |
| Yang, Lacey,13150 | 89.24 | 0.00 | 0.00 | 0.00 | 89.24 |
| Anand, Chad,24484 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Wu, Laura,20615 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| She, Ricardo, A,14233 | 78.97 | 0.00 | 0.00 | 0.00 | 78.97 |
| Arthur, Carla,16710 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Deng, Grant, C,16625 | 81.81 | 0.00 | 0.00 | 0.00 | 81.81 |
| She, Alicia, W,17250 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Xu, Trisha,20282 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Yang, Alejandro, M,22176 | 100.46 | 0.00 | 0.00 | 0.00 | 100.46 |
| Xie, Nina,12997 | 118.18 | 0.00 | 0.00 | 0.00 | 118.18 |
| Tang, Ashlee, D,11369 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Gonzalez, Natalie,25215 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Patel, Ann,21371 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rodriguez, Tammy,15233 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Raman, Sergio,27866 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Liu, Karen, F,14008 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
Generated 2026-01-04 05:39:38.865 UTC