[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 4 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Collins, Jennifer,11364 | 4921.82 | 0.00 | 3374.99 | 0.00 | 1546.83 |
| Zhu, Alisha, G,18239 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Hernandez, Ebony, S,23574 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Wang, Jaclyn, M,17063 | 100.25 | 0.00 | 0.00 | 0.00 | 100.25 |
| Suri, Shane, L,25126 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Moreno, Bruce, F,26652 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Sanz, Hector,27344 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| She, Marshall, D,18707 | 122.76 | 0.00 | 0.00 | 0.00 | 122.76 |
| Kapoor, Veronica, G,20253 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Nara, Jaclyn, M,11930 | 5035.81 | 0.00 | 3399.99 | 0.00 | 1635.82 |
| Sara, Tina,24307 | 4158.32 | 0.00 | 0.00 | 2443.35 | 1714.97 |
| Lin, Karen,24243 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Goel, Karl,18705 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Sara, Candace,21380 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Liang, Alan, L,29063 | 801.83 | 0.00 | 0.00 | 0.00 | 801.83 |
| Ferrier, Jenny,21955 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Serrano, Dana, S,12678 | 341.43 | 0.00 | 0.00 | 0.00 | 341.43 |
| Sara, Adriana, M,15146 | 161.94 | 0.00 | 0.00 | 0.00 | 161.94 |
| Xu, Margaret, T,22404 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Patel, Pamela, G,27875 | 1268.84 | 0.00 | 0.00 | 0.00 | 1268.84 |
| Shen, Mitchell, M,22904 | 4759.99 | 0.00 | 0.00 | 2181.56 | 2578.43 |
| Blanco, Billy,23316 | 2835.02 | 0.00 | 0.00 | 2181.56 | 653.46 |
| Zeng, Alisha, A,15727 | 134.46 | 0.00 | 0.00 | 0.00 | 134.46 |
| James, Evan, V,11119 | 85.22 | 0.00 | 0.00 | 35.23 | 49.99 |
| Kelly, Emma, A,15646 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Kumar, Ricardo, K,14133 | 3764.07 | 0.00 | 0.00 | 2049.10 | 1714.97 |
| Ashe, Brad,25228 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Hill, Mackenzie,19576 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Lu, Todd, D,24269 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Sara, Cassandra, D,20989 | 4148.74 | 0.00 | 3578.27 | 0.00 | 570.47 |
| Raje, Ashlee, E,16658 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Carlson, Marie,29311 | 603.96 | 0.00 | 0.00 | 0.00 | 603.96 |
| Arthur, Regina, A,19089 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Patel, Marco, L,19575 | 60.05 | 0.00 | 0.00 | 0.00 | 60.05 |
| Romero, Marie,20424 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Zhou, Steve, C,20263 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Raman, Harold, F,28484 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Zheng, Omar, C,14522 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Fernandez, Michele, M,24884 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Dominguez, Robyn, P,23305 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sanz, Paula,26430 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lu, Micah,22174 | 3007.83 | 0.00 | 0.00 | 2443.35 | 564.48 |
| Mehta, Preston, G,18692 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Martin, Randall, B,19560 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Diaz, Gloria,25270 | 1854.58 | 699.10 | 0.00 | 0.00 | 1155.48 |
| Liang, Barbara, T,22953 | 3899.49 | 0.00 | 0.00 | 2181.56 | 1717.93 |
| Wu, Kelvin,24595 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| He, Louis, E,21211 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Shen, Tony,29099 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Garcia, Holly,26558 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 0.00 | 2049.10 | 4768.04 |
| Fernandez, Geoffrey,19963 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Shen, Michele,27985 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Perez, Molly,25941 | 1255.36 | 0.00 | 699.10 | 0.00 | 556.26 |
| Fernandez, Brenda, L,16493 | 4197.25 | 3578.27 | 0.00 | 0.00 | 618.98 |
| Navarro, Janet, J,28320 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
Generated 2025-12-23 17:01:05.306 UTC