[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 248 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Garcia, George,20160 | 4237.22 | 0.00 | 3578.27 | 0.00 | 658.95 |
| Anand, Andrés,11096 | 8063.04 | 0.00 | 3374.99 | 0.00 | 4688.05 |
| Li, Kristen, R,15153 | 113.97 | 0.00 | 0.00 | 0.00 | 113.97 |
| Garcia, Jermaine,21566 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Ma, Bianca,19798 | 128.44 | 0.00 | 0.00 | 0.00 | 128.44 |
| Luo, Alison, A,23527 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Gomez, Jerome, J,25057 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Gao, Arturo,28714 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Guo, Jamie,20151 | 4152.73 | 0.00 | 3578.27 | 0.00 | 574.46 |
| Gonzalez, Devin,18485 | 6063.21 | 0.00 | 3578.27 | 0.00 | 2484.94 |
| Henderson, Isabella, L,21981 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Thompson, Michael, M,26148 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Patel, Summer, G,26753 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Xu, Cedric, M,24278 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| Kapoor, Brandy, I,15236 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| He, Susan, A,24467 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Zheng, Randy, B,22574 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| She, Glenn, L,29117 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Fernandez, Lydia, M,14523 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Sun, Jaclyn,18211 | 65.96 | 0.00 | 0.00 | 0.00 | 65.96 |
| Lin, Margaret, C,18306 | 87.77 | 0.00 | 0.00 | 0.00 | 87.77 |
| Alonso, Sheila,25054 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Ruiz, Melody,13621 | 167.40 | 0.00 | 0.00 | 0.00 | 167.40 |
| Goel, Drew,17352 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zhou, Jessie,20610 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zhang, Claudia,13114 | 6807.45 | 0.00 | 0.00 | 2071.42 | 4736.03 |
| Perez, Carmen, C,13139 | 6854.45 | 0.00 | 0.00 | 2071.42 | 4783.03 |
| Wilson, Jasmine,17329 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Griffin, Caroline,17726 | 4721.73 | 0.00 | 3578.27 | 0.00 | 1143.46 |
| Long, Alexis,22580 | 3051.31 | 0.00 | 0.00 | 2443.35 | 607.96 |
| Lal, Kurt, R,14015 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Chander, Shawn, S,20216 | 5338.74 | 0.00 | 3578.27 | 0.00 | 1760.47 |
| Cooper, Alex, L,27362 | 1407.45 | 0.00 | 0.00 | 782.99 | 624.46 |
| Yuan, Roger,19622 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
| Hernandez, Victor, T,23537 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Huang, Lacey, J,11951 | 63.52 | 0.00 | 0.00 | 0.00 | 63.52 |
| Li, Alvin,26764 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Raji, Warren, J,26796 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Alexander, Elizabeth,13089 | 6800.45 | 0.00 | 0.00 | 2071.42 | 4729.03 |
| Andersen, Jodi,26766 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Ruiz, Francis, D,21381 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ramos, Theresa, G,11031 | 6478.60 | 3399.99 | 0.00 | 0.00 | 3078.61 |
| Johnsen, Jerry,26670 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| She, Sharon, F,22017 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Vance, Kristi, T,28338 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Xu, Sharon, A,23344 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Gonzalez, Tina,19653 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Chander, Drew, J,25111 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Liang, Ronnie,24584 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Subram, Roy,21896 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Carlson, Wendy,20220 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Lopez, Mayra, E,27356 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Gomez, Brandi, M,14675 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Morris, Megan,23641 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Xylaras, Ioannis,20215 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Bell, Stephanie, A,27370 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Gonzalez, Carolyn, H,22407 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Liang, Alan, L,29063 | 801.83 | 0.00 | 0.00 | 0.00 | 801.83 |
| Madan, Johnathan, D,13626 | 6909.09 | 0.00 | 0.00 | 2049.10 | 4859.99 |
| Zheng, Dawn, F,19579 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Srini, Beth, A,25913 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Patel, Douglas,17927 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
Generated 2025-12-23 11:53:45.068 UTC