[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 52 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanz, Lance,22573 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Kumar, Derek, M,15135 | 4381.39 | 0.00 | 0.00 | 2071.42 | 2309.97 |
| Martinez, Bruce, D,18452 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Wang, Roger, P,24605 | 3627.81 | 0.00 | 0.00 | 3627.81 | 0.00 |
| Williams, Wyatt, E,19614 | 6217.21 | 0.00 | 3578.27 | 0.00 | 2638.94 |
| Peterson, Juan, H,13082 | 6906.39 | 0.00 | 0.00 | 2071.42 | 4834.97 |
| Chapman, Alicia, A,21418 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| White, Kayla,26424 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Young, Allison, R,23644 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nara, Edwin, R,11097 | 8099.03 | 0.00 | 3374.99 | 0.00 | 4724.04 |
| Moreno, Meghan, J,15152 | 4464.57 | 0.00 | 0.00 | 2049.10 | 2415.47 |
| Lopez, Deanna, L,25119 | 2148.21 | 0.00 | 0.00 | 1000.44 | 1147.77 |
| Serrano, Lori,17066 | 105.75 | 0.00 | 0.00 | 0.00 | 105.75 |
| Ruiz, Kari, L,12695 | 192.97 | 0.00 | 0.00 | 0.00 | 192.97 |
| Ms., Sherwood, Irma, J.,24598 | 4228.31 | 0.00 | 0.00 | 2443.35 | 1784.96 |
| Kumar, Mindy, R,12700 | 6860.44 | 0.00 | 0.00 | 2071.42 | 4789.02 |
| Gill, Diana,25710 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Sanz, Sabrina, A,19650 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Ma, Rafael, T,13022 | 2644.02 | 0.00 | 0.00 | 2049.10 | 594.92 |
| Raman, Veronica, R,12359 | 95.74 | 0.00 | 0.00 | 0.00 | 95.74 |
| Rana, Ivan, K,18196 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Alvarez, Beth, M,29305 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Jiménez, Darren, W,28931 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Hernandez, Clinton,29462 | 854.82 | 0.00 | 0.00 | 0.00 | 854.82 |
| Hernandez, Walter,13141 | 240.24 | 0.00 | 0.00 | 0.00 | 240.24 |
| Jimenez, Krista,18257 | 115.95 | 0.00 | 0.00 | 0.00 | 115.95 |
| Gill, Erika, A,18202 | 4143.26 | 0.00 | 3578.27 | 0.00 | 564.99 |
| Cox, Nicole, V,22950 | 3917.54 | 0.00 | 0.00 | 3917.54 | 0.00 |
| Vazquez, Jonathon,17906 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Yang, Alan, L,15605 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Wang, Randy, G,25125 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Kumar, Chad,11095 | 8158.01 | 0.00 | 3374.99 | 2363.96 | 2419.06 |
| Parker, Gabriella,21394 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Liu, Erica, A,21564 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Ashe, Barbara,18734 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Fernandez, George,19974 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Gonzales, Victoria,11751 | 8215.02 | 0.00 | 3399.99 | 0.00 | 4815.03 |
| Martinez, Stanley, Z,13668 | 114.21 | 0.00 | 0.00 | 78.98 | 35.23 |
| Zhao, Bianca,13971 | 6772.13 | 0.00 | 0.00 | 2049.10 | 4723.03 |
| Ramirez, Olivia, D,19785 | 6076.61 | 0.00 | 3578.27 | 0.00 | 2498.34 |
| Arun, Ross, C,23658 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Lin, Clayton, M,27492 | 1344.91 | 0.00 | 0.00 | 782.99 | 561.92 |
| Cai, Shannon,26156 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Sai, Levi,16349 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Pal, Christy, R,18739 | 5371.74 | 0.00 | 3578.27 | 0.00 | 1793.47 |
| Jiménez, Orlando, M,21283 | 124.94 | 0.00 | 0.00 | 0.00 | 124.94 |
| Hill, James, S,29317 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| He, Ramon,26919 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Zheng, Alan,11050 | 5007.30 | 0.00 | 3374.99 | 0.00 | 1632.31 |
| Sanchez, Levi, A,27745 | 617.47 | 0.00 | 0.00 | 617.47 | 0.00 |
| Martin, Jaime,28316 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Zhou, Rafael, A,24494 | 9.99 | 0.00 | 0.00 | 9.99 | 0.00 |
| Guo, Rosa, M,24474 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Schmidt, Joe, M,22905 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Zhu, Alisha, G,18239 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Miller, Edward,11368 | 5106.24 | 0.00 | 3374.99 | 0.00 | 1731.25 |
Generated 2025-12-21 22:56:59.039 UTC