[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 88 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chen, Rosa,23435 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Nara, Melvin, E,27147 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Gonzalez, Carla, J,18336 | 6145.07 | 0.00 | 3578.27 | 0.00 | 2566.80 |
| Lopez, Toni, K,25140 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Ma, Colin,26428 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Deng, Jaime, R,21968 | 4722.88 | 0.00 | 0.00 | 2181.56 | 2541.32 |
| Alexander, Olivia, L,14667 | 5295.41 | 0.00 | 0.00 | 2049.10 | 3246.31 |
| Fernandez, Donald, C,24462 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Sanchez, Terrance,19584 | 116.74 | 0.00 | 0.00 | 88.97 | 27.77 |
| Gomez, Randall, R,11762 | 8228.01 | 0.00 | 3399.99 | 0.00 | 4828.02 |
| Zhang, Jon,28111 | 865.31 | 0.00 | 0.00 | 0.00 | 865.31 |
| Ye, Brent,28922 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Dominguez, Robin,16685 | 4183.23 | 0.00 | 3578.27 | 0.00 | 604.96 |
| Nath, Rafael,23533 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Rana, Ivan, K,18196 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Rai, Tonya,25243 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Huang, Crystal, L,26023 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Price, Vanessa, A,23569 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Torres, Kari,18486 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Deng, Michele,21946 | 4659.80 | 0.00 | 0.00 | 2181.56 | 2478.24 |
| Blanco, Marc,24908 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Wilson, Zachary,25558 | 1307.06 | 0.00 | 699.10 | 0.00 | 607.96 |
| Andersen, Carl, J,11057 | 8088.04 | 0.00 | 3374.99 | 2319.99 | 2393.06 |
| Gutierrez, Hector,26423 | 2001.97 | 0.00 | 0.00 | 782.99 | 1218.98 |
| He, Karen, C,27861 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Luo, Colin, L,21210 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Yang, Martha, G,22210 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Munoz, Diane, R,15795 | 132.44 | 0.00 | 0.00 | 0.00 | 132.44 |
| Baker, Luke, J,22952 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| She, Marshall, D,18707 | 122.76 | 0.00 | 0.00 | 0.00 | 122.76 |
| Gomez, Mallory, R,24898 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Wu, Margaret,28928 | 2473.05 | 0.00 | 0.00 | 0.00 | 2473.05 |
| Zhao, Marshall, C,22033 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Alonso, Jonathon, A,15238 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Sanz, Linda, P,22945 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 0.00 | 2049.10 | 4768.04 |
| Ruiz, Marvin, R,18796 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Yuan, Marshall, P,19978 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Hill, Alex, C,19787 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Sanchez, Andre,15595 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Rodriguez, Allen, L,17732 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Arun, Brenda,13630 | 6824.73 | 0.00 | 0.00 | 2071.42 | 4753.31 |
| Goel, Katie, D,27708 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Goel, Bridget,26134 | 1926.45 | 0.00 | 782.99 | 0.00 | 1143.46 |
| Ma, Omar, I,15232 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Prasad, Clifford,15604 | 66.75 | 0.00 | 0.00 | 0.00 | 66.75 |
| Harris, Ian, W,14128 | 3836.38 | 0.00 | 0.00 | 2071.42 | 1764.96 |
| Chander, Yolanda,16519 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| He, Jorge,20268 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Hernandez, Kellie, A,12586 | 2636.41 | 0.00 | 2071.42 | 0.00 | 564.99 |
| Gill, Eddie, J,12715 | 74.54 | 0.00 | 0.00 | 0.00 | 74.54 |
| Mehta, Cassandra,23014 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ramirez, Isaiah,11905 | 8155.98 | 0.00 | 3374.99 | 0.00 | 4780.99 |
| Xie, Drew, A,20218 | 104.69 | 0.00 | 0.00 | 0.00 | 104.69 |
| Srini, Candace,15437 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Henderson, Dalton,24895 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-23 11:37:15.683 UTC