[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 34 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhang, Brittney, W,19975 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Munoz, Marvin,14680 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Sanz, Arthur,27688 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Vance, Toni, L,23438 | 123.48 | 0.00 | 0.00 | 0.00 | 123.48 |
| Gonzalez, Natalie,25215 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Collins, James, E,26742 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Flores, Antonio, D,14259 | 3630.93 | 0.00 | 0.00 | 2049.10 | 1581.83 |
| Foster, Hunter, A,20269 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Madan, Cassandra, D,29068 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Yang, Alejandro, M,22176 | 100.46 | 0.00 | 0.00 | 0.00 | 100.46 |
| Gill, Erika, A,18202 | 4143.26 | 0.00 | 3578.27 | 0.00 | 564.99 |
| Raje, Kelli, A,28136 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Deng, Kate, L,15723 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Serrano, Hector, K,28308 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Suarez, Orlando,11121 | 58.16 | 0.00 | 0.00 | 0.00 | 58.16 |
| Zhang, Roger,12690 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Nath, Michele, L,11056 | 8207.50 | 0.00 | 3374.99 | 0.00 | 4832.51 |
| Lal, Donna,25812 | 113.97 | 0.00 | 0.00 | 0.00 | 113.97 |
| Liu, Karen, F,14008 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Carlson, Mathew, A,23012 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Arthur, Rebekah,22939 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| He, Amy,22411 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Lal, Deborah, T,21982 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Vazquez, Erika, S,22974 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hu, Leah,11994 | 8169.03 | 0.00 | 3374.99 | 0.00 | 4794.04 |
| Moreno, Robin,19563 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Luo, Roger, J,18728 | 56.71 | 0.00 | 0.00 | 0.00 | 56.71 |
| Gill, Mallory, P,16698 | 197.88 | 0.00 | 0.00 | 0.00 | 197.88 |
| Suarez, Linda,16665 | 81.81 | 0.00 | 0.00 | 0.00 | 81.81 |
| Ramos, Larry,18446 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Raji, Kathryn, C,21995 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Raji, Lacey, E,16341 | 88.25 | 0.00 | 0.00 | 0.00 | 88.25 |
| Madan, Patricia, L,22988 | 4194.33 | 0.00 | 0.00 | 2443.35 | 1750.98 |
| Kumar, Shawna, L,19085 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Hill, Mackenzie,19576 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Vazquez, Armando,22571 | 2835.02 | 0.00 | 0.00 | 2181.56 | 653.46 |
| Rai, Alejandro, R,21990 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Chandra, Carmen, R,23315 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Chen, Crystal, M,26566 | 2016.95 | 0.00 | 0.00 | 782.99 | 1233.96 |
| Garcia, Frederick, J,16489 | 112.73 | 0.00 | 0.00 | 0.00 | 112.73 |
| Vazquez, Jésus,26665 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Liang, Ronnie,24584 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Nath, Grant, A,28947 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Martinez, Douglas, C,22841 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Washington, Julian, C,23330 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Moore, Lucas, J,15021 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Kapoor, Pedro, H,24229 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Kumar, Colin,29188 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Sanchez, Michele,23543 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Liang, Christy, I,21239 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zeng, Ernest, M,12992 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| Chandra, Cynthia,22000 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Li, Trisha, A,18296 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Alonso, Sheila,25054 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Serrano, Gloria, G,21556 | 4930.68 | 0.00 | 0.00 | 2443.35 | 2487.33 |
Generated 2026-01-04 05:48:34.860 UTC