[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 22 < SKIP 500 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Pal, Arturo, P,29303 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Kovár, Whitney,13105 | 5585.45 | 0.00 | 0.00 | 2049.10 | 3536.35 |
| Tang, Leonard, L,28109 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Gonzalez, Tabitha, A,26136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Kumar, Tommy,17297 | 100.25 | 0.00 | 0.00 | 0.00 | 100.25 |
| Xie, Alicia,26427 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Mehta, Cassandra,23014 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Henderson, Xavier, K,12993 | 96.25 | 0.00 | 0.00 | 0.00 | 96.25 |
| Price, Deb,24502 | 3623.32 | 0.00 | 0.00 | 2443.35 | 1179.97 |
| She, Keith, L,26563 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Sun, Tamara, L,19976 | 44.04 | 0.00 | 0.00 | 0.00 | 44.04 |
| Jai, Latoya, S,21229 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Barnes, Angelica,15128 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Xie, Ricardo,18710 | 6098.58 | 0.00 | 3578.27 | 0.00 | 2520.31 |
| Patel, Douglas,17927 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Ruiz, Krista, C,13081 | 6772.15 | 0.00 | 0.00 | 2049.10 | 4723.05 |
| Romero, Lance,18310 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Prasad, Denise,18294 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Simpson, Sharon, L,25123 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lopez, Savannah,25709 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| She, Maurice,22917 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chen, Clarence, R,15147 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| Ramos, Leslie,15733 | 4443.55 | 0.00 | 0.00 | 2049.10 | 2394.45 |
| Liu, Jessie,11106 | 8079.05 | 0.00 | 3399.99 | 2294.99 | 2384.07 |
| He, Jorge,20268 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Sanders, Charles, E,21967 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Gill, Gina, F,24177 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Miller, Edward,11368 | 5106.24 | 0.00 | 3374.99 | 0.00 | 1731.25 |
| Ramos, Michele, J,19574 | 96.74 | 0.00 | 0.00 | 0.00 | 96.74 |
| Martinez, Harold, J,20604 | 93.49 | 0.00 | 0.00 | 0.00 | 93.49 |
| Xu, Cedric,18198 | 4143.25 | 0.00 | 3578.27 | 0.00 | 564.98 |
| Srini, Jay, M,18326 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Jiménez, Bruce, L,23640 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| King, Jesse, J,14665 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Lopez, Adriana, A,12002 | 8145.33 | 0.00 | 3374.99 | 0.00 | 4770.34 |
| Sanz, Meghan, L,28352 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Johnson, Emma, M,15136 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Fernandez, Nancy,14854 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Gao, Jorge,23573 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Serrano, Kristine,28940 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Hernandez, Victor, T,23537 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Ms., Sanchez, Madalena, J.,13020 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Shan, Jenny, W,16706 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Brown, Cameron, D,13041 | 153.95 | 0.00 | 0.00 | 0.00 | 153.95 |
| Gao, Todd, M,11061 | 8129.02 | 0.00 | 3374.99 | 2369.96 | 2384.07 |
| Flores, Noah,17256 | 4362.74 | 0.00 | 3578.27 | 0.00 | 784.47 |
| Weber, Chelsea,29191 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Shen, Kathryn, R,21957 | 4919.30 | 0.00 | 0.00 | 2443.35 | 2475.95 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 0.00 | 2049.10 | 4744.05 |
| Suarez, Nelson,27355 | 1383.45 | 0.00 | 0.00 | 782.99 | 600.46 |
| Chander, Alison,18249 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Kapoor, Regina,15810 | 67.17 | 0.00 | 0.00 | 0.00 | 67.17 |
| Jimenez, Krista,18257 | 115.95 | 0.00 | 0.00 | 0.00 | 115.95 |
| Moreno, Melody, R,11760 | 274.92 | 0.00 | 0.00 | 0.00 | 274.92 |
| Yuan, Marshall, P,19978 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Jones, Nathan,15024 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Chen, Jaclyn, C,22847 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Sai, Ronald, B,13643 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Alvarez, Kristy,15588 | 4486.07 | 0.00 | 0.00 | 2049.10 | 2436.97 |
| Chavez, Clayton,21949 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Xie, Dawn,21391 | 29.99 | 0.00 | 0.00 | 29.99 | 0.00 |
| Torres, Kari,18486 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Luo, Lacey,24175 | 2743.04 | 0.00 | 0.00 | 2181.56 | 561.48 |
| Carlson, Jonathon, N,17073 | 78.97 | 0.00 | 0.00 | 0.00 | 78.97 |
| Diaz, Gary,27482 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Prasad, Ross,28963 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Ye, Amy,11073 | 191.90 | 0.00 | 0.00 | 0.00 | 191.90 |
| Nara, Latoya, J,18208 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Green, Jennifer,12571 | 2641.39 | 0.00 | 2071.42 | 0.00 | 569.97 |
| Ashe, Joanna, F,20997 | 2744.52 | 0.00 | 2181.56 | 0.00 | 562.96 |
| Gutierrez, Micheal, S,27299 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Serrano, Alfredo,21258 | 3936.54 | 0.00 | 2181.56 | 0.00 | 1754.98 |
| Sun, Todd,22018 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Prasad, George, C,15767 | 4379.09 | 0.00 | 0.00 | 2049.10 | 2329.99 |
| Butler, Jason,17510 | 4369.74 | 0.00 | 3578.27 | 0.00 | 791.47 |
| Rai, Raul, R,15133 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Li, Jaclyn,18281 | 6081.10 | 0.00 | 3578.27 | 0.00 | 2502.83 |
| Zhou, Alan,16480 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Shen, Misty, S,25019 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Lopez, Ross,18443 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Lopez, Virginia, J,27338 | 1339.92 | 0.00 | 0.00 | 782.99 | 556.93 |
| Barnes, Alexia, D,15231 | 59.48 | 0.00 | 0.00 | 0.00 | 59.48 |
| Zhou, Heather, M,24914 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Zeng, Amy,24242 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Gutierrez, Ricky,19773 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Madan, Francisco, S,25706 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Romero, Jacquelyn,25815 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Navarro, Renee,15793 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Gutierrez, Meredith, T,11111 | 8137.00 | 0.00 | 3399.99 | 0.00 | 4737.01 |
| Subram, Candace,27585 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Kumar, Ricardo, K,14133 | 3764.07 | 0.00 | 0.00 | 2049.10 | 1714.97 |
| Vance, Phillip,29308 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Jimenez, Naomi,24922 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Hu, Cara,20608 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Jai, Gregory,16342 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Huang, Arturo,28952 | 2473.04 | 0.00 | 0.00 | 0.00 | 2473.04 |
| Zhou, Gilbert,24475 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Gutierrez, Francis,25245 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Powell, Jeremy,11048 | 6498.24 | 0.00 | 3374.99 | 0.00 | 3123.25 |
| Kennedy, Devon, J,13133 | 6813.12 | 0.00 | 0.00 | 2049.10 | 4764.02 |
| Malhotra, Kristina,25031 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Kapoor, Candace,18282 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Rana, Pedro, F,13970 | 6843.14 | 0.00 | 0.00 | 2049.10 | 4794.04 |
| Carson, Kristin, C,24459 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Moore, Nathan, N,28323 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Stone, Brenda, J,12697 | 296.19 | 0.00 | 0.00 | 0.00 | 296.19 |
| Sanz, Eddie, A,19580 | 173.93 | 0.00 | 0.00 | 0.00 | 173.93 |
| Zhou, Clayton,27348 | 1382.46 | 0.00 | 0.00 | 782.99 | 599.47 |
| Romero, Joy, D,24886 | 80.47 | 0.00 | 0.00 | 0.00 | 80.47 |
| Wang, Crystal, C,11112 | 8295.02 | 0.00 | 3374.99 | 0.00 | 4920.03 |
| She, Candice,29178 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Cai, Curtis,21259 | 3907.54 | 0.00 | 0.00 | 2181.56 | 1725.98 |
| Carlson, Alfredo,16178 | 108.85 | 0.00 | 0.00 | 0.00 | 108.85 |
| Shan, Kristin,23416 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Alvarez, Tyrone, K,27693 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Lopez, Clifford, E,27709 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Perez, Bryant, L,15042 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Bradley, Diane, A,15140 | 62.27 | 0.00 | 0.00 | 27.28 | 34.99 |
| Yang, Randy, E,24000 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Chander, Julie, E,18763 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Martin, Beth, K,23317 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Subram, Francisco, A,21897 | 4909.67 | 0.00 | 0.00 | 2443.35 | 2466.32 |
| Gonzalez, Kristopher, C,19264 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Tang, Grant, H,11466 | 90.19 | 0.00 | 0.00 | 0.00 | 90.19 |
| Suarez, Melinda,29181 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
Generated 2025-12-23 07:19:16.526 UTC