[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xu, Grant, M,19266 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Kumar, Bridget,15802 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Cai, Roger, A,13002 | 294.94 | 0.00 | 0.00 | 0.00 | 294.94 |
| Diaz, Ricky, E,18335 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Gonzalez, Clifford,24505 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Dominguez, Raquel, A,27470 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Xu, Kristen,15751 | 4446.40 | 0.00 | 0.00 | 2071.42 | 2374.98 |
| Martinez, Manuel, J,15832 | 2611.41 | 0.00 | 0.00 | 2071.42 | 539.99 |
| Lal, Alicia,15734 | 4426.41 | 0.00 | 0.00 | 2071.42 | 2354.99 |
| Rai, Melvin, J,24604 | 3681.80 | 0.00 | 0.00 | 3681.80 | 0.00 |
| Hill, Luis,27500 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Shen, Katrina,15801 | 4381.38 | 0.00 | 0.00 | 2049.10 | 2332.28 |
| Perez, Kyle, J,16180 | 4386.37 | 0.00 | 0.00 | 2049.10 | 2337.27 |
| Zeng, Warren, R,24477 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Patterson, Kyle,11448 | 8132.01 | 0.00 | 3374.99 | 2318.96 | 2438.06 |
| Zheng, Roger,29321 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Zhou, Trisha, B,12686 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Gomez, Adrienne,11920 | 8156.32 | 0.00 | 3374.99 | 0.00 | 4781.33 |
| Rivera, Devin, J,25109 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vazquez, Carolyn,23650 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Pal, Tasha,22853 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Nara, Latoya, J,18208 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Zhou, Jamie,17327 | 99.94 | 0.00 | 0.00 | 0.00 | 99.94 |
| King, Maria, E,28202 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Rodriguez, Heidi, L,25120 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Martin, Marc, J,11039 | 6636.58 | 3399.99 | 0.00 | 0.00 | 3236.59 |
| Navarro, Stacy, C,12688 | 6867.44 | 0.00 | 0.00 | 2071.42 | 4796.02 |
| Kapoor, Abby, J,29054 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Raje, Derek,12574 | 2626.39 | 0.00 | 2071.42 | 0.00 | 554.97 |
| Gao, Jamie,26022 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Huang, Margaret, H,17070 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Gomez, Carrie,22965 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gomez, Sheila, J,21165 | 4673.88 | 0.00 | 2181.56 | 0.00 | 2492.32 |
| Patterson, Jordan,17238 | 147.48 | 0.00 | 0.00 | 0.00 | 147.48 |
| Liu, Jenny,16165 | 81.81 | 0.00 | 0.00 | 0.00 | 81.81 |
| Parker, Gabriella,21394 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Jai, Derek, E,13613 | 105.22 | 0.00 | 0.00 | 0.00 | 105.22 |
| Ma, Jeffery,18264 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Subram, Evelyn, S,21257 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Kapoor, Candace,18282 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| Diaz, Nelson, C,21387 | 2745.33 | 0.00 | 2181.56 | 0.00 | 563.77 |
| Gonzalez, Shane, Y,14125 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Zhou, Laura, D,12683 | 6801.45 | 0.00 | 0.00 | 2071.42 | 4730.03 |
| Arun, Candace, J,21393 | 4925.17 | 0.00 | 2443.35 | 0.00 | 2481.82 |
| Romero, Jacquelyn,25815 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Romero, Mallory,26434 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Vazquez, Marc, H,24362 | 3600.77 | 0.00 | 0.00 | 2443.35 | 1157.42 |
| Liang, Colin,13639 | 188.96 | 0.00 | 0.00 | 0.00 | 188.96 |
| Munoz, Carolyn, L,17315 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Navarro, Mallory,24365 | 3331.03 | 0.00 | 0.00 | 2181.56 | 1149.47 |
| Moore, Nathan, N,28323 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Lin, Bianca,11107 | 8171.01 | 0.00 | 3374.99 | 2376.96 | 2419.06 |
| Gutierrez, Jill, N,26024 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Foster, Luke,15137 | 161.94 | 0.00 | 0.00 | 0.00 | 161.94 |
| Chander, Bethany, K,11446 | 8237.01 | 0.00 | 3399.99 | 2354.98 | 2482.04 |
| Ms., Roy, Lisa, K.,21403 | 4895.69 | 0.00 | 0.00 | 2443.35 | 2452.34 |
| Lal, Alisha, C,21872 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Wu, Warren, M,15602 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Wu, Lisa,26158 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Malhotra, Pedro,21559 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Prasad, Candace, S,22148 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
Generated 2025-12-21 08:15:24.114 UTC