[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 28 > < TAKE 96 >
96 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hernandez, Isaac,25813 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Munoz, Sheila,27488 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Suri, Patricia, E,15436 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Cai, Steve, M,22155 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Romero, Philip, F,22195 | 4909.67 | 0.00 | 0.00 | 2443.35 | 2466.32 |
| Nara, Jaclyn, M,11930 | 5035.81 | 0.00 | 3399.99 | 0.00 | 1635.82 |
| Lal, Kurt, R,14015 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Luo, Roger, J,18728 | 56.71 | 0.00 | 0.00 | 0.00 | 56.71 |
| Sai, Levi,16349 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Perez, Edgar, B,29318 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Gill, Carolyn,23094 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Weber, Cynthia,26921 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Liu, Darryl,19947 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Cooper, Katherine, R,14314 | 122.95 | 0.00 | 0.00 | 0.00 | 122.95 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Serrano, Reginald, J,13025 | 2690.40 | 0.00 | 0.00 | 2071.42 | 618.98 |
| Chandra, Ann,18209 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Liu, Randy,15015 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Zhang, Alejandro, P,21992 | 184.26 | 0.00 | 0.00 | 0.00 | 184.26 |
| Huang, Randy,24007 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Nara, Michele, R,22842 | 86.46 | 0.00 | 0.00 | 0.00 | 86.46 |
| Patel, Whitney, F,24468 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Mr., Rovira Diez, Pablo,21190 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Pal, Kara,24916 | 2169.90 | 0.00 | 0.00 | 1000.44 | 1169.46 |
| Raman, Summer, C,25949 | 1882.57 | 0.00 | 699.10 | 0.00 | 1183.47 |
| Martinez, Ann,12009 | 8195.50 | 0.00 | 3399.99 | 0.00 | 4795.51 |
| Shan, Bethany, L,13973 | 5185.68 | 0.00 | 0.00 | 2071.42 | 3114.26 |
| Chander, Alisha,12572 | 2611.41 | 0.00 | 2071.42 | 0.00 | 539.99 |
| Jai, Jodi, M,27971 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Kovar, Nancy, F,26568 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Shan, Bridget,29338 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhao, Jamie,16179 | 72.16 | 0.00 | 0.00 | 0.00 | 72.16 |
| Chen, Alisha, J,14225 | 5603.92 | 0.00 | 0.00 | 2049.10 | 3554.82 |
| Prasad, Marco, C,15606 | 115.93 | 0.00 | 0.00 | 0.00 | 115.93 |
| Wang, Arturo, A,27720 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hill, Luis,27500 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Ruiz, Marvin, R,18796 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| McDonald, Brent,14068 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Malhotra, Toni,26162 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Liang, Gilbert,12242 | 3948.97 | 0.00 | 3374.99 | 0.00 | 573.98 |
| Sara, Ross,24367 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Hu, Omar, S,28954 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Nath, Rafael,23533 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Romero, Lawrence, C,16687 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Martinez, Daniel, P,17725 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Guo, Don,18742 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Gonzalez, Veronica, C,23311 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Ruiz, Alberto, L,25212 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Young, Marcus, A,18494 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Shen, Roger, G,14011 | 3831.89 | 0.00 | 0.00 | 2071.42 | 1760.47 |
| Patel, Douglas,17927 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Xie, Mitchell, B,20993 | 4262.04 | 0.00 | 3578.27 | 0.00 | 683.77 |
| Ye, Claudia, J,19102 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Raji, Nicolas, N,17301 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Ashe, Maurice,20430 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Gao, Jamie,26022 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Yang, Curtis,11110 | 8093.03 | 0.00 | 3399.99 | 0.00 | 4693.04 |
| Munoz, Ebony,13106 | 5697.52 | 0.00 | 0.00 | 2071.42 | 3626.10 |
| Martinez, Brett,23532 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Allen, Alexandra, B,17293 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Diaz, Marc,11058 | 8248.02 | 0.00 | 3399.99 | 2374.98 | 2473.05 |
| Deng, Russell, J,20314 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Gonzales, Alexis,23521 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Liang, Randy, E,28958 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Kumar, Deborah, K,17308 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Andersen, Carl, J,11057 | 8088.04 | 0.00 | 3374.99 | 2319.99 | 2393.06 |
| Sanchez, Candace, L,21567 | 4973.28 | 0.00 | 0.00 | 2443.35 | 2529.93 |
| King, Mackenzie, M,26916 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Davis, Ryan, C,27870 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Gutierrez, Tabitha, A,21884 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Perez, Toni,15581 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| Anand, Alison, J,24009 | 2746.04 | 0.00 | 0.00 | 2181.56 | 564.48 |
| Nara, Edwin, R,11097 | 8099.03 | 0.00 | 3374.99 | 0.00 | 4724.04 |
| Gutierrez, Philip, M,21979 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Ye, Marshall, R,26559 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Patel, Kaitlin, L,16615 | 95.84 | 0.00 | 0.00 | 0.00 | 95.84 |
| Nelson, Julia, L,11102 | 102.91 | 0.00 | 0.00 | 0.00 | 102.91 |
| Serrano, Dana, S,12678 | 341.43 | 0.00 | 0.00 | 0.00 | 341.43 |
| Perez, Ebony, M,24900 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Xu, Willie, C,13160 | 6839.46 | 0.00 | 0.00 | 2071.42 | 4768.04 |
| Liu, Suzanne,19594 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Srini, Veronica,11996 | 7058.70 | 0.00 | 3374.99 | 1291.77 | 2391.94 |
| Beck, Bonnie, A,29097 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Yuan, Chad, C,21173 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Jai, Alvin,19599 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Carlson, Briana,26436 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Madan, Marco,18895 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Chander, Melvin, L,24266 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Powell, Jeremy,11048 | 6498.24 | 0.00 | 3374.99 | 0.00 | 3123.25 |
| Zhu, Erica,25221 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Gao, Erica, R,19087 | 47.20 | 0.00 | 0.00 | 47.20 | 0.00 |
| Carlson, Mathew, A,23012 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gutierrez, Adrienne,18906 | 4217.22 | 0.00 | 3578.27 | 638.95 | 0.00 |
| Hu, Valerie, M,15044 | 3803.56 | 0.00 | 0.00 | 2049.10 | 1754.46 |
| Perez, Kevin, M,25565 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Lopez, Virginia, J,27338 | 1339.92 | 0.00 | 0.00 | 782.99 | 556.93 |
Generated 2025-12-22 05:55:14.675 UTC