[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 37 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Liu, Cedric,12677 | 6785.47 | 0.00 | 2071.42 | 0.00 | 4714.05 |
| Green, Kyle,28328 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Blanco, Kari,19627 | 41.75 | 0.00 | 0.00 | 0.00 | 41.75 |
| Deng, Priscilla, M,25127 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Zhu, Roger, J,28098 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| _SUM | 9051988.22 | 305781.60 | 2436953.50 | 2256921.46 | 4052331.66 |
| Gill, Joanna,26186 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Garcia, Jermaine,21566 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Zimmerman, Candice, J,26754 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Raman, Ruth, L,21199 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Suarez, Briana, A,15266 | 2935.37 | 0.00 | 0.00 | 2071.42 | 863.95 |
| Malhotra, Pedro,21559 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Hernandez, Victor, T,23537 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Srini, Cindy, E,26026 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Flores, Noah,17256 | 4362.74 | 0.00 | 3578.27 | 0.00 | 784.47 |
| Moreno, Leslie, C,11114 | 122.89 | 0.00 | 0.00 | 0.00 | 122.89 |
| Serrano, Dwayne,16695 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Rai, Rafael, H,18715 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Martinez, Heidi, L,22922 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Kumar, Shawna, L,19085 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Chen, Claudia, R,16627 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Rodriguez, Kristi,14345 | 3639.92 | 0.00 | 0.00 | 2049.10 | 1590.82 |
| Anderson, Blake,11076 | 8159.04 | 0.00 | 3399.99 | 2374.98 | 2384.07 |
| Zhu, Louis,14858 | 196.97 | 0.00 | 0.00 | 0.00 | 196.97 |
| Anand, Alícia, J,29113 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Martin, Max, A,16030 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Lu, Ronnie,19950 | 6098.54 | 0.00 | 3578.27 | 0.00 | 2520.27 |
| Rodriguez, Rachael, M,11944 | 4776.27 | 0.00 | 3374.99 | 0.00 | 1401.28 |
| Price, Deb,24502 | 3623.32 | 0.00 | 0.00 | 2443.35 | 1179.97 |
| Suarez, Daisy, A,18288 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Dominguez, Wendy,11035 | 6451.31 | 3374.99 | 0.00 | 0.00 | 3076.32 |
| Vazquez, Jerome,23116 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Long, Angelica, C,28206 | 2398.05 | 0.00 | 0.00 | 2398.05 | 0.00 |
| Romero, Francis,22196 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Jenkins, Anna, M,17234 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Sutton, Kern, A,26660 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Yang, Ronnie,23524 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Serrano, Kristine,28940 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Xu, Clayton,18488 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Shen, Kathryn, R,21957 | 4919.30 | 0.00 | 0.00 | 2443.35 | 2475.95 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Alvarez, Linda,14047 | 5643.54 | 0.00 | 0.00 | 3321.26 | 2322.28 |
| Nara, Tommy,16729 | 38.92 | 0.00 | 0.00 | 0.00 | 38.92 |
| Gill, Anne,27469 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Pal, Jenny,15132 | 151.94 | 0.00 | 0.00 | 0.00 | 151.94 |
| Shen, Barbara,22030 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Hernandez, Armando,21950 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Rana, Henry,27342 | 1348.46 | 0.00 | 0.00 | 782.99 | 565.47 |
| Sai, Bryant, S,22577 | 2743.04 | 0.00 | 0.00 | 2181.56 | 561.48 |
| Blanco, Marc,24908 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Deng, Casey, C,19674 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Huang, Micah,25130 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Luo, Christine, J,24159 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Moreno, Janet, L,15592 | 59.98 | 0.00 | 0.00 | 24.99 | 34.99 |
| Prasad, Marco, C,15606 | 115.93 | 0.00 | 0.00 | 0.00 | 115.93 |
| Rana, Marco, K,24473 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
Generated 2025-12-22 00:03:28.752 UTC