[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 120 >
120 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rubio, Desiree, D,21189 | 4208.31 | 0.00 | 2443.35 | 0.00 | 1764.96 |
| Diaz, Derrick, R,14853 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| Gill, Javier,15645 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 |
| Madan, Carla, D,28135 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Suri, Cesar,17512 | 4170.54 | 0.00 | 3578.27 | 592.27 | 0.00 |
| Washington, Marcus,28329 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Hernandez, Hailey, A,18727 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Pal, Drew,11902 | 63.04 | 0.00 | 0.00 | 0.00 | 63.04 |
| Lewis, Justin, L,28303 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Allen, Devin,15806 | 102.85 | 0.00 | 0.00 | 0.00 | 102.85 |
| Alvarez, Kari, C,11108 | 8124.04 | 0.00 | 3374.99 | 2329.99 | 2419.06 |
| Blanco, Monique, W,14103 | 3612.22 | 0.00 | 0.00 | 2071.42 | 1540.80 |
| Nara, Calvin, J,11367 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Sharma, Edwin, K,25021 | 1554.41 | 0.00 | 0.00 | 1000.44 | 553.97 |
| Liang, Darryl,26658 | 1390.95 | 0.00 | 0.00 | 1390.95 | 0.00 |
| Diaz, Frank, F,29086 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Nara, Dawn, M,21891 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Dominguez, Andy, L,14126 | 135.55 | 0.00 | 0.00 | 0.00 | 135.55 |
| Raman, Brett, L,22930 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Yuan, Warren, P,19091 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Goel, Bridget,26134 | 1926.45 | 0.00 | 782.99 | 0.00 | 1143.46 |
| Alvarez, Albert, R,16624 | 5938.25 | 3578.27 | 0.00 | 0.00 | 2359.98 |
| Sara, Barry, R,13965 | 6872.39 | 0.00 | 0.00 | 2071.42 | 4800.97 |
| Barnes, Julia, R,21999 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Vazquez, Marvin, K,21953 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| She, Brittney, M,22942 | 3971.53 | 0.00 | 0.00 | 2181.56 | 1789.97 |
| Torres, Gina,17904 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Cox, Angel, M,18793 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Sara, Candace,21380 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Alvarez, Francis,21552 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Stone, Keith,17331 | 40.96 | 0.00 | 0.00 | 0.00 | 40.96 |
| Ma, Jeffery,18264 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Suarez, Jerome, L,20622 | 6139.59 | 0.00 | 3578.27 | 0.00 | 2561.32 |
| Anderson, Emily, M,25220 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Baker, Luke, J,22952 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Yang, Wesley, K,15127 | 5182.73 | 0.00 | 0.00 | 2071.42 | 3111.31 |
| Torres, Danielle, G,22947 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Romero, Marie,20424 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Zeng, Warren, R,24477 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Romero, Billy,20419 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Srini, Kristopher, A,23997 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rubio, Kendra,17047 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Diaz, Megan, A,24303 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Zhao, Colin, D,24241 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Zhu, Sandra, V,15732 | 4376.40 | 0.00 | 0.00 | 2071.42 | 2304.98 |
| Rana, Ivan, K,18196 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Zeng, Dawn, D,29455 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Lin, Alan,22973 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zeng, Louis,18903 | 4143.74 | 0.00 | 3578.27 | 565.47 | 0.00 |
| Chander, Damien,11080 | 8204.02 | 0.00 | 3374.99 | 2359.98 | 2469.05 |
| Scott, Savannah, E,16929 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Rana, Whitney, A,13006 | 6762.15 | 0.00 | 0.00 | 2049.10 | 4713.05 |
| Srini, Douglas, M,16733 | 35.26 | 0.00 | 0.00 | 0.00 | 35.26 |
| Foster, Madison,14038 | 6819.12 | 0.00 | 0.00 | 2049.10 | 4770.02 |
| Sai, Clifford,25128 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Sanz, Monique, R,24273 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Perez, Evelyn,14346 | 3583.26 | 0.00 | 0.00 | 2071.42 | 1511.84 |
| Wu, Margaret,28928 | 2473.05 | 0.00 | 0.00 | 0.00 | 2473.05 |
| Deng, Gilbert, C,15765 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Cox, Michelle, E,17328 | 4387.74 | 0.00 | 3578.27 | 0.00 | 809.47 |
| Sun, Suzanne, P,24587 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Navarro, Albert, L,21561 | 4947.78 | 0.00 | 2443.35 | 0.00 | 2504.43 |
| Lal, Karl, R,14264 | 5217.73 | 0.00 | 0.00 | 2822.76 | 2394.97 |
| Raji, Brendan,13103 | 6842.60 | 0.00 | 0.00 | 2049.10 | 4793.50 |
| Zhao, Lacey, M,27713 | 1158.96 | 0.00 | 0.00 | 0.00 | 1158.96 |
| Sanz, Nelson, M,14056 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| She, Derek,15036 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 |
| Roberts, Jordan,23432 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Zhu, Alisha, G,18239 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Garcia, Holly,26558 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Raje, Marshall, J,19267 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Green, Kyle,28328 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhu, Suzanne, E,25112 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Sun, Jenny, L,12253 | 4066.93 | 0.00 | 3399.99 | 0.00 | 666.94 |
| Subram, Martin, S,19590 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Smith, Allen,14072 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Kumar, Tommy,17297 | 100.25 | 0.00 | 0.00 | 0.00 | 100.25 |
| Guo, Cara, R,15721 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Lu, Sandra, N,13521 | 4514.77 | 0.00 | 0.00 | 4514.77 | 0.00 |
| Ms., Seidel, Birgit,16621 | 73.86 | 0.00 | 0.00 | 0.00 | 73.86 |
| Martin, Ruben,22400 | 2737.82 | 0.00 | 0.00 | 2181.56 | 556.26 |
| Parker, Gabriella,21394 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Navarro, Janet, J,28320 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Smith, Andre,21174 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Simmons, Jacqueline, W,13137 | 177.94 | 0.00 | 0.00 | 0.00 | 177.94 |
| Shan, Damien, M,11362 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Chander, Keith, A,24174 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Edwards, Evan, L,21888 | 4925.58 | 0.00 | 0.00 | 2443.35 | 2482.23 |
| Nath, Latoya, A,27582 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Chapman, Clifford, C,21168 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Mehta, Mayra,12998 | 5694.90 | 0.00 | 0.00 | 2049.10 | 3645.80 |
| Navarro, Mathew, A,19673 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Bryant, Fernando, M,20609 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Rai, Alejandro, R,21990 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Hernandez, Jessie, A,24172 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Yuan, Darrell,18271 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Patel, Marco, L,19575 | 60.05 | 0.00 | 0.00 | 0.00 | 60.05 |
| Rana, Bryant,21878 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Ward, Katelyn,20258 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Gutierrez, Kari,15756 | 4441.39 | 0.00 | 0.00 | 2071.42 | 2369.97 |
| Gill, Diana,25710 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Hernandez, Jésus, M,24267 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| He, Aimee, A,11093 | 8180.00 | 0.00 | 3399.99 | 2360.95 | 2419.06 |
| Ruiz, Hector,27592 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Huang, Alan, A,12671 | 6802.13 | 0.00 | 0.00 | 2049.10 | 4753.03 |
| Lee, Austin,26151 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sara, Donald, M,25114 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Chander, Russell, E,29067 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Zeng, Curtis, E,26669 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Hernandez, Brandi, C,21893 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Blanco, Philip, M,15603 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Cai, Candice,26747 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Shen, Leonard, J,24271 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| She, Rafael, I,20152 | 4142.75 | 0.00 | 3578.27 | 0.00 | 564.48 |
| Fernandez, Denise, A,18724 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Munoz, Marvin,14680 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Ramos, Jaime,15720 | 70.22 | 0.00 | 0.00 | 0.00 | 70.22 |
| Jimenez, Kathleen,26654 | 1346.76 | 0.00 | 0.00 | 1346.76 | 0.00 |
| Tang, Bridget,17730 | 4752.23 | 0.00 | 3578.27 | 0.00 | 1173.96 |
| Raji, Maurice, C,20619 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
Generated 2025-12-24 06:19:10.891 UTC