[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1312 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lin, Autumn, E,18272 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Zhu, Clarence, A,18462 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Shen, Jodi, A,22028 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Chande, Jaclyn, S,18698 | 5314.25 | 0.00 | 3578.27 | 1735.98 | 0.00 |
| Zhang, Jenny, H,24609 | 2120.93 | 0.00 | 0.00 | 2120.93 | 0.00 |
| Xie, Wayne, S,18302 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Navarro, Kellie, I,21873 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Young, Marcus, A,18494 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Dominguez, Josue, R,15600 | 4590.40 | 0.00 | 0.00 | 2071.42 | 2518.98 |
| Gill, Latasha, M,25713 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Patel, Cynthia, M,15222 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Luo, Louis,11465 | 8158.04 | 0.00 | 3399.99 | 0.00 | 4758.05 |
| Hernandez, Audrey,18290 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Zheng, Darryl,18706 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Lu, Crystal, A,15145 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Dominguez, Theresa, L,18769 | 5304.25 | 0.00 | 3578.27 | 0.00 | 1725.98 |
| Raji, Damien, K,24282 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| She, Rosa,18931 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Williams, Wyatt, E,19614 | 6217.21 | 0.00 | 3578.27 | 0.00 | 2638.94 |
| Nara, Priscilla,18907 | 4167.23 | 0.00 | 3578.27 | 588.96 | 0.00 |
| Liu, Erica, A,21564 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Parker, Evan, R,18729 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Gomez, Jill,29315 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
| Garcia, Dalton, M,18768 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Ruiz, Bruce, W,16171 | 103.86 | 0.00 | 0.00 | 0.00 | 103.86 |
| Patterson, Ashley, R,18736 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Madan, Erick, W,14212 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Malhotra, Brett, E,18731 | 6054.06 | 0.00 | 3578.27 | 0.00 | 2475.79 |
| Guo, Trisha,18253 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Suri, Douglas,19096 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Beck, Derek,17322 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Fernandez, Kristopher, O,19271 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Shen, Shawn,19270 | 4127.25 | 0.00 | 3578.27 | 548.98 | 0.00 |
| Kelly, Emma, A,15646 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Liang, Louis, M,12706 | 6851.41 | 0.00 | 0.00 | 2071.42 | 4779.99 |
| Gonzalez, Kristopher, C,19264 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Carlson, Francis,27340 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Kumar, Kenneth,11472 | 8165.82 | 0.00 | 3399.99 | 0.00 | 4765.83 |
| Serrano, Orlando,19561 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Nara, Willie,24460 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Nara, Grant,12995 | 6850.58 | 0.00 | 0.00 | 2049.10 | 4801.48 |
| Dominguez, Stacy, S,19105 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Fernandez, Donald, C,24462 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Shan, Darrell, J,27345 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ortega, Gloria, R,19558 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Zhu, Erica,25221 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Black, Shawna, C,15205 | 4433.69 | 0.00 | 0.00 | 2071.42 | 2362.27 |
| Morgan, Carlos,25819 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Carson, Kristin, C,24459 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Lopez, Chelsea,24369 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Xu, Tara,19592 | 5377.23 | 0.00 | 3578.27 | 0.00 | 1798.96 |
| Jimenez, Teresa, L,24372 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Huang, Jorge,17291 | 86.27 | 0.00 | 0.00 | 53.99 | 32.28 |
| Deng, Sheena,19099 | 6038.56 | 0.00 | 3578.27 | 0.00 | 2460.29 |
| Liang, Lacey, A,15719 | 4429.57 | 0.00 | 0.00 | 2049.10 | 2380.47 |
| Raje, Gilbert,11055 | 8168.01 | 3374.99 | 0.00 | 2394.97 | 2398.05 |
| Andersen, Shawna, C,19556 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Johnsen, Willie,15218 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Rivera, Nathaniel, M,14051 | 5606.91 | 0.00 | 0.00 | 3286.92 | 2319.99 |
| Perez, Martin,19577 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Lopez, Mayra, E,27356 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Serrano, Lori,17066 | 105.75 | 0.00 | 0.00 | 0.00 | 105.75 |
Generated 2025-12-22 00:03:19.752 UTC