[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rana, Raymond,25115 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Madan, Kristi, I,29184 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Sai, Preston, D,17046 | 4467.74 | 0.00 | 3578.27 | 0.00 | 889.47 |
| Ortega, Shannon,26375 | 1971.45 | 0.00 | 0.00 | 782.99 | 1188.46 |
| She, Roger, L,15724 | 4359.07 | 0.00 | 0.00 | 2049.10 | 2309.97 |
| Xie, Karla,18201 | 4157.73 | 0.00 | 3578.27 | 0.00 | 579.46 |
| She, Mindy, J,13009 | 168.67 | 0.00 | 0.00 | 0.00 | 168.67 |
| Sara, Donald, M,25114 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Ms., Sandidge, Mary, R.,14016 | 121.06 | 0.00 | 0.00 | 0.00 | 121.06 |
| Moreno, Dwayne, T,23103 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Madan, Brenda,13043 | 175.93 | 0.00 | 0.00 | 0.00 | 175.93 |
| Lu, Micah,22174 | 3007.83 | 0.00 | 0.00 | 2443.35 | 564.48 |
| Dominguez, Robin,16685 | 4183.23 | 3578.27 | 0.00 | 0.00 | 604.96 |
| Munoz, Ebony,13106 | 5697.52 | 0.00 | 0.00 | 2071.42 | 3626.10 |
| Fernandez, Rachael, M,23993 | 3072.32 | 0.00 | 0.00 | 2443.35 | 628.97 |
| Luo, Lindsey, R,22201 | 5012.27 | 0.00 | 0.00 | 2443.35 | 2568.92 |
| Goldberg, Mindy,16159 | 4411.65 | 0.00 | 0.00 | 2071.42 | 2340.23 |
| Simmons, Gabrielle,29183 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Zhu, Jenny, J,17078 | 186.94 | 0.00 | 0.00 | 123.96 | 62.98 |
| Munoz, Jacquelyn,29115 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| She, Ashlee,28319 | 556.93 | 0.00 | 0.00 | 0.00 | 556.93 |
| Lopez, Bruce,23540 | 3626.82 | 0.00 | 0.00 | 2443.35 | 1183.47 |
| Lee, Grace, J,28318 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Alvarez, Larry, T,14235 | 5682.20 | 0.00 | 0.00 | 2071.42 | 3610.78 |
| Alonso, Sheila,25054 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Washington, Abigail,23661 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Shan, Peter,24280 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Black, Russell,18897 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Bell, Stephanie, A,27370 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Jones, Destiny,15171 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Gill, Kristine,19977 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Zhao, Susan, L,25122 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| _SUM | 9051988.22 | 305781.60 | 2436953.50 | 2256921.46 | 4052331.66 |
| Rogers, Seth, R,14318 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Green, Alex, K,20317 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Mehta, Cassandra,23014 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Mehta, Chelsea,22951 | 4242.31 | 0.00 | 0.00 | 2443.35 | 1798.96 |
| Yang, Rosa,18713 | 237.26 | 0.00 | 0.00 | 0.00 | 237.26 |
| Pal, Gilbert,27744 | 643.95 | 0.00 | 0.00 | 643.95 | 0.00 |
| Chapman, Kathryn,11988 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Moreno, Diana, J,29298 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Sharma, Carl,21375 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sharma, Jerry, C,13651 | 6812.12 | 0.00 | 0.00 | 2049.10 | 4763.02 |
| Yuan, Kelsey, D,13034 | 94.71 | 0.00 | 0.00 | 0.00 | 94.71 |
| Fernandez, Kristina, A,12581 | 2646.40 | 0.00 | 0.00 | 2071.42 | 574.98 |
| Raji, Misty,16520 | 4727.74 | 3578.27 | 0.00 | 0.00 | 1149.47 |
| Zheng, Dennis, E,25567 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Sara, Ruben, A,19566 | 164.91 | 0.00 | 0.00 | 0.00 | 164.91 |
| Chander, Carl,14315 | 109.71 | 0.00 | 0.00 | 0.00 | 109.71 |
| Gutierrez, Latasha, C,15022 | 2999.91 | 0.00 | 0.00 | 2071.42 | 928.49 |
| She, Mandy, K,21972 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Chande, Louis, A,16681 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Malhotra, Geoffrey, W,18298 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Hernandez, Mathew, A,15184 | 4441.38 | 0.00 | 0.00 | 2071.42 | 2369.96 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Chandra, Arthur, L,14032 | 6859.43 | 0.00 | 0.00 | 2071.42 | 4788.01 |
| Beck, Cedric, L,22403 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ma, Brittney,12584 | 2633.39 | 0.00 | 0.00 | 2071.42 | 561.97 |
| Munoz, Alfredo, C,23314 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Martinez, Daniel, P,17725 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Suri, Holly, M,18286 | 141.55 | 0.00 | 0.00 | 0.00 | 141.55 |
| Pal, Terry, H,25824 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Vazquez, Armando,22571 | 2835.02 | 0.00 | 0.00 | 2181.56 | 653.46 |
| Gonzalez, Savannah, F,15644 | 3803.68 | 0.00 | 0.00 | 2071.42 | 1732.26 |
| Zhu, Colin,19973 | 83.44 | 0.00 | 0.00 | 0.00 | 83.44 |
| Gonzales, Victoria,11751 | 8215.02 | 0.00 | 3399.99 | 0.00 | 4815.03 |
| Navarro, Daisy,27514 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Lal, Alicia,15734 | 4426.41 | 0.00 | 0.00 | 2071.42 | 2354.99 |
| Xie, Brendan,13018 | 2642.38 | 0.00 | 0.00 | 2071.42 | 570.96 |
| Gonzales, Logan,16607 | 5897.53 | 3578.27 | 0.00 | 0.00 | 2319.26 |
| Goel, Tonya,29123 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Ramos, Theresa, G,11031 | 6478.60 | 3399.99 | 0.00 | 0.00 | 3078.61 |
| Mehta, Michele,26143 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Cai, Suzanne,25051 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Hu, Kristen, C,19788 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Carlson, Francis,27340 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Suri, Gerald,13617 | 116.92 | 0.00 | 0.00 | 0.00 | 116.92 |
| Howard, Jesse, D,24249 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Xu, Dennis,21997 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Lal, Clarence, L,24470 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Chen, Jaclyn, C,22847 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Barnes, Mariah, H,19621 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zhou, Colleen,23122 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Gao, Tiffany, E,16352 | 5948.49 | 3578.27 | 0.00 | 0.00 | 2370.22 |
| Gomez, Kendra, J,23320 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Smith, Andre,21174 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Ruiz, Natasha,21994 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Moreno, Randall, F,21209 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Williams, Alexis, D,14674 | 142.47 | 0.00 | 0.00 | 0.00 | 142.47 |
| Ashe, Kathryn,16168 | 80.11 | 0.00 | 0.00 | 0.00 | 80.11 |
| Patterson, Ashley, R,18736 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Shan, Damien, M,11362 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Sanz, Jésus,29313 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Zhu, Roger, J,28098 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Rivera, Mariah,20261 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Gomez, Alfredo, C,18200 | 4150.53 | 0.00 | 3578.27 | 0.00 | 572.26 |
| Ruiz, Carolyn, M,27863 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Price, Deb,24502 | 3623.32 | 0.00 | 0.00 | 2443.35 | 1179.97 |
| Liang, Tiffany,11068 | 113.36 | 0.00 | 0.00 | 0.00 | 113.36 |
| Becker, Kathryn,24588 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Jai, Derek, E,13613 | 105.22 | 0.00 | 0.00 | 0.00 | 105.22 |
| Sanchez, Manuel,15126 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Martinez, Ivan,27872 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Arun, Candace, J,21393 | 4925.17 | 0.00 | 2443.35 | 0.00 | 2481.82 |
| Luo, Shaun,27864 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Zhang, Kristen,27484 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| She, Marshall, D,18707 | 122.76 | 0.00 | 0.00 | 0.00 | 122.76 |
| Luo, Dustin,17240 | 4385.03 | 0.00 | 3578.27 | 0.00 | 806.76 |
| Goel, April, C,16166 | 108.85 | 0.00 | 0.00 | 0.00 | 108.85 |
| Raman, Brett, L,22930 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Huang, Barbara,26442 | 1919.75 | 0.00 | 0.00 | 782.99 | 1136.76 |
| Lal, Devon, L,15237 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Munoz, Gary, D,20230 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Black, Mindy, W,18696 | 6149.57 | 0.00 | 3578.27 | 0.00 | 2571.30 |
| Alonso, Billy, M,22852 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| She, Willie,17055 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Ruiz, Julio,11005 | 8121.33 | 3374.99 | 0.00 | 2362.27 | 2384.07 |
| She, Kelli, J,24889 | 2269.91 | 0.00 | 0.00 | 1000.44 | 1269.47 |
| Raje, Ashlee, E,16658 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Morris, Isaac, G,26439 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Rivera, Evan, Y,26757 | 1344.47 | 0.00 | 0.00 | 782.99 | 561.48 |
| Ramos, Alfredo,20456 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Lu, Christy,17062 | 91.26 | 0.00 | 0.00 | 53.99 | 37.27 |
| Brown, Kaitlyn,29120 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
Generated 2025-12-22 00:21:45.066 UTC