[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 1875 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzalez, Kaylee, L,21895 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Martin, Anna, L,20988 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Munoz, Felicia, D,20406 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Sharma, Kelli,26672 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Raji, Karl,29103 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Wang, Micah, C,14676 | 5188.41 | 0.00 | 0.00 | 2049.10 | 3139.31 |
| Weber, Cory,16739 | 81.26 | 0.00 | 0.00 | 31.27 | 49.99 |
| Madan, Michele, A,12676 | 6859.46 | 0.00 | 2071.42 | 0.00 | 4788.04 |
| Deng, Gilbert, C,15765 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| She, Kristin, L,19961 | 97.97 | 0.00 | 0.00 | 0.00 | 97.97 |
| Garcia, Edgar, A,17729 | 110.46 | 0.00 | 0.00 | 0.00 | 110.46 |
| Suarez, Briana, A,15266 | 2935.37 | 0.00 | 0.00 | 2071.42 | 863.95 |
| Li, Justin,14124 | 57.59 | 0.00 | 0.00 | 0.00 | 57.59 |
| Dominguez, Theresa, L,18769 | 5304.25 | 0.00 | 3578.27 | 0.00 | 1725.98 |
| Watson, Adrian, K,13641 | 144.74 | 0.00 | 0.00 | 117.46 | 27.28 |
| Gomez, Erik, T,29180 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Hernandez, Melinda,16174 | 140.45 | 0.00 | 0.00 | 0.00 | 140.45 |
| Morris, Megan,23641 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Srini, Veronica,11996 | 7058.70 | 0.00 | 3374.99 | 1291.77 | 2391.94 |
| Zhu, Christy,11003 | 8139.29 | 3399.99 | 0.00 | 2318.96 | 2420.34 |
| Morgan, Melissa, M,20222 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Lin, Claudia, A,14312 | 191.27 | 0.00 | 0.00 | 166.28 | 24.99 |
| Luo, Ashlee,23534 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Alexander, Alyssa, M,17282 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Huang, Mandy,18266 | 72.26 | 0.00 | 0.00 | 0.00 | 72.26 |
| Andersen, Tonya, N,13527 | 4529.04 | 0.00 | 0.00 | 2049.10 | 2479.94 |
| Shen, Franklin,27144 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Vance, Denise, L,21205 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Xu, Martha, C,16351 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Gill, Orlando,21360 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Green, Jennifer,12571 | 2641.39 | 0.00 | 2071.42 | 0.00 | 569.97 |
| Garcia, Ivan, L,17354 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Martin, Tabitha,25269 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Gutierrez, Erika,17227 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Jai, Warren, S,16483 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Nath, Omar, F,14672 | 5237.72 | 0.00 | 0.00 | 2071.42 | 3166.30 |
| Romero, Deanna, K,23570 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Gutierrez, Jonathon, R,16529 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Xu, Kelsey, W,28220 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Perez, Rachael, D,26762 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Zheng, Aimee, H,24283 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Lu, Warren, H,28925 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Romero, Ricky,21361 | 2997.32 | 0.00 | 2443.35 | 0.00 | 553.97 |
| Beck, Alejandro,11025 | 6576.80 | 3374.99 | 0.00 | 2405.47 | 796.34 |
| Lin, Kelli, A,21392 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Gomez, Gary,15640 | 34.57 | 0.00 | 0.00 | 2.29 | 32.28 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 0.00 | 2049.10 | 4768.04 |
| Raheem, Bethany, L,21965 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Turner, Lucas,22948 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Huang, Damien,16524 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Chandra, Rebekah,28486 | 776.33 | 0.00 | 0.00 | 0.00 | 776.33 |
| Sanchez, Candace, L,21567 | 4973.28 | 0.00 | 2443.35 | 0.00 | 2529.93 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 0.00 | 1179.97 |
| Mitchell, Wyatt, A,14048 | 5123.74 | 0.00 | 0.00 | 2071.42 | 3052.32 |
| Shan, Darrell, J,27345 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Suarez, Nelson,27355 | 1383.45 | 0.00 | 0.00 | 782.99 | 600.46 |
| Lopez, Chelsea,24369 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Madan, Toni,26668 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Luo, Julie, M,29121 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Foster, Hunter, A,20269 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Xie, Dustin,22204 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Alvarez, Tyrone, K,27693 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Bradley, Diane, A,15140 | 62.27 | 0.00 | 0.00 | 27.28 | 34.99 |
| Brown, Cameron, D,13041 | 153.95 | 0.00 | 0.00 | 0.00 | 153.95 |
| Hernandez, Jaime,24170 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Cooper, Allison, J,29294 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Gill, Jay,27975 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Yang, Lacey,13150 | 89.24 | 0.00 | 0.00 | 0.00 | 89.24 |
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 0.00 | 3165.30 |
| Jenkins, Joan,16155 | 4489.57 | 0.00 | 0.00 | 2049.10 | 2440.47 |
| Zhou, Heather, M,24914 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Yuan, Cassie, J,24453 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Barnes, Faith, F,15726 | 4393.36 | 0.00 | 0.00 | 2049.10 | 2344.26 |
| Sara, Candace,21380 | 2735.53 | 0.00 | 2181.56 | 0.00 | 553.97 |
| Roberts, Jordan,23432 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Moreno, Melody, R,11760 | 274.92 | 0.00 | 0.00 | 0.00 | 274.92 |
| Nara, Cedric, M,21875 | 4921.69 | 0.00 | 2443.35 | 0.00 | 2478.34 |
| Garcia, Dominique,16528 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Prasad, Clifford,15604 | 66.75 | 0.00 | 0.00 | 0.00 | 66.75 |
| Shen, Willie, S,18450 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Walker, Anthony, T,25250 | 1883.56 | 699.10 | 0.00 | 0.00 | 1184.46 |
| Lu, Todd, D,24269 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Xu, Shawna,23419 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Perez, Evelyn,14346 | 3583.26 | 0.00 | 0.00 | 2071.42 | 1511.84 |
| Sanz, Gerald, J,17060 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Nath, Ricardo, C,12039 | 8213.00 | 0.00 | 3374.99 | 0.00 | 4838.01 |
| Jimenez, Jill,11028 | 6474.62 | 3374.99 | 0.00 | 0.00 | 3099.63 |
| Xie, Alvin, M,16617 | 160.55 | 0.00 | 0.00 | 69.97 | 90.58 |
| Blanco, Ricky, F,16606 | 67.17 | 0.00 | 0.00 | 0.00 | 67.17 |
| Kumar, Misty, H,25010 | 1540.43 | 0.00 | 0.00 | 1000.44 | 539.99 |
| Luo, Kenneth, S,15211 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Blanco, Alberto, R,27867 | 2443.55 | 0.00 | 0.00 | 0.00 | 2443.55 |
| Gill, Monique, L,17727 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Kumar, Bridget,15802 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Nath, Latoya, A,27582 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Gao, Stacey,16662 | 4355.71 | 3578.27 | 0.00 | 777.44 | 0.00 |
| Gill, Joanna,26186 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Hu, Alejandro,13125 | 138.54 | 0.00 | 0.00 | 0.00 | 138.54 |
| Diaz, Ruben, A,25136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rubio, Natasha, K,13627 | 214.25 | 0.00 | 0.00 | 94.25 | 120.00 |
| Morris, Isaac, G,26439 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Suri, Roy, M,17253 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Zimmerman, Candice, J,26754 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Jimenez, Jaime, E,29095 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Gonzalez, Ebony,11034 | 6491.32 | 3399.99 | 0.00 | 0.00 | 3091.33 |
| Kumar, Barbara, N,27499 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Flores, Alexandra, C,26165 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Ortega, Jessie, J,17051 | 6060.50 | 3578.27 | 0.00 | 0.00 | 2482.23 |
| Adams, Savannah,23536 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Garcia, Toni,22193 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Lal, Devon, L,15237 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Martin, Jay,19597 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Foster, Luke,15137 | 161.94 | 0.00 | 0.00 | 97.97 | 63.97 |
| Zhu, Gilbert,11921 | 63.24 | 0.00 | 0.00 | 0.00 | 63.24 |
| Nara, Tonya, C,17251 | 123.96 | 0.00 | 0.00 | 69.97 | 53.99 |
| Hall, Mary, R,20277 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sun, Jenny, L,12253 | 4066.93 | 0.00 | 3399.99 | 0.00 | 666.94 |
| Rodriguez, Kristi,14345 | 3639.92 | 0.00 | 0.00 | 2049.10 | 1590.82 |
| Shen, Cedric,22209 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Rodriguez, Jarrod,13636 | 6831.76 | 0.00 | 0.00 | 2071.42 | 4760.34 |
| Raje, Johnny,13975 | 5138.72 | 0.00 | 0.00 | 2049.10 | 3089.62 |
| Martinez, Cynthia,22170 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Perez, Joel,16684 | 4158.24 | 3578.27 | 0.00 | 0.00 | 579.97 |
Generated 2025-11-04 09:26:16.413 UTC