[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 57 > < TAKE 112 >
112 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Mehta, Deanna, P,17280 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Raman, César, C,24004 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Ye, Alvin, B,15575 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Dominguez, Neil, K,23663 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Miller, Edward,11368 | 5106.24 | 0.00 | 3374.99 | 0.00 | 1731.25 |
| Blanco, Alberto, R,27867 | 2443.55 | 0.00 | 0.00 | 0.00 | 2443.55 |
| She, Tonya, L,16521 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Chande, Franklin, L,20232 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Gill, Orlando,21360 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Wang, Erica, J,22168 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| He, Dennis, J,27878 | 1283.82 | 0.00 | 0.00 | 0.00 | 1283.82 |
| She, Jeffery, M,27149 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Raje, Casey, A,14686 | 203.46 | 0.00 | 0.00 | 0.00 | 203.46 |
| Xie, Drew, A,20218 | 104.69 | 0.00 | 0.00 | 0.00 | 104.69 |
| Taylor, Christopher, E,21171 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Sanz, Craig, M,21993 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Liang, Barbara, T,22953 | 3899.49 | 0.00 | 0.00 | 2181.56 | 1717.93 |
| Johnson, Sydney,19571 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Andersen, Colin,25053 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Hill, Mackenzie,19576 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Raman, Mayra, P,20990 | 4196.22 | 0.00 | 3578.27 | 0.00 | 617.95 |
| Romero, Ruben,16632 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Ramos, Alfredo,20456 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Lopez, Summer,12036 | 69.55 | 0.00 | 0.00 | 0.00 | 69.55 |
| Gao, Eugene,29464 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Gill, Alberto, P,17733 | 4758.24 | 0.00 | 3578.27 | 0.00 | 1179.97 |
| Romero, Philip, F,22195 | 4909.67 | 0.00 | 0.00 | 2443.35 | 2466.32 |
| Lal, Cristina, M,14671 | 2934.37 | 0.00 | 0.00 | 2071.42 | 862.95 |
| Sharma, Sharon, T,25294 | 1882.57 | 699.10 | 0.00 | 0.00 | 1183.47 |
| Xie, Marshall, M,19796 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Suri, Erick,16635 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Sharma, Kelvin, D,26655 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Garcia, Darren,28716 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Xie, Chad, A,26155 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| She, Sheena, R,23008 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Romero, Marie,20424 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Lal, Kenneth, J,18701 | 5357.74 | 0.00 | 3578.27 | 0.00 | 1779.47 |
| Torres, Eddie, L,21985 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Mrs., Nara, Barbara,12704 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Sanchez, Michele,23543 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Gonzalez, Savannah, F,15644 | 3803.68 | 0.00 | 0.00 | 2071.42 | 1732.26 |
| Garcia, Ruben,19613 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Romero, Jessie,25030 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Lal, Shawna,17924 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Deng, April,11117 | 8184.99 | 0.00 | 3399.99 | 2365.94 | 2419.06 |
| Gao, Candice, M,17493 | 130.96 | 0.00 | 0.00 | 0.00 | 130.96 |
| Chande, Dale, K,17242 | 4387.23 | 0.00 | 3578.27 | 0.00 | 808.96 |
| Malhotra, Harold,15227 | 4469.56 | 0.00 | 0.00 | 2049.10 | 2420.46 |
| Goel, Alicia, H,20423 | 4177.74 | 0.00 | 3578.27 | 0.00 | 599.47 |
| Rubio, Kendra,17047 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Malhotra, Ross, R,29307 | 14.98 | 0.00 | 0.00 | 14.98 | 0.00 |
| Xu, Grant, M,19266 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Moreno, Pedro, A,18248 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Mr., Shen, Alan,24257 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Jai, Carl,27597 | 564.21 | 0.00 | 0.00 | 0.00 | 564.21 |
| Liu, Erica, A,21564 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Zhao, Marshall, C,22033 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Allen, Ian, A,16031 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Serrano, Shannon, R,18303 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Gonzalez, Donald,11079 | 32.96 | 0.00 | 0.00 | 0.00 | 32.96 |
| Ye, Marshall, R,26559 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Nara, Grant,12995 | 6850.58 | 0.00 | 0.00 | 2049.10 | 4801.48 |
| Butler, Jason,17510 | 4369.74 | 0.00 | 3578.27 | 0.00 | 791.47 |
| Peterson, Juan, H,13082 | 6906.39 | 0.00 | 0.00 | 2071.42 | 4834.97 |
| Torres, Joanna, E,24464 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Deng, Colin, B,18299 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Lopez, Kari,15235 | 190.89 | 0.00 | 0.00 | 0.00 | 190.89 |
| Malhotra, Kristina,25031 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Cai, Suzanne,25051 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Kapoor, Ruben, D,11109 | 8245.01 | 0.00 | 3374.99 | 2476.96 | 2393.06 |
| Perez, Kevin, M,25565 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| 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 |
| Ortega, Felicia, J,11753 | 47.92 | 0.00 | 0.00 | 0.00 | 47.92 |
| Li, Karen, K,17921 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Navarro, Jonathon,18722 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Coleman, Luis, L,14230 | 5661.90 | 0.00 | 0.00 | 2049.10 | 3612.80 |
| Bailey, Savannah, J,23428 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rana, Marco, K,24473 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Wu, Mandy,18309 | 6090.59 | 0.00 | 3578.27 | 2512.32 | 0.00 |
| Lal, Karla,25219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Mehta, Nancy,18189 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Malhotra, Darren, L,20245 | 6085.59 | 0.00 | 3578.27 | 0.00 | 2507.32 |
| Beck, Donna, J,18247 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Zeng, Micah, A,25561 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Raje, Jodi, E,19630 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Alonso, Brandi,17061 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Serrano, Beth,24304 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Fernandez, Brenda, L,16493 | 4197.25 | 3578.27 | 0.00 | 0.00 | 618.98 |
| Mehta, Marco,11007 | 8211.00 | 3399.99 | 0.00 | 2391.95 | 2419.06 |
| Zhang, Willie, T,16023 | 166.89 | 0.00 | 0.00 | 0.00 | 166.89 |
| Patterson, Antonio, G,11963 | 8068.03 | 0.00 | 3374.99 | 0.00 | 4693.04 |
| Raji, Shawna, P,13961 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Diaz, Jill, F,22936 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Chander, Melvin, L,24266 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Raje, Kurt,15210 | 2926.39 | 0.00 | 0.00 | 2071.42 | 854.97 |
| Chande, Jaclyn, S,18698 | 5314.25 | 0.00 | 3578.27 | 1735.98 | 0.00 |
| Zeng, Barbara,23102 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Ma, Cedric, W,11094 | 157.93 | 0.00 | 0.00 | 0.00 | 157.93 |
| Goel, Bridget,26134 | 1926.45 | 0.00 | 782.99 | 0.00 | 1143.46 |
| Butler, Carson, T,12672 | 381.97 | 0.00 | 0.00 | 0.00 | 381.97 |
| Washington, Marcus,28329 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Smith, Arthur,18240 | 6098.58 | 0.00 | 3578.27 | 2520.31 | 0.00 |
| Williams, Anna, R,17504 | 4362.74 | 0.00 | 3578.27 | 0.00 | 784.47 |
| Sun, Jamie,21389 | 2770.52 | 0.00 | 2181.56 | 0.00 | 588.96 |
| Deng, Sheena,19099 | 6038.56 | 0.00 | 3578.27 | 0.00 | 2460.29 |
| Sara, Marco, L,15641 | 96.75 | 0.00 | 0.00 | 0.00 | 96.75 |
| Nara, Leonard, G,11045 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Ortega, Latasha,24270 | 2844.51 | 0.00 | 0.00 | 2181.56 | 662.95 |
| Navarro, Janet, J,28320 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Campbell, Devin,23653 | 3975.03 | 0.00 | 0.00 | 2181.56 | 1793.47 |
| Luo, Roger, J,18728 | 56.71 | 0.00 | 0.00 | 0.00 | 56.71 |
Generated 2025-12-22 06:43:51.451 UTC