[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 750 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lopez, Carmen, S,13528 | 4531.04 | 0.00 | 0.00 | 2071.42 | 2459.62 |
| She, Jessie, A,13650 | 6768.14 | 0.00 | 0.00 | 2049.10 | 4719.04 |
| Coleman, Dalton, M,23412 | 3586.81 | 0.00 | 0.00 | 3586.81 | 0.00 |
| Dominguez, Kristi, M,13644 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Martinez, Pamela, A,13529 | 4614.86 | 0.00 | 0.00 | 2071.42 | 2543.44 |
| Kumar, Misty, H,25010 | 1540.43 | 0.00 | 0.00 | 1000.44 | 539.99 |
| Wood, Sydney,23310 | 3333.32 | 0.00 | 0.00 | 3333.32 | 0.00 |
| White, Taylor, D,25011 | 1589.40 | 0.00 | 0.00 | 1000.44 | 588.96 |
| Gomez, Kendra, J,23320 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Campbell, Jason, J,13625 | 6962.14 | 0.00 | 0.00 | 2049.10 | 4913.04 |
| Hall, Amanda,26656 | 1345.95 | 0.00 | 0.00 | 1345.95 | 0.00 |
| Chen, Tiffany, A,23348 | 4167.31 | 0.00 | 0.00 | 2443.35 | 1723.96 |
| Moyer, Mario,23420 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| King, Evan,16637 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Dominguez, Robin,16685 | 4183.23 | 3578.27 | 0.00 | 0.00 | 604.96 |
| Liang, Alejandro, W,29193 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Kumar, Jaime, O,29061 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Deng, Kurt, D,13635 | 215.74 | 0.00 | 0.00 | 32.27 | 183.47 |
| Hernandez, Raquel, W,13997 | 4586.35 | 0.00 | 0.00 | 2071.42 | 2514.93 |
| Navarro, Javier,14131 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Kumar, Alejandro,14055 | 5177.40 | 0.00 | 0.00 | 2049.10 | 3128.30 |
| Ramos, Tanya, R,14045 | 6804.13 | 0.00 | 0.00 | 2049.10 | 4755.03 |
| Cook, Isaac, M,13994 | 4528.75 | 0.00 | 0.00 | 2071.42 | 2457.33 |
| Zhang, Lacey, L,14127 | 3809.57 | 0.00 | 0.00 | 3809.57 | 0.00 |
| Wang, Nathan,14039 | 6808.13 | 0.00 | 0.00 | 2049.10 | 4759.03 |
| Yuan, Tamara, E,21166 | 4909.67 | 0.00 | 2443.35 | 0.00 | 2466.32 |
| Chapman, Pamela, L,27145 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Ruiz, Hector,27592 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jimenez, Julio,24005 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| He, Jessie,29094 | 796.34 | 0.00 | 0.00 | 0.00 | 796.34 |
| Anand, Cassie, M,29342 | 801.83 | 0.00 | 0.00 | 0.00 | 801.83 |
| Malhotra, Mayra, E,15577 | 143.45 | 0.00 | 0.00 | 0.00 | 143.45 |
| Fernandez, Kristi,19585 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Fernandez, Geoffrey,19963 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Gao, Todd, M,11061 | 8129.02 | 3374.99 | 0.00 | 2369.96 | 2384.07 |
| Ye, Ramon,11357 | 4943.80 | 0.00 | 3374.99 | 0.00 | 1568.81 |
| Washington, Julian, C,23330 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Mr., Sands, Patrick,14063 | 5676.25 | 0.00 | 0.00 | 3321.26 | 2354.99 |
| Huang, Lisa, L,14102 | 3667.23 | 0.00 | 0.00 | 2910.90 | 756.33 |
| Liu, Steve, V,23523 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Mitchell, Wyatt, A,14048 | 5123.74 | 0.00 | 0.00 | 2071.42 | 3052.32 |
| Suarez, Ruben,14031 | 6964.42 | 0.00 | 0.00 | 2049.10 | 4915.32 |
| Lopez, Bruce,23540 | 3626.82 | 0.00 | 0.00 | 2443.35 | 1183.47 |
| Serrano, Joanna, J,26663 | 1976.94 | 0.00 | 0.00 | 782.99 | 1193.95 |
| Gonzalez, Shane, Y,14125 | 3772.41 | 0.00 | 0.00 | 3772.41 | 0.00 |
| Rubio, Derrick, P,23525 | 3302.05 | 0.00 | 0.00 | 3302.05 | 0.00 |
| Pal, Donna, S,23572 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Gao, Jorge,23573 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Vazquez, Eddie, T,14012 | 5249.92 | 0.00 | 0.00 | 2049.10 | 3200.82 |
| Raje, Misty, A,23544 | 3971.01 | 0.00 | 0.00 | 2181.56 | 1789.45 |
| Li, Stacey,14064 | 5694.21 | 0.00 | 0.00 | 2071.42 | 3622.79 |
| Anand, Leonard,14316 | 3797.37 | 0.00 | 0.00 | 2049.10 | 1748.27 |
| Rodriguez, Kristi,14345 | 3639.92 | 0.00 | 0.00 | 2049.10 | 1590.82 |
| Li, Alvin,26764 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Perez, Dominique,12344 | 68.70 | 0.00 | 0.00 | 32.27 | 36.43 |
| Alvarez, Linda,14047 | 5643.54 | 0.00 | 0.00 | 3321.26 | 2322.28 |
| Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Hernandez, Max,18192 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Guo, Trisha,18253 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Yuan, Carl, P,24160 | 3046.84 | 0.00 | 0.00 | 2443.35 | 603.49 |
| Mehta, Heidi,14226 | 5656.24 | 0.00 | 0.00 | 2071.42 | 3584.82 |
| Murphy, Grace, J,23655 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Ramos, Byron,14306 | 3653.23 | 0.00 | 0.00 | 2071.42 | 1581.81 |
| Alvarez, Jessie,14324 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
| Scott, Alex, T,14348 | 2989.38 | 0.00 | 0.00 | 2071.42 | 917.96 |
| Andersen, Colin,25053 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Ruiz, Frank, M,14260 | 3716.23 | 0.00 | 0.00 | 2964.89 | 751.34 |
| Chandra, Jermaine, A,14299 | 5108.76 | 0.00 | 0.00 | 2071.42 | 3037.34 |
| Deng, Peter, A,24006 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Shen, Cristina,26768 | 1371.95 | 0.00 | 0.00 | 1371.95 | 0.00 |
| Rai, Willie,14673 | 5117.75 | 0.00 | 0.00 | 2071.42 | 3046.33 |
| Gonzalez, Jay, C,14238 | 5642.90 | 0.00 | 0.00 | 2049.10 | 3593.80 |
| Wang, Micah, C,14676 | 5188.41 | 0.00 | 0.00 | 2049.10 | 3139.31 |
| Gomez, Jerome, J,25057 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Fernandez, Lydia, M,14523 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Zeng, Jon, O,14310 | 5200.66 | 0.00 | 0.00 | 2071.42 | 3129.24 |
| Fernandez, Rachael, M,23993 | 3072.32 | 0.00 | 0.00 | 2443.35 | 628.97 |
| Jai, Bonnie,11977 | 8212.50 | 0.00 | 3399.99 | 0.00 | 4812.51 |
| Russell, Ashley,12000 | 8183.00 | 0.00 | 3399.99 | 0.00 | 4783.01 |
| Nara, Tommy,16729 | 38.92 | 0.00 | 0.00 | 0.00 | 38.92 |
| Blanco, Philip, M,15603 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Moore, Devin, J,16167 | 102.57 | 0.00 | 0.00 | 0.00 | 102.57 |
| Diaz, Jay,16692 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Sara, Donald, M,25114 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| He, Louis, E,21211 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Cai, Shannon,26156 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Dominguez, Roy, C,29189 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Nara, Ricardo,28934 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Torres, Kellie,19569 | 112.24 | 0.00 | 0.00 | 0.00 | 112.24 |
| Diaz, Derrick, R,14853 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| Vance, Monica, G,12338 | 8265.00 | 0.00 | 3374.99 | 0.00 | 4890.01 |
| Prasad, Marco, C,15606 | 115.93 | 0.00 | 0.00 | 77.96 | 37.97 |
| Rubio, Juan,16170 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Romero, Roberto, A,18285 | 141.55 | 0.00 | 0.00 | 0.00 | 141.55 |
| Tang, Terrence, R,17303 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Prasad, Arthur,14275 | 5158.37 | 0.00 | 0.00 | 2800.44 | 2357.93 |
| Ramos, Briana, J,14303 | 3636.91 | 0.00 | 0.00 | 2049.10 | 1587.81 |
| She, Jerry, C,14277 | 5196.74 | 0.00 | 0.00 | 2071.42 | 3125.32 |
| Alvarez, Randall,26750 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Raman, César, C,24004 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Rodriguez, Heidi, L,25120 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Evans, Jonathan, D,15185 | 4393.70 | 0.00 | 0.00 | 2071.42 | 2322.28 |
| Miller, Zachary, M,15169 | 2919.89 | 0.00 | 0.00 | 2071.42 | 848.47 |
| Gutierrez, Latasha, C,15022 | 2999.91 | 0.00 | 0.00 | 2071.42 | 928.49 |
| Lopez, Deanna, L,25119 | 2148.21 | 0.00 | 0.00 | 1000.44 | 1147.77 |
| Zhu, Lacey,24167 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Luo, Kenneth, S,15211 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Jai, Tommy, C,15027 | 2853.57 | 0.00 | 0.00 | 2049.10 | 804.47 |
| Shan, Connor, C,18901 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Lin, Margaret, C,18306 | 87.77 | 0.00 | 0.00 | 0.00 | 87.77 |
| Carlson, Jose,19954 | 74.45 | 0.00 | 0.00 | 60.47 | 13.98 |
| Sara, Edgar, A,11104 | 8173.03 | 0.00 | 3399.99 | 2334.98 | 2438.06 |
| Liu, Jessie,11106 | 8079.05 | 0.00 | 3399.99 | 2294.99 | 2384.07 |
| Rai, Sharon,20225 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| 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 |
| Rubio, Larry,14223 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Subram, Ronald, P,27733 | 157.29 | 0.00 | 0.00 | 0.00 | 157.29 |
| Wang, Laura, L,26146 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ashe, Marshall,28932 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Blanco, Jimmy, V,14013 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Evans, Xavier,19098 | 122.24 | 0.00 | 0.00 | 0.00 | 122.24 |
| Blanco, Lee, M,16660 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Andersen, Nina,18338 | 6124.58 | 0.00 | 3578.27 | 0.00 | 2546.31 |
| Zhu, Clarence, A,18462 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
Generated 2025-11-03 11:34:51.850 UTC