[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 187 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Kumar, Tommy,17297 | 100.25 | 0.00 | 0.00 | 37.27 | 62.98 |
| Srini, Cindy, E,26026 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Garcia, Sarah,11907 | 8135.33 | 0.00 | 3399.99 | 2297.28 | 2438.06 |
| Sharma, Keith,15728 | 63.97 | 0.00 | 0.00 | 28.98 | 34.99 |
| Zhao, Heather,24596 | 4168.83 | 0.00 | 0.00 | 2443.35 | 1725.48 |
| Gao, Laura,22029 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| She, Gregory,18458 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Gonzales, Hunter,26570 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Lopez, Terrance, T,14217 | 139.45 | 0.00 | 0.00 | 89.46 | 49.99 |
| Ruiz, Shannon,20822 | 4134.53 | 0.00 | 3578.27 | 556.26 | 0.00 |
| Lewis, Kayla,12013 | 3949.97 | 0.00 | 3399.99 | 549.98 | 0.00 |
| Anderson, Emily, M,25220 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Parker, Evan, R,18729 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| He, Ramon,26919 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Blanco, Kristi,15464 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Raje, Ashlee, E,16658 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Ye, Dennis, M,16638 | 5974.23 | 3578.27 | 0.00 | 0.00 | 2395.96 |
| Wang, Curtis, A,13108 | 5718.66 | 0.00 | 0.00 | 2071.42 | 3647.24 |
| Cooper, Cody, A,16028 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Jai, Rafael, L,17323 | 84.96 | 0.00 | 0.00 | 8.99 | 75.97 |
| Raje, Marshall, J,19267 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Liang, Damien, M,22150 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Zhou, Stacey, L,21374 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Hernandez, Jill, L,13003 | 230.25 | 0.00 | 0.00 | 6.28 | 223.97 |
| Madan, Meagan,11767 | 8319.51 | 0.00 | 3399.99 | 2475.97 | 2443.55 |
| Gill, Eddie, J,12715 | 74.54 | 0.00 | 0.00 | 64.97 | 9.57 |
| Liu, Clayton, L,21373 | 15.23 | 0.00 | 0.00 | 15.23 | 0.00 |
| Ramos, Mary, B,15019 | 72.96 | 0.00 | 0.00 | 8.99 | 63.97 |
| Mehta, Edgar,11761 | 8149.49 | 0.00 | 3399.99 | 2356.44 | 2393.06 |
| Gomez, Randall, R,11762 | 8228.01 | 0.00 | 3399.99 | 2389.96 | 2438.06 |
| Tang, Leonard, L,28109 | 778.62 | 0.00 | 0.00 | 778.62 | 0.00 |
| Gutierrez, Jay, C,13155 | 226.95 | 0.00 | 0.00 | 84.47 | 142.48 |
| Chandra, Dominique, H,26765 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Sharma, Cedric, A,14060 | 99.47 | 0.00 | 0.00 | 49.99 | 49.48 |
| Lewis, Hannah,26561 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Dominguez, Raquel, A,27470 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Sun, Dennis, K,24481 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Ye, Krystal, M,26923 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Foster, Madison,14038 | 6819.12 | 0.00 | 0.00 | 2049.10 | 4770.02 |
| Lopez, Ross,18443 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Sai, Francisco, W,18766 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Lewis, Jasmine,13964 | 6806.45 | 0.00 | 0.00 | 2071.42 | 4735.03 |
| Zhang, James,14684 | 38.55 | 0.00 | 0.00 | 0.00 | 38.55 |
| Morgan, Melissa, M,20222 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Carson, Mitchell,13623 | 99.20 | 0.00 | 0.00 | 0.00 | 99.20 |
| Luo, Devon, D,22850 | 4657.51 | 0.00 | 0.00 | 2181.56 | 2475.95 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Xu, Alejandro, R,26585 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Chen, Jon,26920 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Garcia, Levi, G,21232 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Yang, Curtis,11110 | 8093.03 | 0.00 | 3399.99 | 2294.99 | 2398.05 |
| Diaz, Kellie, A,18330 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Lu, Margaret, D,20814 | 4186.23 | 0.00 | 3578.27 | 607.96 | 0.00 |
| Gonzalez, Donald,11079 | 32.96 | 0.00 | 0.00 | 9.99 | 22.97 |
| Powell, Rachel,20818 | 4230.73 | 0.00 | 3578.27 | 652.46 | 0.00 |
| Hernandez, Roberto,28923 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Johnson, Sydney,19571 | 90.95 | 0.00 | 0.00 | 33.98 | 56.97 |
| Garcia, Frederick, J,16489 | 112.73 | 0.00 | 0.00 | 88.46 | 24.27 |
| Romero, Marie,20424 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Ross, Connor, J,20816 | 4228.72 | 0.00 | 3578.27 | 650.45 | 0.00 |
| Lin, Rafael,14099 | 200.26 | 0.00 | 0.00 | 27.28 | 172.98 |
| Martin, Meghan, B,26773 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Watson, Adrian, K,13641 | 144.74 | 0.00 | 0.00 | 117.46 | 27.28 |
| Xie, Ricardo,18710 | 6098.58 | 0.00 | 3578.27 | 2520.31 | 0.00 |
| Sanders, Gabriella,11906 | 8151.00 | 0.00 | 3374.99 | 2391.94 | 2384.07 |
| Phillips, Jeremy, E,18495 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Zheng, Vincent,18496 | 6121.71 | 0.00 | 3578.27 | 2543.44 | 0.00 |
| Nara, Jon,22006 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Hu, Edwin,24240 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Munoz, Natasha, M,24601 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Jiménez, Byron,16026 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Zhang, Glenn, A,13967 | 5721.91 | 0.00 | 0.00 | 2049.10 | 3672.81 |
| Martinez, Frederick,11991 | 8128.02 | 0.00 | 3374.99 | 0.00 | 4753.03 |
| He, Karen, C,27861 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Sullivan, Ruth,27723 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| McDonald, Kaitlin,18493 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Rodriguez, Jonathan, J,13046 | 64.97 | 0.00 | 0.00 | 29.98 | 34.99 |
| Goel, Lacey, N,18704 | 33.26 | 0.00 | 0.00 | 30.97 | 2.29 |
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 4733.05 | 0.00 |
| Prasad, Edgar, E,17306 | 117.96 | 0.00 | 0.00 | 34.99 | 82.97 |
| Zheng, Laura,16701 | 4426.74 | 3578.27 | 0.00 | 848.47 | 0.00 |
| Xu, Alan,16741 | 6056.61 | 3578.27 | 0.00 | 2478.34 | 0.00 |
| Liu, Susan,18718 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Henderson, Marcus, D,15212 | 68.96 | 0.00 | 0.00 | 0.00 | 68.96 |
| Martin, Hector,27860 | 615.47 | 0.00 | 0.00 | 0.00 | 615.47 |
| Alonso, Joanna, M,27862 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 0.00 | 2049.10 | 4744.05 |
| Lu, Randy,26441 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Nath, Keith,19617 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
| Sullivan, Kaitlin,16919 | 70.95 | 0.00 | 0.00 | 0.00 | 70.95 |
| Sharma, Arturo,13648 | 6765.44 | 0.00 | 0.00 | 2049.10 | 4716.34 |
| Vazquez, Joan, B,16332 | 147.23 | 0.00 | 0.00 | 0.00 | 147.23 |
| Rana, Evelyn, D,18262 | 142.45 | 0.00 | 0.00 | 0.00 | 142.45 |
| Yang, Rosa,18713 | 237.26 | 0.00 | 0.00 | 0.00 | 237.26 |
| Lopez, Dominic, B,27590 | 1189.46 | 0.00 | 0.00 | 0.00 | 1189.46 |
| West, James, M,15148 | 90.75 | 0.00 | 0.00 | 59.48 | 31.27 |
| Rivera, Evan, Y,26757 | 1344.47 | 0.00 | 0.00 | 1344.47 | 0.00 |
| Luo, Tamara,18738 | 6089.59 | 0.00 | 3578.27 | 2511.32 | 0.00 |
| Ye, Willie,22963 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Cook, Faith,27871 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Zhao, Bianca,13971 | 6772.13 | 0.00 | 0.00 | 2049.10 | 4723.03 |
| Lal, Mitchell, C,20403 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Carlson, Joanna,15594 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Shen, Kelsey, R,22921 | 4647.88 | 0.00 | 0.00 | 2181.56 | 2466.32 |
| Serrano, Reginald, J,13025 | 2690.40 | 0.00 | 0.00 | 2071.42 | 618.98 |
| Liang, Eugene,13972 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Hernandez, Marvin, A,23077 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Mehta, Chelsea,22951 | 4242.31 | 0.00 | 0.00 | 4242.31 | 0.00 |
| She, Nina,22961 | 3891.54 | 0.00 | 0.00 | 3891.54 | 0.00 |
| Serrano, Kristine,28940 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Travers, Danny,12587 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Moreno, Mallory, P,22912 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Serrano, Neil, L,17076 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Suarez, Gina,20248 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Chen, Jake,22845 | 4633.90 | 0.00 | 0.00 | 2181.56 | 2452.34 |
| Russell, Noah, M,26447 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Rai, Brad, S,18490 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Chavez, Corey, R,15731 | 59.98 | 0.00 | 0.00 | 24.99 | 34.99 |
| Kumar, Cristina, N,15426 | 115.92 | 0.00 | 0.00 | 106.93 | 8.99 |
| Rodriguez, Ruth, R,26179 | 38.98 | 0.00 | 0.00 | 38.98 | 0.00 |
| Zhou, Ernest, P,15792 | 2645.40 | 0.00 | 0.00 | 2645.40 | 0.00 |
| Ms., Salavaria, Sharon,11964 | 8173.53 | 0.00 | 3399.99 | 2329.99 | 2443.55 |
| Cook, Kaylee,11904 | 8214.50 | 0.00 | 3399.99 | 2395.45 | 2419.06 |
| Shen, Russell, M,11150 | 192.42 | 0.00 | 0.00 | 143.45 | 48.97 |
Generated 2025-11-03 23:49:16.532 UTC