[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 76 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Kumar, Deborah, K,17308 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Deng, Kate, L,15723 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Pal, Derek,24591 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Alonso, Diane, M,20630 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Suarez, Jerome, L,20622 | 6139.59 | 0.00 | 3578.27 | 0.00 | 2561.32 |
| Subram, Meredith, S,14261 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Zhu, Dawn,26661 | 1912.47 | 0.00 | 0.00 | 782.99 | 1129.48 |
| Vazquez, Bruce, P,20417 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Ramos, Audrey,11976 | 8087.31 | 0.00 | 3374.99 | 0.00 | 4712.32 |
| Luo, Devon, D,22850 | 4657.51 | 0.00 | 0.00 | 2181.56 | 2475.95 |
| Goel, Dale, M,20416 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Moreno, Danny, M,29458 | 811.32 | 0.00 | 0.00 | 0.00 | 811.32 |
| Ortega, Dwayne, C,24615 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Suri, Whitney, J,21974 | 4925.17 | 0.00 | 0.00 | 2443.35 | 2481.82 |
| Butler, Elijah, D,21551 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Cai, Candice,26747 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Nath, Jaime,11033 | 6495.29 | 0.00 | 3374.99 | 0.00 | 3120.30 |
| Yuan, Maurice,24380 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lal, Kurt, R,14015 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| She, Gregory,18458 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Anand, Alícia, J,29113 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Ortega, Monique, C,12355 | 6818.11 | 0.00 | 2049.10 | 0.00 | 4769.01 |
| Ye, Christy,14219 | 5744.22 | 0.00 | 0.00 | 2071.42 | 3672.80 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 0.00 | 2049.10 | 4768.04 |
| Perry, Madison, R,23308 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Deanna,13091 | 6864.95 | 0.00 | 0.00 | 2071.42 | 4793.53 |
| Vance, Toni, L,23438 | 123.48 | 0.00 | 0.00 | 0.00 | 123.48 |
| Prasad, Marco, C,15606 | 115.93 | 0.00 | 0.00 | 0.00 | 115.93 |
| Xylaras, Ioannis,20215 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Browning, Jay, M,24251 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Navarro, Casey,19795 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| _SUM | 9051988.22 | 281521.83 | 2448742.62 | 2264768.28 | 4056955.49 |
| Perez, Whitney,16619 | 97.58 | 0.00 | 0.00 | 0.00 | 97.58 |
| Adams, Devin,21871 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Suri, Erick,16635 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Raje, Grant, S,24162 | 3004.83 | 0.00 | 0.00 | 2443.35 | 561.48 |
| Hill, James, S,29317 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Kumar, Michele,23107 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Guo, Jorge, L,26590 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 0.00 | 2049.10 | 4744.05 |
| Martin, Renee, L,17478 | 4758.24 | 0.00 | 3578.27 | 0.00 | 1179.97 |
| Martinez, Ethan, C,20260 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Huang, Rosa, P,15181 | 4448.38 | 0.00 | 0.00 | 2071.42 | 2376.96 |
| Zhu, Jenny, J,17078 | 186.94 | 0.00 | 0.00 | 123.96 | 62.98 |
| Guo, Krystal, S,17381 | 188.93 | 0.00 | 0.00 | 0.00 | 188.93 |
| Kovár, Barry, A,21570 | 4705.48 | 0.00 | 0.00 | 2181.56 | 2523.92 |
| Arthur, Jay, R,12694 | 6785.13 | 0.00 | 0.00 | 2049.10 | 4736.03 |
| Travers, Jimmy, V,12674 | 6829.47 | 0.00 | 0.00 | 2071.42 | 4758.05 |
| Deng, April,11117 | 8184.99 | 0.00 | 3399.99 | 2365.94 | 2419.06 |
| Xu, Alicia,11370 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Rodriguez, Ebony,14517 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Sai, Cassandra, R,28110 | 845.31 | 0.00 | 0.00 | 0.00 | 845.31 |
| Sun, Edwin, O,21170 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Munoz, Gloria, L,19789 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Rubio, Jay,15179 | 4444.89 | 0.00 | 0.00 | 2071.42 | 2373.47 |
Generated 2025-12-23 14:30:31.291 UTC