[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 12 > < TAKE 32 >
32 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hernandez, Orlando, C,21951 | 4923.29 | 0.00 | 0.00 | 2443.35 | 2479.94 |
| Morgan, Natalie,15149 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Chandra, Harold, K,17236 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Baker, Luke, J,22952 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Madan, Cory,26154 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Munoz, Sheila,27488 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Munoz, Jimmy, E,21573 | 61.97 | 0.00 | 0.00 | 0.00 | 61.97 |
| He, Kelli, A,28872 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Hernandez, Walter,13141 | 240.24 | 0.00 | 0.00 | 0.00 | 240.24 |
| Malhotra, Pedro,21559 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Madan, Johnathan, D,13626 | 6909.09 | 0.00 | 0.00 | 2049.10 | 4859.99 |
| King, Hailey, A,28214 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Chapman, Patricia,12037 | 7107.10 | 0.00 | 3374.99 | 0.00 | 3732.11 |
| Ye, Steve,29087 | 810.32 | 0.00 | 0.00 | 0.00 | 810.32 |
| Yang, Louis, J,23013 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Allen, Hailey, C,26759 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 0.00 | 4720.33 |
| Ye, Ramon,11357 | 4943.80 | 0.00 | 3374.99 | 0.00 | 1568.81 |
| Kumar, Misty, H,25010 | 1540.43 | 0.00 | 0.00 | 1000.44 | 539.99 |
| Gomez, Victor, I,28203 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Lewis, Nicole,21881 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Rana, Meredith,25032 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Anderson, Emily, M,25220 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Raman, Edgar, A,27596 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Gomez, Mallory, R,24898 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zhang, Louis, K,20227 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Lal, Colin, M,16640 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Shan, Gregory,20614 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Prasad, Francisco,16628 | 187.58 | 0.00 | 0.00 | 0.00 | 187.58 |
| Bryant, Fernando, M,20609 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Diaz, Devin, D,15829 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Sharma, Edwin, K,25021 | 1554.41 | 0.00 | 0.00 | 1000.44 | 553.97 |
Generated 2026-01-04 05:06:08.761 UTC