[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 1750 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ma, Franklin,24485 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Bailey, Savannah, J,23428 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Fernandez, Lydia, M,14523 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Carlson, Francis,27340 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Ruiz, Naomi,23649 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Washington, Sydney,28924 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nara, Tara,21194 | 3911.53 | 0.00 | 2181.56 | 0.00 | 1729.97 |
| Rubio, Pedro, E,23098 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Patel, Virginia, R,11366 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Lopez, Summer,12036 | 69.55 | 0.00 | 0.00 | 2.29 | 67.26 |
| Hernandez, Julio, J,23078 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Rodriguez, Cynthia, E,22206 | 201.28 | 0.00 | 0.00 | 0.00 | 201.28 |
| Parker, Mason, W,25923 | 6.28 | 0.00 | 0.00 | 6.28 | 0.00 |
| Rivera, Devin, J,25109 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Coleman, Dalton, M,23412 | 3586.81 | 0.00 | 0.00 | 3586.81 | 0.00 |
| Moreno, Dwayne, T,23103 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Suarez, Briana, A,15266 | 2935.37 | 0.00 | 0.00 | 2071.42 | 863.95 |
| Liu, Karen, F,14008 | 63.97 | 0.00 | 0.00 | 34.99 | 28.98 |
| Pais, Wilson, C,13038 | 5581.26 | 0.00 | 0.00 | 2071.42 | 3509.84 |
| Blanco, Lee, M,16660 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Moreno, Kristine, K,28481 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Zhou, Jon, L,11060 | 8153.02 | 3399.99 | 0.00 | 2319.99 | 2433.04 |
| Ramos, Mary, B,15019 | 72.96 | 0.00 | 0.00 | 8.99 | 63.97 |
| Chande, Mindy, V,27472 | 1345.95 | 0.00 | 0.00 | 782.99 | 562.96 |
| She, Bridget, M,19557 | 5358.24 | 0.00 | 3578.27 | 0.00 | 1779.97 |
| Mehta, Preston, G,18692 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Kumar, Cristina, N,15426 | 115.92 | 0.00 | 0.00 | 106.93 | 8.99 |
| Ortega, Linda, C,11756 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Shen, Bonnie,21405 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Yuan, Roger,19622 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
| Lin, Darryl, J,15031 | 41.27 | 0.00 | 0.00 | 32.28 | 8.99 |
| Sanchez, Michele,23543 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Carson, Terrence,11356 | 5069.29 | 0.00 | 3374.99 | 0.00 | 1694.30 |
| Madan, Francisco, S,25706 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Andersen, Gilbert, T,27353 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Mehta, Mayra,12998 | 5694.90 | 0.00 | 0.00 | 2049.10 | 3645.80 |
| Liu, Candice,28720 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Chander, Shawn, S,20216 | 5338.74 | 0.00 | 3578.27 | 0.00 | 1760.47 |
| Rodriguez, Bobby,15752 | 4408.69 | 0.00 | 0.00 | 2071.42 | 2337.27 |
| Andersen, Ashlee, J,11059 | 116.93 | 0.00 | 0.00 | 116.93 | 0.00 |
| Chavez, Jodi, A,18909 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Wang, Laura, L,26146 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Martinez, Tyler, T,28201 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Li, Glenn, A,29295 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Ramos, Craig,14209 | 193.97 | 0.00 | 0.00 | 4.99 | 188.98 |
| Carlson, Jose,19954 | 74.45 | 0.00 | 0.00 | 60.47 | 13.98 |
| Ramirez, Jessica, R,29192 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Zheng, Jeffery, W,15030 | 3786.39 | 0.00 | 0.00 | 2071.42 | 1714.97 |
| Fernandez, Geoffrey,19963 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Sanchez, Michelle, R,26569 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Yuan, Kathryn, L,23106 | 3956.01 | 0.00 | 0.00 | 2181.56 | 1774.45 |
| Andersen, Jenny,20259 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Moreno, Leslie, C,11114 | 122.89 | 0.00 | 0.00 | 7.95 | 114.94 |
| Jimenez, Krista,18257 | 115.95 | 0.00 | 0.00 | 106.96 | 8.99 |
| Alvarez, Stacy,11901 | 8248.01 | 0.00 | 3399.99 | 0.00 | 4848.02 |
| Black, Tracy, B,24903 | 2164.91 | 0.00 | 0.00 | 2164.91 | 0.00 |
| Thomas, Christopher, M,20242 | 6068.45 | 0.00 | 3578.27 | 0.00 | 2490.18 |
| Gutierrez, Adrienne,18906 | 4217.22 | 0.00 | 3578.27 | 638.95 | 0.00 |
| Romero, Ricky,21361 | 2997.32 | 0.00 | 2443.35 | 0.00 | 553.97 |
| Liang, Barbara, T,22953 | 3899.49 | 0.00 | 0.00 | 3899.49 | 0.00 |
| Deng, Kurt, D,13635 | 215.74 | 0.00 | 0.00 | 32.27 | 183.47 |
| Deng, Michele,21946 | 4659.80 | 0.00 | 2181.56 | 0.00 | 2478.24 |
Generated 2025-11-03 17:50:42.211 UTC