[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 61 SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xu, Alicia,11370 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Cai, Shannon,26156 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Ma, Curtis,28119 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Zhang, Dawn, A,14222 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Chande, Kelli, C,22933 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Goel, Katie, D,27708 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Tang, Dawn, R,16496 | 5960.23 | 3578.27 | 0.00 | 0.00 | 2381.96 |
| Cai, Curtis,21259 | 3907.54 | 0.00 | 0.00 | 2181.56 | 1725.98 |
| Liu, Micah, J,15220 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Zhu, Ernest,20159 | 4167.23 | 0.00 | 3578.27 | 0.00 | 588.96 |
| Chen, Randy,13004 | 190.27 | 0.00 | 0.00 | 0.00 | 190.27 |
| Ramos, Michele, J,19574 | 96.74 | 0.00 | 0.00 | 0.00 | 96.74 |
| Suarez, Carolyn, B,18222 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Martinez, Frederick,11991 | 8128.02 | 0.00 | 3374.99 | 0.00 | 4753.03 |
| Zheng, Cara, L,27513 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Sanz, Hector,27344 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Andersen, Kate,14237 | 90.25 | 0.00 | 0.00 | 0.00 | 90.25 |
| She, Kathryn, I,26443 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Andersen, Tracy,20815 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Kumar, Bethany,29299 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Tang, Terrence, R,17303 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Nara, Edwin, R,11097 | 8099.03 | 0.00 | 3374.99 | 0.00 | 4724.04 |
| Ramos, Mary, B,15019 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Martin, Ricky, C,16608 | 101.57 | 0.00 | 0.00 | 0.00 | 101.57 |
| Gao, Trisha, A,28953 | 2462.55 | 0.00 | 0.00 | 0.00 | 2462.55 |
| Ramos, Marc,18212 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Madan, Brenda,13043 | 175.93 | 0.00 | 0.00 | 0.00 | 175.93 |
| Morgan, Carlos,25819 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Weber, Cory,16739 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Liu, Jaclyn,12996 | 6808.15 | 0.00 | 0.00 | 2049.10 | 4759.05 |
| Malhotra, Ross, R,29307 | 14.98 | 0.00 | 0.00 | 14.98 | 0.00 |
| Weber, Deanna, L,14855 | 3759.08 | 0.00 | 0.00 | 2049.10 | 1709.98 |
| Lu, Krystal,17049 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Zhang, Damien, C,26758 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Lal, Clarence, L,24470 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Vance, Marco,13124 | 87.93 | 0.00 | 0.00 | 0.00 | 87.93 |
| Romero, Paula, B,16691 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 |
| Watson, Maria,17229 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 |
| Ruiz, Carolyn, M,27863 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Lal, Tara, S,18697 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Griffin, Caroline,17726 | 4721.73 | 0.00 | 3578.27 | 0.00 | 1143.46 |
| Wu, Amy,19790 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Ma, Cara,18885 | 110.46 | 0.00 | 0.00 | 0.00 | 110.46 |
| Sai, Regina,21192 | 4229.32 | 0.00 | 2443.35 | 0.00 | 1785.97 |
| Harris, Thomas,24002 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Yang, Clarence, D,25121 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Smith, Andre,21174 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Moore, Thomas,14010 | 3861.39 | 0.00 | 0.00 | 2071.42 | 1789.97 |
| Zhao, Crystal,25906 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Malhotra, Heidi, A,26426 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lee, Dalton, J,16931 | 4767.73 | 0.00 | 3578.27 | 0.00 | 1189.46 |
| Cai, Jorge,22031 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Patel, Toni, E,25829 | 1894.07 | 0.00 | 699.10 | 0.00 | 1194.97 |
| Gutierrez, Orlando,25920 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Zeng, Wesley,20460 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Xie, Michele, M,15039 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Ruiz, Naomi,23649 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Goel, Carly, C,12989 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Shan, Bridget,29338 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Guo, Jake, P,19969 | 98.45 | 0.00 | 0.00 | 67.97 | 30.48 |
| Serrano, Shannon, R,18303 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Griffin, Olivia,21208 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Suarez, Daisy, A,18288 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Moreno, Danny, M,29458 | 811.32 | 0.00 | 0.00 | 0.00 | 811.32 |
| Shen, Wayne, P,23647 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Luo, Melvin,24366 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Alonso, Brandi,17061 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Xu, Cedric, M,24278 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| Martinez, Tina, J,18461 | 4748.24 | 0.00 | 3578.27 | 0.00 | 1169.97 |
| Zhao, Colin, D,24241 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Rodriguez, Douglas, W,19652 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Gutierrez, Marvin,25938 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Ramos, Lance, S,28949 | 2473.05 | 0.00 | 0.00 | 0.00 | 2473.05 |
| Arun, Denise,28218 | 18.97 | 0.00 | 0.00 | 0.00 | 18.97 |
| Liu, Ronnie,26130 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Gomez, Marc, J,21880 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Chande, Carl,18932 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Chandra, Jarrod,24171 | 3006.31 | 0.00 | 0.00 | 2443.35 | 562.96 |
| Li, Jaclyn,18281 | 6081.10 | 0.00 | 3578.27 | 0.00 | 2502.83 |
| Travers, Reginald,28488 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Alvarez, Kendra, R,15267 | 2853.58 | 0.00 | 0.00 | 2049.10 | 804.48 |
| Lin, Alan,22973 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Anand, Niñia, L,19949 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Stone, Brenda, J,12697 | 296.19 | 0.00 | 0.00 | 0.00 | 296.19 |
| Townsend, Larry, D,11134 | 4911.83 | 0.00 | 3399.99 | 0.00 | 1511.84 |
| Guo, Margaret,23431 | 4158.32 | 0.00 | 0.00 | 2443.35 | 1714.97 |
| Carlson, Frank,11896 | 8117.97 | 0.00 | 3374.99 | 0.00 | 4742.98 |
| Alonso, Meredith, M,20621 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Andersen, Marshall, V,15786 | 4366.07 | 0.00 | 0.00 | 2049.10 | 2316.97 |
| Black, Peter, E,21213 | 64.26 | 0.00 | 0.00 | 0.00 | 64.26 |
| Wu, Margaret,28928 | 2473.05 | 0.00 | 0.00 | 0.00 | 2473.05 |
| Sun, Clayton,28533 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Rodriguez, Tammy,15233 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Li, Margaret,15753 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Lopez, Terrance, T,14217 | 139.45 | 0.00 | 0.00 | 0.00 | 139.45 |
| Chande, Melvin, R,11460 | 8137.52 | 0.00 | 3399.99 | 0.00 | 4737.53 |
| Adams, Isabella,15715 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Smith, Christian, L,14313 | 222.44 | 0.00 | 0.00 | 0.00 | 222.44 |
| Gonzalez, Roy, M,13040 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Goel, Karla, L,11146 | 112.93 | 0.00 | 0.00 | 0.00 | 112.93 |
| Watson, Alexandra, H,25249 | 1868.56 | 699.10 | 0.00 | 0.00 | 1169.46 |
| Howard, Jesse, D,24249 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Hernandez, Erik, C,21998 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Hernandez, Ebony, S,23574 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Madan, Terrance,24910 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Gonzalez, Jay, C,14238 | 5642.90 | 0.00 | 0.00 | 2049.10 | 3593.80 |
| Nara, Gregory,26651 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Anand, Katrina, L,18726 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Gonzalez, Ruth,12693 | 6820.47 | 0.00 | 0.00 | 2071.42 | 4749.05 |
| Mr., Sands, Patrick,14063 | 5676.25 | 0.00 | 0.00 | 2071.42 | 3604.83 |
| Zhao, Jaclyn, D,26167 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| James, Mariah, M,19104 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Luo, Maurice, C,27491 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Kumar, Bridget,15802 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Jimenez, Marie, C,24176 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Luo, Nichole, A,29296 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Srini, Candace,15437 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Martinez, Brett,23532 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Reed, Steven,24373 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Zheng, Alan,11050 | 5007.30 | 0.00 | 3374.99 | 0.00 | 1632.31 |
| Zhao, Bianca,13971 | 6772.13 | 0.00 | 0.00 | 2049.10 | 4723.03 |
| Nara, Sharon,18482 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Weber, Cynthia,26921 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Ye, Dennis, M,16638 | 5974.23 | 0.00 | 3578.27 | 0.00 | 2395.96 |
Generated 2025-12-24 07:24:13.982 UTC