[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 1438 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Shan, Shawna, K,27869 | 2462.55 | 0.00 | 0.00 | 0.00 | 2462.55 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Patel, Gerald,23095 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sharma, Cedric, A,14060 | 99.47 | 0.00 | 0.00 | 49.99 | 49.48 |
| Deng, Arturo, A,28102 | 1299.83 | 0.00 | 0.00 | 0.00 | 1299.83 |
| Mehta, Ann, M,14518 | 126.95 | 0.00 | 0.00 | 63.97 | 62.98 |
| Alonso, Ricky, S,14070 | 5618.93 | 0.00 | 0.00 | 2049.10 | 3569.83 |
| Lopez, Mason, E,22923 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Butler, Elijah, D,21551 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Kapoor, Cesar, J,24302 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Zhang, Alejandro, P,21992 | 184.26 | 0.00 | 0.00 | 0.00 | 184.26 |
| Zeng, Ramon,27979 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Moreno, Diana, J,29298 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Pais, Wilson, C,13038 | 5581.26 | 0.00 | 0.00 | 2071.42 | 3509.84 |
| Carlson, Theresa, L,19629 | 109.44 | 0.00 | 0.00 | 0.00 | 109.44 |
| Xu, Cedric,18198 | 4143.25 | 0.00 | 3578.27 | 0.00 | 564.98 |
| Raji, Michele,15183 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Blanco, Erika, L,14669 | 90.25 | 0.00 | 0.00 | 0.00 | 90.25 |
| Simmons, Gabrielle,29183 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Ruiz, Julio,11005 | 8121.33 | 3374.99 | 0.00 | 2362.27 | 2384.07 |
| Rubio, Tanya, I,15598 | 167.93 | 0.00 | 0.00 | 0.00 | 167.93 |
| Jiménez, Orlando, M,21283 | 124.94 | 0.00 | 0.00 | 0.00 | 124.94 |
| Garcia, Ivan, L,17354 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Sanders, Charles, E,21967 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Lin, Rafael,14099 | 200.26 | 0.00 | 0.00 | 27.28 | 172.98 |
| Jai, Warren, S,16483 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Li, Alejandro, A,27519 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Kumar, Kurt, L,27360 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sharma, Terrence, N,17351 | 6117.69 | 3578.27 | 0.00 | 0.00 | 2539.42 |
| Subram, Cassandra, M,16618 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Sanchez, Carla,18274 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Yang, Todd, J,19094 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Yuan, Derek, L,27589 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Sun, Alvin,18252 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 0.00 | 2049.10 | 4768.04 |
| Diaz, Derrick, R,14853 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| Torres, Kari,18486 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Li, Crystal, L,14325 | 5152.70 | 0.00 | 0.00 | 2049.10 | 3103.60 |
| Jai, Brad, C,18267 | 64.98 | 0.00 | 0.00 | 34.99 | 29.99 |
| Xu, Clayton,18488 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Watson, Maria,17229 | 4471.74 | 3578.27 | 0.00 | 0.00 | 893.47 |
| Zhao, Kelvin,25135 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Huang, Damien,16524 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Liang, Randy, E,28958 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| She, Bridget, M,19557 | 5358.24 | 0.00 | 3578.27 | 0.00 | 1779.97 |
| Sanders, Arianna, E,22859 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| He, Dennis, J,27878 | 1283.82 | 0.00 | 0.00 | 0.00 | 1283.82 |
| Gonzalez, Kaylee, L,21895 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Wang, Trisha, V,17259 | 4404.73 | 3578.27 | 0.00 | 0.00 | 826.46 |
| Adams, Devin,21871 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Powell, Grace, B,29194 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Yang, Jon, V,11000 | 8248.99 | 3399.99 | 0.00 | 2341.97 | 2507.03 |
| Jai, Karla,18263 | 126.94 | 0.00 | 0.00 | 34.99 | 91.95 |
| Garcia, Donald,18929 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Madan, Henry, E,17283 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Sai, Jay, A,23427 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzalez, Michele, D,18491 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Shen, Priscilla, A,28215 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Weber, Levi, A,13120 | 205.39 | 0.00 | 0.00 | 49.48 | 155.91 |
| Patel, Cynthia, M,15222 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Beck, Donna, J,18247 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
Generated 2025-11-06 23:03:41.176 UTC