[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 38 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Romero, Joy, D,24886 | 80.47 | 0.00 | 0.00 | 0.00 | 80.47 |
| Allen, Ian, A,16031 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Vazquez, Kristi,28349 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhang, James,14684 | 38.55 | 0.00 | 0.00 | 0.00 | 38.55 |
| Romero, Ebony, A,27717 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Navarro, Stacy, C,12688 | 6867.44 | 0.00 | 0.00 | 2071.42 | 4796.02 |
| Shen, Wayne, P,23647 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Suarez, Pedro, A,24611 | 2219.42 | 0.00 | 1000.44 | 1218.98 | 0.00 |
| Jiménez, Brandi,24378 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Ramos, Gloria, A,21365 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Huang, Crystal, L,26023 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Ortega, Lawrence,14685 | 146.74 | 0.00 | 0.00 | 0.00 | 146.74 |
| Phillips, Jeremy, E,18495 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Lal, Alicia,15734 | 4426.41 | 0.00 | 0.00 | 2071.42 | 2354.99 |
| Gutierrez, Joy, A,18466 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Sanchez, Andre,15595 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| She, Katie, B,11965 | 118.74 | 0.00 | 0.00 | 0.00 | 118.74 |
| Alexander, Gail, C,14682 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Zeng, Dawn, D,29455 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Martinez, Lydia,24169 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Zhu, Lacey,24167 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Schmidt, Kaitlin,13628 | 191.25 | 0.00 | 0.00 | 0.00 | 191.25 |
| Sara, Marco, L,15641 | 96.75 | 0.00 | 0.00 | 0.00 | 96.75 |
| Zheng, Darryl,18706 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Chavez, Jodi, A,18909 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Moreno, Hector,21183 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Lal, Corey, H,23313 | 2906.03 | 0.00 | 0.00 | 2181.56 | 724.47 |
| Jai, Jodi, M,27971 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Parker, Mason, W,25923 | 6.28 | 0.00 | 0.00 | 6.28 | 0.00 |
| Liang, Valerie,28091 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Lee, Austin,26151 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Johnsen, Jerry,26670 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gutierrez, Gary, C,12701 | 6868.44 | 0.00 | 0.00 | 2071.42 | 4797.02 |
| Deng, Casey, C,19674 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Sanz, Hector,27344 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Shen, Leonard, J,24271 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| He, Ramon,26919 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Griffin, Grace,11443 | 8235.00 | 0.00 | 3374.99 | 0.00 | 4860.01 |
| Shen, Tamara, G,22935 | 3951.52 | 0.00 | 0.00 | 2181.56 | 1769.96 |
| Prasad, Marco, C,15606 | 115.93 | 0.00 | 0.00 | 0.00 | 115.93 |
| Kelly, Emma, A,15646 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Kumar, Yolanda, J,18194 | 85.96 | 0.00 | 0.00 | 0.00 | 85.96 |
| Mr., Shen, Alan,24257 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| She, Eugene, L,20998 | 2806.51 | 0.00 | 2181.56 | 0.00 | 624.95 |
| Prasad, Carmen, L,18928 | 6095.08 | 0.00 | 3578.27 | 0.00 | 2516.81 |
| Sharma, Terrence, N,17351 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Goel, Drew,17352 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Shan, Eric, L,26771 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Raje, Jodi, E,19630 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Cai, Autumn, O,26163 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Raji, Dale,19265 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Nath, Omar, F,14672 | 5237.72 | 0.00 | 0.00 | 2071.42 | 3166.30 |
| Lee, Grace, J,28318 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Dominguez, Micheal,26142 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Chande, Cassie,11103 | 8182.50 | 0.00 | 3374.99 | 2388.45 | 2419.06 |
| Gonzalez, Eric, C,19092 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
Generated 2025-12-21 17:02:04.663 UTC