[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 500 < SKIP 1250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rodriguez, Douglas, W,19652 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Nelson, Mary, L,13107 | 5650.90 | 0.00 | 0.00 | 2049.10 | 3601.80 |
| Ye, Alejandro, W,15029 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| She, Nina,22961 | 3891.54 | 0.00 | 0.00 | 2181.56 | 1709.98 |
| Blanco, Orlando,22575 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Arthur, Rebekah,22939 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Jai, Brendan,26755 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Gomez, Arthur,24917 | 2179.91 | 0.00 | 0.00 | 1000.44 | 1179.47 |
| Raje, Ashlee, E,16658 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Thompson, Justin,22954 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Romero, Wendy, H,11372 | 4965.81 | 0.00 | 3374.99 | 0.00 | 1590.82 |
| Cai, Amy,24920 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Rai, Tracy, K,17079 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Shen, Kelsey, R,22921 | 4647.88 | 0.00 | 0.00 | 2181.56 | 2466.32 |
| Garcia, Tina,17231 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Parker, Timothy, C,22943 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Li, Colin, J,18445 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Fernandez, Brandy, B,22958 | 4208.31 | 0.00 | 0.00 | 2443.35 | 1764.96 |
| Alonso, Jonathon, A,15238 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Shan, Carl, D,24919 | 2212.89 | 0.00 | 0.00 | 1000.44 | 1212.45 |
| Martin, Jay,19597 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Kapoor, Bryant,22946 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Liang, Gilbert,12242 | 3948.97 | 0.00 | 3374.99 | 0.00 | 573.98 |
| Kumar, Tonya, A,22934 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Romero, Lance,18310 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Lal, Bradley,13156 | 2663.69 | 0.00 | 0.00 | 2071.42 | 592.27 |
| Raji, Andres, E,13955 | 6888.44 | 0.00 | 0.00 | 2071.42 | 4817.02 |
| Pal, Kara,24916 | 2169.90 | 0.00 | 0.00 | 1000.44 | 1169.46 |
| Lewis, Hannah,26561 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Tang, Wayne, S,13090 | 6812.42 | 0.00 | 0.00 | 2049.10 | 4763.32 |
| Dominguez, Raquel, A,27470 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Zhou, Heather, M,24914 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Ms., Sanchez, Madalena, J.,13020 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 0.00 | 782.99 | 578.46 |
| Simmons, Jordyn,16494 | 5961.20 | 3578.27 | 0.00 | 0.00 | 2382.93 |
| Chande, Kelli, C,22933 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Johnson, Brianna, J,17319 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Tang, Latoya, F,22910 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Cook, Sydney, D,13118 | 5669.90 | 0.00 | 0.00 | 2049.10 | 3620.80 |
| Sara, Ebony,24923 | 2159.40 | 0.00 | 0.00 | 1000.44 | 1158.96 |
| Munoz, Cheryl, C,13632 | 6838.46 | 0.00 | 0.00 | 2071.42 | 4767.04 |
| Moreno, Kristi,23415 | 3588.83 | 0.00 | 0.00 | 2443.35 | 1145.48 |
| Liang, Steve,14317 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Shen, Karla, E,22925 | 134.93 | 0.00 | 0.00 | 0.00 | 134.93 |
| Alonso, Lance, I,14057 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Ruiz, Kristine, J,24607 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ye, Franklin, L,13952 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Goel, Marshall, M,27691 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Zhu, Colin,19973 | 83.44 | 0.00 | 0.00 | 0.00 | 83.44 |
| Ashe, Jimmy, S,28959 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| She, Colin, M,15139 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| She, Candice,29178 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Martinez, Stanley, Z,13668 | 114.21 | 0.00 | 0.00 | 0.00 | 114.21 |
| Huang, Tamara, E,14053 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Nara, Tonya, C,17251 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Zhu, Jorge,26141 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Martin, Ricky, C,16608 | 101.57 | 0.00 | 0.00 | 0.00 | 101.57 |
| Cai, Steve, M,22155 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Flores, Brianna,27706 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Ramos, Jaime,15720 | 70.22 | 0.00 | 0.00 | 0.00 | 70.22 |
| She, Katie, B,11965 | 118.74 | 0.00 | 0.00 | 0.00 | 118.74 |
| Carter, Amber, E,16679 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Martin, Byron, E,25217 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alexander, Alyssa, M,17282 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Shen, Franklin,27144 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Kapoor, Troy, E,24610 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hayes, Alexis,13048 | 190.23 | 0.00 | 0.00 | 0.00 | 190.23 |
| Vazquez, Ross,11148 | 126.24 | 0.00 | 0.00 | 0.00 | 126.24 |
| Garcia, Troy, M,29290 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhou, Arturo, F,27910 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Romero, Jacquelyn,25815 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Chen, Claudia, R,16627 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Guo, Susan, A,26543 | 14.23 | 0.00 | 0.00 | 0.00 | 14.23 |
| Washington, Marcus,28329 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Simpson, Sharon, L,25123 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Shen, Devon, G,27358 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Raji, Grant, R,16185 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Romero, Desiree, J,17239 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Liu, Dawn, C,21960 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Lu, Todd, D,24269 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Raman, Deanna, H,17053 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Sanz, Gerald, J,17060 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Gonzalez, Rebekah, A,16927 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Jai, Brad, C,18267 | 64.98 | 0.00 | 0.00 | 0.00 | 64.98 |
| Lal, Warren, B,25246 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Diaz, Dana, C,12361 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Bradley, Victoria,29454 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Lin, Jorge,27593 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Perez, Ivan, S,23408 | 4218.82 | 0.00 | 0.00 | 2443.35 | 1775.47 |
| She, Marshall, D,18707 | 122.76 | 0.00 | 0.00 | 0.00 | 122.76 |
| Raji, Brad, C,23409 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Raji, Colleen,27707 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Sharma, Jerry, C,13651 | 6812.12 | 0.00 | 0.00 | 2049.10 | 4763.02 |
| Ma, Colin,26428 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Moreno, Bruce, F,26652 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Li, Warren, R,29185 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Raji, Arturo,23998 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Torres, Bailey,18259 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Blanco, Alberto, R,27867 | 2443.55 | 0.00 | 0.00 | 0.00 | 2443.55 |
| Vazquez, Lawrence,19632 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Chander, Russell, E,29067 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Raman, Allen, R,25129 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Anderson, Richard, G,24924 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Chande, Ashlee, N,23096 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Pal, Dustin,26588 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Turner, Lucas,22948 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raman, Jay, M,13618 | 6763.15 | 0.00 | 0.00 | 2049.10 | 4714.05 |
| Patel, Veronica,13963 | 74.48 | 0.00 | 0.00 | 0.00 | 74.48 |
| She, Jessie, A,13650 | 6768.14 | 0.00 | 0.00 | 2049.10 | 4719.04 |
| Xie, Lindsey, M,25132 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Allen, Kaylee,26653 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Vance, Toni, L,23438 | 123.48 | 0.00 | 0.00 | 0.00 | 123.48 |
| Munoz, Meredith,13957 | 5645.24 | 0.00 | 0.00 | 2071.42 | 3573.82 |
| Malhotra, Douglas, L,22960 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chen, Aimee,26591 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Torres, Jacquelyn, P,27464 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Suarez, Rebekah,13649 | 6812.13 | 0.00 | 0.00 | 2049.10 | 4763.03 |
| Yang, Valerie, L,27361 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| White, Taylor, D,25011 | 1589.40 | 0.00 | 0.00 | 1000.44 | 588.96 |
| Becker, Latoya, W,17330 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Alvarez, Carrie, W,23410 | 4016.53 | 0.00 | 0.00 | 2181.56 | 1834.97 |
| Diaz, Danny, C,18190 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Gray, Jeremiah,23331 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Garcia, Jermaine,21566 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Sharma, Arturo,13648 | 6765.44 | 0.00 | 0.00 | 2049.10 | 4716.34 |
Generated 2025-12-24 07:30:43.298 UTC