[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 500 < SKIP 63 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gomez, Randall, R,11762 | 8228.01 | 0.00 | 3399.99 | 0.00 | 4828.02 |
| Gutierrez, Meredith, T,11111 | 8137.00 | 0.00 | 3399.99 | 0.00 | 4737.01 |
| Tang, Leonard, L,28109 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Sai, Cassandra, R,28110 | 845.31 | 0.00 | 0.00 | 0.00 | 845.31 |
| Guo, Clarence,20265 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Chandra, Dominique, H,26765 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Shen, Calvin, W,26145 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Kapoor, Rachael, D,11911 | 62.46 | 0.00 | 0.00 | 0.00 | 62.46 |
| Deng, Deborah,23324 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Perez, Dominique,12344 | 68.70 | 0.00 | 0.00 | 0.00 | 68.70 |
| Diaz, Kellie, A,18330 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Wu, Brittney,23418 | 3400.02 | 0.00 | 0.00 | 2181.56 | 1218.46 |
| Hernandez, Roberto,28923 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Goel, Shawna, L,29332 | 165.28 | 0.00 | 0.00 | 0.00 | 165.28 |
| Jai, Brendan,26755 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Raje, Ashlee, E,16658 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Lin, Damien, L,23414 | 3391.03 | 0.00 | 0.00 | 2181.56 | 1209.47 |
| Rubio, Natasha, K,13627 | 214.25 | 0.00 | 0.00 | 0.00 | 214.25 |
| Pal, Christy, R,18739 | 5371.74 | 0.00 | 3578.27 | 0.00 | 1793.47 |
| Diaz, Jacquelyn, K,18747 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Sanders, Gabriella,11906 | 8151.00 | 0.00 | 3374.99 | 0.00 | 4776.01 |
| Zheng, Vincent,18496 | 6121.71 | 0.00 | 3578.27 | 0.00 | 2543.44 |
| She, Kelli, J,24889 | 2269.91 | 0.00 | 0.00 | 1000.44 | 1269.47 |
| Nara, Jon,22006 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Nath, Dawn, L,11759 | 8054.05 | 0.00 | 3374.99 | 0.00 | 4679.06 |
| Zeng, Alvin, M,11118 | 115.85 | 0.00 | 0.00 | 0.00 | 115.85 |
| Taylor, Devin, L,12248 | 3939.98 | 0.00 | 3399.99 | 0.00 | 539.99 |
| Yuan, Karla, W,13629 | 6889.11 | 0.00 | 0.00 | 2049.10 | 4840.01 |
| Diaz, Frank, F,29086 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Sun, Christy,25218 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 0.00 | 2049.10 | 4744.05 |
| Xu, Alicia,11370 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Raji, Andres, E,13955 | 6888.44 | 0.00 | 0.00 | 2071.42 | 4817.02 |
| Lewis, Hannah,26561 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Dominguez, Raquel, A,27470 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Ms., Sanchez, Madalena, J.,13020 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Simmons, Jordyn,16494 | 5961.20 | 3578.27 | 0.00 | 0.00 | 2382.93 |
| Johnson, Brianna, J,17319 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Cook, Sydney, D,13118 | 5669.90 | 0.00 | 0.00 | 2049.10 | 3620.80 |
| Torres, Walter,26784 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Zhu, Jenny, J,17078 | 186.94 | 0.00 | 0.00 | 123.96 | 62.98 |
| Navarro, Jonathon,18722 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 2294.99 | 2438.06 |
| Prasad, Edgar, E,17306 | 117.96 | 0.00 | 0.00 | 0.00 | 117.96 |
| Hernandez, Hailey, A,18727 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Alonso, Brandi,17061 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Sara, Troy, R,22583 | 2821.51 | 0.00 | 0.00 | 2181.56 | 639.95 |
| Sanz, Nelson, M,14056 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Nath, Bethany,16177 | 133.34 | 0.00 | 0.00 | 0.00 | 133.34 |
| Munoz, Cheryl, C,13632 | 6838.46 | 0.00 | 0.00 | 2071.42 | 4767.04 |
| Moore, Devin, J,16167 | 102.57 | 0.00 | 0.00 | 0.00 | 102.57 |
| Wu, Jamie, S,27595 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Liang, Omar,24245 | 17.27 | 0.00 | 0.00 | 0.00 | 17.27 |
| Carson, Mitchell,13623 | 99.20 | 0.00 | 0.00 | 0.00 | 99.20 |
| Black, Rafael,11966 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
| Zhang, Ronnie,16656 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Yang, Jamie, S,18465 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Ross, Julian,11363 | 5035.81 | 0.00 | 3399.99 | 0.00 | 1635.82 |
| Alvarez, Arthur,24892 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zheng, Claudia,18691 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Hernandez, Joe,15154 | 84.98 | 0.00 | 0.00 | 0.00 | 84.98 |
Generated 2025-12-24 08:04:36.671 UTC