[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 15 < SKIP 250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Goel, Alisha, C,26767 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Munoz, Diane, R,15795 | 132.44 | 0.00 | 0.00 | 0.00 | 132.44 |
| Cooper, Alex, L,27362 | 1407.45 | 0.00 | 0.00 | 782.99 | 624.46 |
| Ma, Omar, I,15232 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Yuan, Derek, L,27589 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Li, Aimee,17915 | 4792.73 | 0.00 | 3578.27 | 0.00 | 1214.46 |
| Jiménez, Alberto, C,15215 | 4468.56 | 0.00 | 0.00 | 2049.10 | 2419.46 |
| Nath, Rafael,23533 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Zheng, Cara, L,27513 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Wang, Lacey,24173 | 2771.52 | 0.00 | 0.00 | 2181.56 | 589.96 |
| Kumar, Tonya, A,22934 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Morgan, Jared, A,28213 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cai, Shannon,26156 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Chande, Bonnie, L,23992 | 3167.82 | 0.00 | 0.00 | 2443.35 | 724.47 |
| Serrano, Neil, L,17076 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Pal, Peter, K,22848 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Raji, Warren, J,26796 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Gutierrez, Jill, N,26024 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Gao, Rosa,26034 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| She, Derek,15036 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 |
| Gutierrez, Meredith, T,11111 | 8137.00 | 0.00 | 3399.99 | 0.00 | 4737.01 |
| Xu, Colin, C,29461 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Prasad, Ebony,24368 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Jones, Destiny,15171 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Cai, Trisha,18265 | 64.98 | 0.00 | 0.00 | 0.00 | 64.98 |
| Sanz, Craig, M,21993 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Cooper, Cody, A,16028 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Williams, Madison, J,21198 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Perez, Preston,12370 | 61.53 | 0.00 | 0.00 | 0.00 | 61.53 |
| Powell, Thomas, R,18218 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Pal, Derek,24591 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Hernandez, Wendy, A,15124 | 122.44 | 0.00 | 0.00 | 0.00 | 122.44 |
| Tang, Jenny, E,14210 | 5621.24 | 0.00 | 0.00 | 2071.42 | 3549.82 |
| Rodriguez, Frederick, S,24458 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Raji, Donna,24906 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Serrano, Kristi,20616 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Gutierrez, Darren, A,25714 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Huang, Arturo,28952 | 2473.04 | 0.00 | 0.00 | 0.00 | 2473.04 |
| Sai, Molly,14683 | 98.95 | 0.00 | 0.00 | 0.00 | 98.95 |
| Alonso, Brandi,17061 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Sai, Troy,16515 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Ruiz, Naomi,23649 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Serrano, Julio,20992 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Huang, Barbara,26442 | 1919.75 | 0.00 | 0.00 | 782.99 | 1136.76 |
| Kumar, Louis, A,18203 | 4172.25 | 0.00 | 3578.27 | 0.00 | 593.98 |
| Arthur, Jay, R,12694 | 6785.13 | 0.00 | 0.00 | 2049.10 | 4736.03 |
| Raji, Derek, D,19591 | 63.42 | 0.00 | 0.00 | 0.00 | 63.42 |
| Vazquez, Latasha,21952 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Martin, Byron, E,25217 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Romero, Lance,18310 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Perez, Bryant, L,15042 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Lin, Sandra, A,25052 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Simmons, Isabel, H,26432 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Black, Shaun, M,17355 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Munoz, Robyn,14214 | 5759.87 | 0.00 | 0.00 | 2049.10 | 3710.77 |
| Smith, Kristi, M,21962 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Johnston, Joanna, L,17296 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Lopez, Barry, R,26020 | 1932.46 | 0.00 | 782.99 | 0.00 | 1149.47 |
| Lal, Franklin, A,14101 | 3679.90 | 0.00 | 0.00 | 2049.10 | 1630.80 |
| Ramos, Eddie, T,13954 | 128.46 | 0.00 | 0.00 | 0.00 | 128.46 |
| Suri, Stanley, J,27496 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Jai, Karla,18263 | 126.94 | 0.00 | 0.00 | 0.00 | 126.94 |
| Romero, Ruben,16632 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Vazquez, Eddie, T,14012 | 5249.92 | 0.00 | 0.00 | 2049.10 | 3200.82 |
| Raman, Arthur,24001 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Xu, Willie, C,13160 | 6839.46 | 0.00 | 0.00 | 2071.42 | 4768.04 |
| Xu, Rafael, N,21195 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Carlson, Lance, E,22856 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chavez, Colin,16032 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Vance, Marco,13124 | 87.93 | 0.00 | 0.00 | 0.00 | 87.93 |
| Subram, Ivan, A,26147 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Prasad, Levi,25705 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Deng, Peter, A,24006 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| He, Dawn,15647 | 3764.07 | 0.00 | 0.00 | 2049.10 | 1714.97 |
| Vazquez, Bruce, P,20417 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Martin, Adrienne,19952 | 39.46 | 0.00 | 0.00 | 0.00 | 39.46 |
| Sanchez, Cynthia, S,23662 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Lal, Tommy,14516 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Ye, Edwin,18334 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Blanco, Jésus, E,20448 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Patel, Harold,24585 | 3366.02 | 0.00 | 0.00 | 2181.56 | 1184.46 |
| Suri, Erick,16635 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Moreno, Pedro, A,18248 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Romero, Lawrence, C,16687 | 6070.59 | 0.00 | 3578.27 | 2492.32 | 0.00 |
| Gill, Sheila, B,17375 | 24.49 | 0.00 | 0.00 | 0.00 | 24.49 |
| Jai, Tommy, C,15027 | 2853.57 | 0.00 | 0.00 | 2049.10 | 804.47 |
| Carlson, Jonathon, N,17073 | 78.97 | 0.00 | 0.00 | 0.00 | 78.97 |
| Xu, Kathryn,25210 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Sai, Martin, L,21221 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Alonso, Darren,27501 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Goel, Katie, D,27708 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Rana, Ivan, K,18196 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Jimenez, Naomi,24922 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Zhu, Sandra, V,15732 | 4376.40 | 0.00 | 0.00 | 2071.42 | 2304.98 |
| Pal, Nichole, J,26741 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Cook, Sydney, D,13118 | 5669.90 | 0.00 | 0.00 | 2049.10 | 3620.80 |
| Zeng, Brittney, K,13670 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Ye, Brent,28922 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Ms., Ryan, Justine, J.,23079 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Chen, Willie, C,28322 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Munoz, Anne,15798 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Patel, Kaitlin, L,16615 | 95.84 | 0.00 | 0.00 | 0.00 | 95.84 |
| Sharma, Keith,15728 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Smith, Adriana,18702 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Patel, Cynthia, M,15222 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Suri, Ronald,18214 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Yuan, Colin,11758 | 58.05 | 0.00 | 0.00 | 0.00 | 58.05 |
| Barnes, Taylor,14279 | 5137.71 | 0.00 | 0.00 | 2049.10 | 3088.61 |
| Cox, Michelle, E,17328 | 4387.74 | 0.00 | 3578.27 | 0.00 | 809.47 |
| Wang, Shannon,11017 | 6434.31 | 3374.99 | 0.00 | 2316.97 | 742.35 |
| Serrano, Audrey,18337 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Wang, Alan,13622 | 6841.43 | 0.00 | 0.00 | 2071.42 | 4770.01 |
| Hernandez, Diana, F,11038 | 6437.33 | 0.00 | 3374.99 | 0.00 | 3062.34 |
| Romero, Ebony, A,27717 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Perez, Ebony, M,24900 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Subram, Nancy, C,29291 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Deng, Willie, J,27876 | 1214.85 | 0.00 | 0.00 | 0.00 | 1214.85 |
| Gill, Jay,27975 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Clark, Joshua, A,26137 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Suarez, Alfredo,19601 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Diaz, Randall, T,29345 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Dominguez, Roberto, A,26917 | 1339.25 | 0.00 | 0.00 | 782.99 | 556.26 |
| Raman, Jermaine, E,15228 | 4375.06 | 0.00 | 0.00 | 2049.10 | 2325.96 |
| Zeng, Ramon,27979 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Becker, Kara,21167 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
Generated 2026-01-04 08:55:03.252 UTC