[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 877 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Dominguez, Joy,22175 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Liu, Cedric,12677 | 6785.47 | 0.00 | 2071.42 | 0.00 | 4714.05 |
| Jimenez, Gary, E,16609 | 344.04 | 0.00 | 0.00 | 84.95 | 259.09 |
| Chen, Claudia, R,16627 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Sutton, Cassie, S,16613 | 129.35 | 0.00 | 0.00 | 0.00 | 129.35 |
| Raji, Michele,15183 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Alexander, Austin,26673 | 1505.76 | 0.00 | 0.00 | 782.99 | 722.77 |
| West, James, M,15148 | 90.75 | 0.00 | 0.00 | 0.00 | 90.75 |
| Gao, Stacey,16662 | 4355.71 | 3578.27 | 0.00 | 777.44 | 0.00 |
| Diaz, Devin, D,15829 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Patterson, Ashley, R,18736 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Li, Elijah,16740 | 6099.10 | 3578.27 | 0.00 | 0.00 | 2520.83 |
| Mehta, Ann, M,14518 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Hernandez, Joe,15154 | 84.98 | 0.00 | 0.00 | 0.00 | 84.98 |
| Long, Emily, L,26140 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Rodriguez, Dylan, E,16611 | 75.53 | 0.00 | 0.00 | 0.00 | 75.53 |
| Luo, Tamara,18738 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Raje, Devon,29289 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Shan, Sheena, J,21565 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Rana, Meagan, M,11914 | 8165.96 | 0.00 | 3374.99 | 0.00 | 4790.97 |
| Zheng, Aimee, H,24283 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Jai, Jaime, M,24894 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chander, Dustin,11895 | 8149.04 | 0.00 | 3374.99 | 0.00 | 4774.05 |
| Alonso, Kristine,16686 | 4157.73 | 3578.27 | 0.00 | 0.00 | 579.46 |
| Pal, Tamara,12689 | 6846.92 | 0.00 | 0.00 | 2071.42 | 4775.50 |
| Ye, Willie,22963 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Mehta, Deanna, P,17280 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Nara, Katrina, Z,24608 | 2120.93 | 0.00 | 1000.44 | 0.00 | 1120.49 |
| Gray, Brooke, P,26756 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Romero, Lawrence, C,16687 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Moore, Natalie, W,18273 | 6104.21 | 0.00 | 3578.27 | 0.00 | 2525.94 |
| Sanz, Paula,26430 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Nara, Dawn, M,21891 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Fernandez, Arthur, J,22399 | 2785.05 | 0.00 | 0.00 | 2181.56 | 603.49 |
| Nara, Dustin, M,17910 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Malhotra, Mayra, E,15577 | 143.45 | 0.00 | 0.00 | 0.00 | 143.45 |
| Flores, Miranda,17243 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Gao, Louis,14666 | 5199.92 | 0.00 | 0.00 | 2049.10 | 3150.82 |
| Li, Crystal, L,14325 | 5152.70 | 0.00 | 0.00 | 2049.10 | 3103.60 |
| Gutierrez, Pedro, S,15224 | 71.92 | 0.00 | 0.00 | 0.00 | 71.92 |
| Nara, Karla, C,25827 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Sanchez, Terrance,19584 | 116.74 | 0.00 | 0.00 | 88.97 | 27.77 |
| Russell, Cassidy, N,26144 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Hernandez, Marvin, A,23077 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Cooper, Victoria, S,13637 | 6777.13 | 0.00 | 0.00 | 2049.10 | 4728.03 |
| Blue, Richard,12006 | 144.74 | 0.00 | 0.00 | 0.00 | 144.74 |
| Thompson, Justin,22954 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Watson, Maria,17229 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 |
| Gill, Sheila, B,17375 | 24.49 | 0.00 | 0.00 | 0.00 | 24.49 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Yuan, Christine,11046 | 6616.81 | 0.00 | 3374.99 | 0.00 | 3241.82 |
| Kumar, Ricardo, K,14133 | 3764.07 | 0.00 | 0.00 | 2049.10 | 1714.97 |
| Alvarez, Rodney, D,29286 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ramos, Marie, A,14308 | 5140.40 | 0.00 | 0.00 | 2049.10 | 3091.30 |
| Gray, Morgan,28307 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Gill, Kristy,13669 | 102.43 | 0.00 | 0.00 | 0.00 | 102.43 |
| Moreno, Krista, J,16745 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Shan, Derek, R,19782 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Cai, Autumn, O,26163 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Garcia, Andre, H,12705 | 6854.11 | 0.00 | 0.00 | 2049.10 | 4805.01 |
| Goel, Carly, C,12989 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Martinez, Anna, J,12994 | 6855.44 | 0.00 | 0.00 | 2071.42 | 4784.02 |
Generated 2025-12-23 06:05:52.154 UTC