[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 2250 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gomez, Marc, J,21880 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Chandra, Monica, H,18898 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Sanchez, Andre,15595 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Lopez, Mayra, E,27356 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Green, Alex, K,20317 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Sanz, Renee, L,14319 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Gonzalez, Edgar, A,15648 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Chande, Cassie,11103 | 8182.50 | 0.00 | 3374.99 | 2388.45 | 2419.06 |
| Morgan, Melissa, M,20222 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Rai, Rafael, H,18715 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Bhat, Yolanda,15225 | 4401.41 | 0.00 | 0.00 | 2071.42 | 2329.99 |
| Yang, Stacey,14215 | 5665.89 | 0.00 | 0.00 | 2049.10 | 3616.79 |
| Ruiz, Carolyn, M,27863 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Romero, Clinton, F,28132 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Shan, Shaun,24274 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Morris, Megan,23641 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Sun, Louis, E,16182 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Lal, Terrence,12369 | 94.23 | 0.00 | 0.00 | 0.00 | 94.23 |
| Malhotra, Kristopher, L,15265 | 2897.57 | 0.00 | 0.00 | 2049.10 | 848.47 |
| Chow, Christy, M,12681 | 6784.13 | 0.00 | 0.00 | 2049.10 | 4735.03 |
| Navarro, Rodney, L,29309 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Rubio, Max, L,19578 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Andersen, Gilbert, T,27353 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Smith, Andre,21174 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Hernandez, Wendy, A,15124 | 122.44 | 0.00 | 0.00 | 0.00 | 122.44 |
| Nara, Tommy,16729 | 38.92 | 0.00 | 0.00 | 0.00 | 38.92 |
| Alvarez, Kristy,15588 | 4486.07 | 0.00 | 0.00 | 2049.10 | 2436.97 |
| Rubio, Tanya, I,15598 | 167.93 | 0.00 | 0.00 | 0.00 | 167.93 |
| Ms., Seidel, Birgit,16621 | 73.86 | 0.00 | 0.00 | 0.00 | 73.86 |
| Patel, Pamela, G,27875 | 1268.84 | 0.00 | 0.00 | 0.00 | 1268.84 |
| Alonso, Meghan, A,24457 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Lin, Jake,24248 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Raje, Darrell,20252 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Liang, Damien, M,22150 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Prasad, Ebony,24368 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Malhotra, Marco, L,29459 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Zeng, Krystal, A,25814 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Hernandez, Jill, L,13003 | 230.25 | 0.00 | 0.00 | 0.00 | 230.25 |
| Suri, Shane, L,25126 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Wood, Julia, L,12356 | 6810.13 | 0.00 | 2049.10 | 0.00 | 4761.03 |
| Lopez, Isaac,27692 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Arun, Levi, A,11074 | 94.19 | 0.00 | 0.00 | 0.00 | 94.19 |
| Malhotra, Harold,15227 | 4469.56 | 0.00 | 0.00 | 2049.10 | 2420.46 |
| Patterson, Melissa, E,12668 | 6839.46 | 0.00 | 0.00 | 2071.42 | 4768.04 |
| Lopez, Clifford, E,27709 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Taylor, Christopher, E,21171 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Rodriguez, Frederick, S,24458 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Mr., Schmidt, Irving, W,12669 | 6791.10 | 0.00 | 0.00 | 2049.10 | 4742.00 |
| Moyer, Meghan,21220 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Perez, Stefanie,27518 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Gill, Diane,15578 | 4509.90 | 0.00 | 0.00 | 2071.42 | 2438.48 |
| Raji, Brendan,13103 | 6842.60 | 0.00 | 0.00 | 2049.10 | 4793.50 |
| Mehta, Patricia, K,29179 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Fernandez, Carolyn, S,29302 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Jai, Katrina,13044 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Yang, Leah, J,15186 | 59.48 | 0.00 | 0.00 | 0.00 | 59.48 |
| Lu, Darryl,27702 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Romero, Ruben,16632 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Raman, Deanna, H,17053 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Cai, Shannon,26156 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Carlson, Lance, E,22856 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Pal, Arturo, P,29303 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Dominguez, Roy, C,29189 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Deng, Colin, B,18299 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Sullivan, Ruth,27723 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Andersen, Nicolas, A,27594 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| She, Ricardo, A,14233 | 78.97 | 0.00 | 0.00 | 0.00 | 78.97 |
| Arthur, Joel,27701 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Ramos, Mary, B,15019 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Henderson, Alexia, M,15717 | 4411.37 | 0.00 | 0.00 | 2049.10 | 2362.27 |
| Shen, Karla, E,22925 | 134.93 | 0.00 | 0.00 | 0.00 | 134.93 |
| Becker, Leonard, C,22405 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Moreno, Lori, M,15226 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Alonso, Lance, I,14057 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Nara, Cassie,13642 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Alan, Bob, A,27366 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Sai, Ivan, E,17300 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Kapoor, Dominic, J,16699 | 67.58 | 0.00 | 0.00 | 0.00 | 67.58 |
| Zhu, Erica,25221 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Ruiz, Kristine, J,24607 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jimenez, Krista,18257 | 115.95 | 0.00 | 0.00 | 0.00 | 115.95 |
| Chow, Warren, L,24305 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Ye, Franklin, L,13952 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Yuan, Melvin,29331 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Price, Trevor, M,15725 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Goel, Marshall, M,27691 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Blanco, Erik, J,29093 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Moreno, Naomi, C,15601 | 4429.57 | 0.00 | 0.00 | 2049.10 | 2380.47 |
| Subram, Ivan, A,26147 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Carlson, Clinton, E,11116 | 148.70 | 0.00 | 0.00 | 0.00 | 148.70 |
| Raji, Damien, K,24282 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Lu, Randy,26441 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Hu, Ramon,23439 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Wu, Marshall, J,15590 | 4440.05 | 0.00 | 0.00 | 2049.10 | 2390.95 |
| Madan, Brandy, A,27687 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Gonzalez, Donald,11079 | 32.96 | 0.00 | 0.00 | 0.00 | 32.96 |
| Luo, Melvin,24366 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Raje, April, R,18744 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Ramos, Lance, S,28949 | 2473.05 | 0.00 | 0.00 | 0.00 | 2473.05 |
| Sara, Ross,24367 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Madan, Joe,29300 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Ruiz, Kari, L,12695 | 192.97 | 0.00 | 0.00 | 0.00 | 192.97 |
| Chandra, Harold, K,17236 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Cai, Steve, M,22155 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Beck, Derek,17322 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Martinez, Heidi, L,22922 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Flores, Brianna,27706 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Chen, Jaclyn, C,22847 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Patel, Cynthia, M,15222 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Cook, Faith,27871 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Garcia, Stefanie, E,27743 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Black, Peter, E,21213 | 64.26 | 0.00 | 0.00 | 0.00 | 64.26 |
| Miller, Taylor, M,18720 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Liang, Alejandro, W,29193 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Zhang, Edwin,15785 | 4454.35 | 0.00 | 0.00 | 2071.42 | 2382.93 |
| Hayes, Edward,15796 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Kapoor, Jarrod,28930 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Serrano, Alberto, L,15800 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Carlson, Joanna,15594 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Black, Wayne, E,25056 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Travers, Alexa, A,24466 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Alexander, Alyssa, M,17282 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Martin, Meghan, B,26773 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ruiz, Marie, J,27498 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
Generated 2025-12-24 06:05:52.502 UTC