[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 562 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhou, Warren,19791 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Nara, Karla, C,25827 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Sanders, Gabriella,11906 | 8151.00 | 0.00 | 3374.99 | 0.00 | 4776.01 |
| Alvarez, Stacy,11901 | 8248.01 | 0.00 | 3399.99 | 0.00 | 4848.02 |
| Gutierrez, Ricky,19773 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Liu, Darryl,19947 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Cook, Kaylee,11904 | 8214.50 | 0.00 | 3399.99 | 0.00 | 4814.51 |
| Patel, Ruben, I,19765 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Gonzalez, Tina,19653 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| She, Nichole, M,11909 | 8105.31 | 0.00 | 3374.99 | 0.00 | 4730.32 |
| Carlson, Byron,11900 | 8257.01 | 0.00 | 3399.99 | 0.00 | 4857.02 |
| Carlson, Robin,19786 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Gonzalez, Ann,11894 | 8223.00 | 0.00 | 3374.99 | 0.00 | 4848.01 |
| Navarro, Stacy, C,12688 | 6867.44 | 0.00 | 0.00 | 2071.42 | 4796.02 |
| Vazquez, Marc, H,24362 | 3600.77 | 0.00 | 0.00 | 2443.35 | 1157.42 |
| Navarro, Mallory,24365 | 3331.03 | 0.00 | 0.00 | 2181.56 | 1149.47 |
| Wu, Lisa,26158 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Johnsen, Ross,19618 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
| Rivera, Mariah,20261 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Ma, Laura, L,24503 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Ramirez, Cole, E,13616 | 6872.06 | 0.00 | 0.00 | 2049.10 | 4822.96 |
| Natsuhara, Tony,23097 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Prasad, Harold,19608 | 68.45 | 0.00 | 0.00 | 0.00 | 68.45 |
| Moreno, Dana, D,15033 | 3797.40 | 0.00 | 0.00 | 2071.42 | 1725.98 |
| Yang, Stacey,14215 | 5665.89 | 0.00 | 0.00 | 2049.10 | 3616.79 |
| She, Susan,19956 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Guo, Jamie,20151 | 4152.73 | 0.00 | 3578.27 | 0.00 | 574.46 |
| Luo, Raul, Q,20154 | 4153.25 | 0.00 | 3578.27 | 0.00 | 574.98 |
| Chande, Katrina, L,19968 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Ramos, Dana, D,25919 | 1248.08 | 0.00 | 699.10 | 0.00 | 548.98 |
| Wang, Valerie,20217 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Raji, Dawn, C,20244 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Gutierrez, Orlando,25920 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Huang, Dawn, E,11943 | 4734.29 | 0.00 | 3374.99 | 539.99 | 819.31 |
| Fernandez, George,19974 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Xu, Randy, S,11969 | 8173.02 | 0.00 | 3399.99 | 0.00 | 4773.03 |
| Hernandez, Kristine,14286 | 5234.40 | 0.00 | 0.00 | 2049.10 | 3185.30 |
| Raje, Jenny,20233 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Chandra, Tina, S,13974 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Zheng, Erica, K,23643 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Fernandez, Arthur, J,22399 | 2785.05 | 0.00 | 0.00 | 2181.56 | 603.49 |
| Chander, Shawn, S,20216 | 5338.74 | 0.00 | 3578.27 | 0.00 | 1760.47 |
| Munoz, Latasha,11967 | 8153.02 | 0.00 | 3374.99 | 0.00 | 4778.03 |
| Mehta, Evelyn, S,20420 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Goel, Dale, M,20416 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Perez, Johnathan, D,20426 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Romero, Marie,20424 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Martinez, Ethan, C,20260 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Tang, April, A,25935 | 1256.03 | 0.00 | 699.10 | 0.00 | 556.93 |
| Torres, Sabrina, E,20425 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Gutierrez, Pedro, S,15224 | 71.92 | 0.00 | 0.00 | 0.00 | 71.92 |
| Serrano, Jacquelyn,21963 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Russell, Cassidy, N,26144 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Gray, Morgan,28307 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Blanco, Jimmy, V,14013 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Perez, Stefanie,27518 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Guo, Autumn, A,14213 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Simmons, Jacqueline, W,13137 | 177.94 | 0.00 | 0.00 | 0.00 | 177.94 |
| Ward, Katelyn,20258 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Malhotra, Veronica, J,25922 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Madan, Raymond, W,20819 | 4181.76 | 0.00 | 3578.27 | 0.00 | 603.49 |
| Yuan, Deborah,12021 | 4043.46 | 0.00 | 3399.99 | 0.00 | 643.47 |
| Luo, Shawn,12246 | 3947.25 | 0.00 | 3374.99 | 0.00 | 572.26 |
| Rubio, Sabrina, A,20984 | 4153.25 | 0.00 | 3578.27 | 0.00 | 574.98 |
| Collins, Andrea,12250 | 3964.98 | 0.00 | 3399.99 | 0.00 | 564.99 |
| Sanders, Devin, J,12014 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Morcos, Hany,20821 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Lewis, Kayla,12013 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Garcia, Ruth,20623 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Sandberg, Kristine,12241 | 3989.46 | 0.00 | 3399.99 | 0.00 | 589.47 |
| Liang, Gilbert,12242 | 3948.97 | 0.00 | 3374.99 | 0.00 | 573.98 |
| Shan, Deborah,20624 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Arun, Gerald,25940 | 1277.56 | 0.00 | 699.10 | 0.00 | 578.46 |
| Johnson, Chloe, L,20617 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Yuan, Lacey, W,12349 | 6772.14 | 0.00 | 2049.10 | 0.00 | 4723.04 |
| Munoz, Casey, W,12570 | 2654.06 | 0.00 | 2049.10 | 0.00 | 604.96 |
| Lopez, Barry, R,26020 | 1932.46 | 0.00 | 782.99 | 0.00 | 1149.47 |
| Xu, Rafael, N,21195 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Chen, Bianca,24891 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Mitchell, Wyatt, A,14048 | 5123.74 | 0.00 | 0.00 | 2071.42 | 3052.32 |
| Jones, Emily,16659 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Weber, Cynthia,26921 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Huang, Eugene, L,11001 | 6383.88 | 3374.99 | 0.00 | 2419.93 | 588.96 |
| Zhang, Cara,12351 | 117.97 | 0.00 | 0.00 | 0.00 | 117.97 |
| Patel, Deanna, H,27354 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Vazquez, Eddie, T,14012 | 5249.92 | 0.00 | 0.00 | 2049.10 | 3200.82 |
| Chander, Damien,11080 | 8204.02 | 0.00 | 3374.99 | 2359.98 | 2469.05 |
| Hernandez, Jésus, M,24267 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Patel, Virginia, R,11366 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Arthur, Cassandra, M,22410 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Lin, Clarence,29069 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Jimenez, Felicia, L,11075 | 8068.03 | 0.00 | 3374.99 | 2294.99 | 2398.05 |
| Malhotra, Ruben, M,17074 | 90.25 | 0.00 | 0.00 | 58.98 | 31.27 |
| Taylor, Logan,13522 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Gill, Billy, L,16700 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Carson, Kelvin, A,11995 | 8249.01 | 0.00 | 3399.99 | 0.00 | 4849.02 |
| Martinez, Roy, J,13969 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Navarro, Monique, R,15240 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Blanco, Hector, J,22938 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Chande, Tonya,11992 | 8123.03 | 0.00 | 3399.99 | 0.00 | 4723.04 |
| Arthur, Rebekah,22939 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Gonzalez, Cynthia,15787 | 167.93 | 0.00 | 0.00 | 0.00 | 167.93 |
| Xu, Alison,14227 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Chavez, Karla, K,16704 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Liu, Trisha, V,20214 | 5304.25 | 0.00 | 3578.27 | 0.00 | 1725.98 |
| Deng, Devon, H,19967 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Zhou, Jon, L,11060 | 8153.02 | 0.00 | 3399.99 | 2319.99 | 2433.04 |
| Lopez, Francisco, L,18714 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Lopez, Jay, A,19965 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Jimenez, Tanya, D,19970 | 6099.10 | 0.00 | 3578.27 | 0.00 | 2520.83 |
| Lee, Grace, J,28318 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Shen, Carly,22915 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Rowe, Jacquelyn, I,13615 | 146.91 | 0.00 | 0.00 | 7.95 | 138.96 |
| Rubio, Walter, R,25912 | 63.47 | 0.00 | 0.00 | 0.00 | 63.47 |
| Carson, Mitchell,13623 | 99.20 | 0.00 | 0.00 | 0.00 | 99.20 |
| Wang, Laura, L,26146 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Blanco, Lee, M,16660 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Martin, Pedro, B,28103 | 1214.85 | 0.00 | 0.00 | 0.00 | 1214.85 |
| Goldstein, Brendan,13518 | 2638.36 | 0.00 | 0.00 | 2049.10 | 589.26 |
| Blanco, Kristi,15464 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Ye, Dennis, M,16638 | 5974.23 | 0.00 | 3578.27 | 0.00 | 2395.96 |
| Romero, Wendy, H,11372 | 4965.81 | 0.00 | 3374.99 | 0.00 | 1590.82 |
| Ramos, Roy, A,24482 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Ramos, Roberto, M,13159 | 208.18 | 0.00 | 0.00 | 0.00 | 208.18 |
Generated 2025-12-22 00:29:33.373 UTC