[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 376 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chande, Alvin, W,24893 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Suarez, Jerome, L,20622 | 6139.59 | 0.00 | 3578.27 | 0.00 | 2561.32 |
| Raman, Pamela, C,27369 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Blanco, Sheila, I,17724 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Moreno, Kristine, K,28481 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Diaz, Felicia, J,15026 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Ray, Bobby,23575 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Jimenez, Julio,24005 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Cai, Warren,24918 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Martinez, Pamela, A,13529 | 4614.86 | 0.00 | 0.00 | 2071.42 | 2543.44 |
| Prasad, Arthur,14275 | 5158.37 | 0.00 | 0.00 | 2800.44 | 2357.93 |
| Rodriguez, Cynthia, E,22206 | 201.28 | 0.00 | 0.00 | 0.00 | 201.28 |
| Yang, Alan, L,15605 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Rana, Stanley, J,22919 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Yang, Wesley, K,15127 | 5182.73 | 0.00 | 0.00 | 2071.42 | 3111.31 |
| Pal, Nichole, J,26741 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Arun, Ross, C,23658 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Munoz, Casey, W,12570 | 2654.06 | 0.00 | 2049.10 | 0.00 | 604.96 |
| Romero, Frank, M,15209 | 2916.56 | 0.00 | 0.00 | 2049.10 | 867.46 |
| Rivera, Nathaniel, M,14051 | 5606.91 | 0.00 | 0.00 | 3286.92 | 2319.99 |
| Zhang, Ramon, D,12352 | 274.24 | 0.00 | 0.00 | 0.00 | 274.24 |
| Sara, Barry, R,13965 | 6872.39 | 0.00 | 0.00 | 2071.42 | 4800.97 |
| Chavez, Corey, R,15731 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Yang, Jamie, S,18465 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Navarro, Jacquelyn,15465 | 40.23 | 0.00 | 0.00 | 29.99 | 10.24 |
| Ye, Edwin,18334 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Martin, Joe,14668 | 5216.69 | 0.00 | 0.00 | 2071.42 | 3145.27 |
| Subram, Ann, M,18693 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Kumar, Yolanda, J,18194 | 85.96 | 0.00 | 0.00 | 0.00 | 85.96 |
| Becker, Jenny,17290 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Sun, Louis, E,16182 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Suarez, Daisy, A,18288 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Nelson, Mary, L,13107 | 5650.90 | 0.00 | 0.00 | 2049.10 | 3601.80 |
| Navarro, Byron,16622 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Goel, Tommy,22909 | 3980.52 | 0.00 | 0.00 | 2181.56 | 1798.96 |
| Moreno, Casey,20602 | 80.47 | 0.00 | 0.00 | 0.00 | 80.47 |
| Arthur, Rebekah,22939 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Luo, Christine, J,24159 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Yuan, Julie,22959 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Griffin, Grace,11443 | 8235.00 | 0.00 | 3374.99 | 0.00 | 4860.01 |
| Perez, Carmen, C,13139 | 6854.45 | 0.00 | 0.00 | 2071.42 | 4783.03 |
| Ross, Julian,11363 | 5035.81 | 0.00 | 3399.99 | 0.00 | 1635.82 |
| Gao, Bianca, C,13112 | 5717.89 | 0.00 | 0.00 | 2049.10 | 3668.79 |
| Morgan, Carlos,25819 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Johnson, Logan, K,22931 | 3882.55 | 0.00 | 0.00 | 3882.55 | 0.00 |
| Chen, Erica, P,18308 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Diaz, Jill, F,22936 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Black, Mindy, W,18696 | 6149.57 | 0.00 | 3578.27 | 2571.30 | 0.00 |
| Shen, Tamara, G,22935 | 3951.52 | 0.00 | 0.00 | 2181.56 | 1769.96 |
| Alvarez, Linda,14047 | 5643.54 | 0.00 | 0.00 | 3321.26 | 2322.28 |
| Sanchez, Bryant, C,13113 | 6832.41 | 0.00 | 0.00 | 2071.42 | 4760.99 |
| Deng, Carl,18284 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Natsuhara, Tony,23097 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Sanchez, Joel,18468 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| Kapoor, Bryant,22946 | 3911.53 | 0.00 | 0.00 | 3911.53 | 0.00 |
| Martinez, Tina, J,18461 | 4748.24 | 0.00 | 3578.27 | 0.00 | 1169.97 |
| Goldstein, Brendan,13518 | 2638.36 | 0.00 | 0.00 | 2049.10 | 589.26 |
| Suri, Adriana,18463 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Ramos, Joy,13129 | 6823.15 | 0.00 | 0.00 | 2049.10 | 4774.05 |
| Gonzalez, Carla, J,18336 | 6145.07 | 0.00 | 3578.27 | 0.00 | 2566.80 |
| Ruiz, Sabrina, A,22214 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Sanz, Larry,14067 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Blanco, Victor,15586 | 4469.37 | 0.00 | 0.00 | 2071.42 | 2397.95 |
| McDonald, Kaitlin,18493 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Gomez, Alfredo, C,18200 | 4150.53 | 0.00 | 3578.27 | 0.00 | 572.26 |
| Huang, Jake,19589 | 95.26 | 0.00 | 0.00 | 0.00 | 95.26 |
| King, Hailey, A,28214 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Vance, Kristopher, C,20407 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhou, Kelvin,20231 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Madan, Francisco, S,25706 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Kapoor, Pedro, H,24229 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Serrano, Shannon, R,18303 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Hu, Barbara,19567 | 104.96 | 0.00 | 0.00 | 0.00 | 104.96 |
| Murphy, Alexa,18276 | 6106.60 | 0.00 | 3578.27 | 0.00 | 2528.33 |
| Kumar, Tommy,17297 | 100.25 | 0.00 | 0.00 | 37.27 | 62.98 |
| Harris, Thomas,24002 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Suarez, Jacquelyn, C,11010 | 8088.04 | 3399.99 | 0.00 | 2294.99 | 2393.06 |
| Lal, Kenneth, J,18701 | 5357.74 | 0.00 | 3578.27 | 1779.47 | 0.00 |
| Pal, Arturo, P,29303 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Raje, Louis, M,25707 | 1262.06 | 0.00 | 699.10 | 0.00 | 562.96 |
| Goel, Karl,18705 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Subram, Candace,27585 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 0.00 | 4720.33 |
| She, Gregory,18458 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Wu, Amy,19790 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Rubio, Robyn, A,18469 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Xu, Grant, M,19266 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Griffin, Blake, S,18699 | 5308.24 | 0.00 | 3578.27 | 1729.97 | 0.00 |
| Torres, Dwayne, R,17288 | 4426.24 | 0.00 | 3578.27 | 0.00 | 847.97 |
| Mehta, Preston, G,18692 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Barnes, Alexia, D,15231 | 59.48 | 0.00 | 0.00 | 0.00 | 59.48 |
| Kapoor, Kristina,11997 | 7029.78 | 0.00 | 3399.99 | 1249.84 | 2379.95 |
| Xu, Alicia,11370 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Prasad, Levi,25705 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Ramos, Cindy, G,11361 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Sanz, Ross,11455 | 8142.03 | 0.00 | 3374.99 | 2319.99 | 2447.05 |
| Chen, Clayton, A,15219 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Gutierrez, Francis,25245 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Wang, Curtis, A,13108 | 5718.66 | 0.00 | 0.00 | 2071.42 | 3647.24 |
| Liu, Glenn,18899 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Lu, Sandra, N,13521 | 4514.77 | 0.00 | 0.00 | 4514.77 | 0.00 |
| Sara, Jarrod,20626 | 6038.56 | 0.00 | 3578.27 | 0.00 | 2460.29 |
| Chapman, Jodi, L,22966 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Navarro, Jonathon,18722 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| Wu, Clarence, L,13115 | 6779.42 | 0.00 | 0.00 | 2049.10 | 4730.32 |
| Hill, Adam,18740 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Raji, Brendan,13103 | 6842.60 | 0.00 | 0.00 | 2049.10 | 4793.50 |
| Kapoor, Denise, M,18725 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Raman, Brett, L,22930 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Zhao, Micah,18708 | 6056.51 | 0.00 | 3578.27 | 2478.24 | 0.00 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Campbell, Seth,18716 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 0.00 | 2049.10 | 4744.05 |
| Gao, Jon, C,11456 | 8224.46 | 0.00 | 3399.99 | 2391.43 | 2433.04 |
| Martin, Diane,13958 | 6838.64 | 0.00 | 0.00 | 2049.10 | 4789.54 |
| Gutierrez, Jaime, C,11457 | 8211.48 | 0.00 | 3374.99 | 2359.96 | 2476.53 |
| Xu, Sharon, A,23344 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Liu, Lacey, L,23545 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Wu, Brittney,23418 | 3400.02 | 0.00 | 0.00 | 3400.02 | 0.00 |
| Wilson, Sam,25947 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Ye, Damien, M,13620 | 6848.07 | 0.00 | 0.00 | 2049.10 | 4798.97 |
| Chen, Steve, R,18902 | 4186.23 | 0.00 | 3578.27 | 607.96 | 0.00 |
| Sharma, Jerry, C,13651 | 6812.12 | 0.00 | 0.00 | 2049.10 | 4763.02 |
| He, Louis, E,21211 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
Generated 2025-11-07 02:42:46.774 UTC