[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 30 > < TAKE 120 >
120 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xu, Alicia,11370 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Malhotra, Toni,26162 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Nelson, Carol,13520 | 4551.36 | 0.00 | 0.00 | 2071.42 | 2479.94 |
| Peterson, Juan, H,13082 | 6906.39 | 0.00 | 0.00 | 2071.42 | 4834.97 |
| Pal, Kara,24916 | 2169.90 | 0.00 | 0.00 | 1000.44 | 1169.46 |
| He, Louis, E,21211 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Wang, Jeffery, E,18188 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Sanchez, Francisco, D,21172 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Schmidt, Shane,17922 | 4821.72 | 0.00 | 3578.27 | 0.00 | 1243.45 |
| Tang, April, A,25935 | 1256.03 | 0.00 | 699.10 | 0.00 | 556.93 |
| Carlson, Mathew, A,23012 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jai, Gregory,16342 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Xie, Jaime,25823 | 1887.56 | 0.00 | 699.10 | 0.00 | 1188.46 |
| Watson, Anna,20238 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Wu, Bianca, F,28485 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Yuan, Rafael, J,20625 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Watson, Alexandra, H,25249 | 1868.56 | 699.10 | 0.00 | 0.00 | 1169.46 |
| Alexander, Hailey, C,19666 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Shan, Elijah, L,26795 | 1992.46 | 0.00 | 0.00 | 782.99 | 1209.47 |
| Malhotra, Stanley, H,11453 | 8176.98 | 0.00 | 3374.99 | 2382.93 | 2419.06 |
| Zhang, Claudia,13114 | 6807.45 | 0.00 | 0.00 | 2071.42 | 4736.03 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| Dominguez, Stacy, S,19105 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Gonzalez, Veronica, C,23311 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Suarez, Danny,20995 | 4127.25 | 0.00 | 3578.27 | 0.00 | 548.98 |
| Wang, Crystal, C,11112 | 8295.02 | 0.00 | 3374.99 | 0.00 | 4920.03 |
| Sutton, Cassie, S,16613 | 129.35 | 0.00 | 0.00 | 0.00 | 129.35 |
| Gomez, Andy,18721 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Torres, Marc,11765 | 8143.03 | 0.00 | 3374.99 | 0.00 | 4768.04 |
| Ye, Tamara, A,20243 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Yuan, Chad, C,21173 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Blanco, Wendy, J,19604 | 171.73 | 0.00 | 0.00 | 0.00 | 171.73 |
| Gao, Bianca, C,13112 | 5717.89 | 0.00 | 0.00 | 2049.10 | 3668.79 |
| Sanders, Arianna, E,22859 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Liang, Steve,14317 | 81.26 | 0.00 | 0.00 | 49.99 | 31.27 |
| Serrano, Deanna, W,15144 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Srini, Kristopher, A,23997 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Malhotra, Ruben, M,17074 | 90.25 | 0.00 | 0.00 | 58.98 | 31.27 |
| Richardson, Abigail, S,14236 | 5710.23 | 0.00 | 0.00 | 2071.42 | 3638.81 |
| Zhao, Jorge,16711 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Blanco, Orlando,22575 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Cai, Vincent, L,11757 | 58.05 | 0.00 | 0.00 | 0.00 | 58.05 |
| Suarez, Hector, L,15034 | 103.45 | 0.00 | 0.00 | 0.00 | 103.45 |
| Lal, Kurt, R,14015 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Powell, Kaitlyn,19598 | 5310.53 | 0.00 | 3578.27 | 0.00 | 1732.26 |
| Gill, Kristine,19977 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Sai, Bruce,22194 | 4633.90 | 0.00 | 0.00 | 2181.56 | 2452.34 |
| Prasad, Levi,25705 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Hernandez, Mathew, A,15184 | 4441.38 | 0.00 | 0.00 | 2071.42 | 2369.96 |
| Butler, Destiny,27865 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Chander, Karla,23648 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Ruiz, Alfredo,21975 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Flores, Brianna,27706 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Henderson, Marcus, D,15212 | 68.96 | 0.00 | 0.00 | 0.00 | 68.96 |
| Cai, Steve, M,22155 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gonzalez, Shane, Y,14125 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Gutierrez, Darren, A,25714 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Ma, Curtis,28119 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Raje, Tara, F,28483 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Navarro, Kellie, I,21873 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| She, Nina,22961 | 3891.54 | 0.00 | 0.00 | 2181.56 | 1709.98 |
| Flores, Connor,15755 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Mr., Shakespear, Paul, J.,17326 | 4467.76 | 0.00 | 3578.27 | 0.00 | 889.49 |
| Gonzalez, Roy, M,13040 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Kapoor, Arthur,24483 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Sanders, Devin, J,12014 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Anand, Niñia, L,19949 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Ward, Shelby,26132 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Shan, Damien, M,11362 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Beck, Derek,17322 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Hernandez, Audrey,18290 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Suarez, Nelson,27355 | 1383.45 | 0.00 | 0.00 | 782.99 | 600.46 |
| Fernandez, Denise, A,18724 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Moreno, Larry, W,28207 | 2461.55 | 0.00 | 0.00 | 2461.55 | 0.00 |
| Luo, Nichole, A,29296 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Lewis, Jasmine,13964 | 6806.45 | 0.00 | 0.00 | 2071.42 | 4735.03 |
| Ortega, Armando, K,25223 | 102.96 | 0.00 | 0.00 | 0.00 | 102.96 |
| Martinez, Meredith, M,19095 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Gill, Billy, L,16700 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Gonzalez, Deanna, S,15204 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Serrano, Tyrone,11360 | 5025.80 | 0.00 | 3399.99 | 0.00 | 1625.81 |
| Carlson, Jill,21886 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
| Guo, Clarence,20265 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Romero, Ruben,16632 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Becker, Gregory, M,13104 | 6894.44 | 0.00 | 0.00 | 2071.42 | 4823.02 |
| Garcia, Dominique,16528 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Shan, Clarence,22408 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Raji, Dale,19265 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Patel, Janelle, T,29116 | 17.27 | 0.00 | 0.00 | 0.00 | 17.27 |
| Price, Isabella, L,17278 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Gomez, Kendra, J,23320 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Sara, Cesar, C,22172 | 2932.30 | 0.00 | 0.00 | 2181.56 | 750.74 |
| Romero, Gina,14234 | 5687.72 | 0.00 | 0.00 | 2071.42 | 3616.30 |
| Suarez, Neil,15242 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Xie, Alicia,26427 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Smith, Andre,21174 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Lopez, Joe, L,27512 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gonzales, Lucas,29463 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Cai, Warren,24918 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Garcia, Dalton, M,18768 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Ramos, Marc,18212 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Zhang, Lacey, L,14127 | 3809.57 | 0.00 | 0.00 | 2049.10 | 1760.47 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Suri, Patricia, E,15436 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Huang, Dawn, E,11943 | 4734.29 | 0.00 | 3374.99 | 539.99 | 819.31 |
| Mr., Sands, Patrick,14063 | 5676.25 | 0.00 | 0.00 | 2071.42 | 3604.83 |
| Mehta, Gerald,20234 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Stone, Christine, D,25948 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Pais, Wilson, C,13038 | 5581.26 | 0.00 | 0.00 | 2071.42 | 3509.84 |
| Chande, Latoya, M,23309 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Bhat, Yolanda,15225 | 4401.41 | 0.00 | 0.00 | 2071.42 | 2329.99 |
| Fernandez, Tammy, A,25825 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wright, Haley,26036 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Li, Luis, K,20251 | 59.47 | 0.00 | 0.00 | 0.00 | 59.47 |
| Moreno, Mallory, P,22912 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Lewis, Hannah,26561 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Zeng, Ramon,27979 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzalez, Clifford,24505 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
Generated 2025-12-21 22:53:34.193 UTC