[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 24 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Kumar, Kurt, L,27360 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Raje, April, R,18744 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Lal, Carl, C,28950 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Nelson, Carol,13520 | 4551.36 | 0.00 | 0.00 | 2071.42 | 2479.94 |
| Wu, Arturo, A,28321 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Rubio, Philip, P,21876 | 4663.38 | 0.00 | 0.00 | 2181.56 | 2481.82 |
| Yang, Roger, A,28108 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Gao, Candice, M,17493 | 130.96 | 0.00 | 0.00 | 0.00 | 130.96 |
| Kelly, Zoe,23123 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ye, Christy,14219 | 5744.22 | 0.00 | 0.00 | 2071.42 | 3672.80 |
| Morgan, Natalie,15149 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Thomas, Sydney,14322 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Perry, Gavin, M,12578 | 2668.08 | 0.00 | 0.00 | 2049.10 | 618.98 |
| He, Dennis, J,27878 | 1283.82 | 0.00 | 0.00 | 0.00 | 1283.82 |
| Sai, Barry,22907 | 4169.33 | 0.00 | 0.00 | 2443.35 | 1725.98 |
| Lu, Jeffery, B,19971 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Anand, Katrina, L,18726 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Vazquez, Francis, E,17281 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Lu, Sandra, N,13521 | 4514.77 | 0.00 | 0.00 | 4514.77 | 0.00 |
| Torres, Meghan, I,21256 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Blanco, Micheal, A,11113 | 109.88 | 0.00 | 0.00 | 49.97 | 59.91 |
| Martinez, Ivan,27872 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Lopez, Patricia,28305 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Gomez, Alfredo, C,18200 | 4150.53 | 0.00 | 3578.27 | 0.00 | 572.26 |
| Romero, Raquel, Z,22916 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| She, Jeffery, M,27149 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Arun, Ross, C,23658 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Deng, Deborah,23324 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Ma, Warren, A,19762 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Stone, Keith,17331 | 40.96 | 0.00 | 0.00 | 0.00 | 40.96 |
| Li, Luis, K,20251 | 59.47 | 0.00 | 0.00 | 0.00 | 59.47 |
| Xu, Jaclyn, L,12685 | 6904.11 | 0.00 | 2049.10 | 0.00 | 4855.01 |
| Shen, Calvin, W,26145 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Goel, Gilbert,15596 | 4460.04 | 0.00 | 0.00 | 2049.10 | 2410.94 |
| Ramirez, Mason, K,25107 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Sharma, Carl,21375 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhang, Suzanne, R,20316 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raji, Kathryn, C,21995 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Clark, Joshua, A,26137 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Romero, Marie,20424 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Gray, Faith,22914 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Gomez, Victor, I,28203 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Hill, Alex, C,19787 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Rana, Stanley, J,22919 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Pal, Lacey, K,26571 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Gill, Lee, L,27694 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Rai, Johnny, A,13135 | 6773.14 | 0.00 | 0.00 | 2049.10 | 4724.04 |
| Chandra, Gerald,25131 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Xie, Drew, A,20218 | 104.69 | 0.00 | 0.00 | 0.00 | 104.69 |
| Washington, Marcus,28329 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Xu, Clayton, W,25001 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Alonso, Darren,27501 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Gonzalez, Natalie,25215 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Wu, Marshall, J,15590 | 4440.05 | 0.00 | 0.00 | 2049.10 | 2390.95 |
| Carson, Kelvin, A,11995 | 8249.01 | 0.00 | 3399.99 | 0.00 | 4849.02 |
| Roberts, Jordan,23432 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
Generated 2025-12-22 00:08:50.039 UTC