[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 875 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Shan, Colin,25921 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Parker, Gabriel,19606 | 83.97 | 0.00 | 0.00 | 83.97 | 0.00 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| Alvarez, Larry, T,14235 | 5682.20 | 0.00 | 0.00 | 2071.42 | 3610.78 |
| Lu, Jamie, M,23646 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Kapoor, Veronica, G,20253 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Carlson, Clinton, E,11116 | 148.70 | 0.00 | 0.00 | 27.28 | 121.42 |
| Watson, Nathaniel, H,25826 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Yuan, Kathryn, L,23106 | 3956.01 | 0.00 | 0.00 | 2181.56 | 1774.45 |
| Romero, Lance,18310 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Cai, Amy,24920 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Chander, Damien,11080 | 8204.02 | 0.00 | 3374.99 | 2359.98 | 2469.05 |
| Navarro, Stacy, C,12688 | 6867.44 | 0.00 | 2071.42 | 0.00 | 4796.02 |
| Liu, Cedric,12677 | 6785.47 | 0.00 | 2071.42 | 0.00 | 4714.05 |
| Hu, Cara,20608 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Edwards, Evan, L,21888 | 4925.58 | 0.00 | 2443.35 | 0.00 | 2482.23 |
| Roberts, Jordan,23432 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Sanz, Mathew, L,14557 | 63.97 | 0.00 | 0.00 | 63.97 | 0.00 |
| Raje, Cristina, S,17917 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Flores, Connor,15755 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Suarez, Meghan, L,22177 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Shan, Eric, L,26771 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Nara, Tonya, C,17251 | 123.96 | 0.00 | 0.00 | 69.97 | 53.99 |
| Green, Jonathan, A,17332 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Chande, Bonnie, L,23992 | 3167.82 | 0.00 | 0.00 | 2443.35 | 724.47 |
| Liu, Suzanne,19594 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Sanz, Kellie,16708 | 4406.74 | 3578.27 | 0.00 | 0.00 | 828.47 |
| Sanz, Diane, M,20153 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Andersen, Roger,24469 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Diaz, Danny, C,18190 | 30.97 | 0.00 | 0.00 | 8.99 | 21.98 |
| Huang, Colleen, S,21379 | 2992.33 | 0.00 | 2443.35 | 0.00 | 548.98 |
| Zhou, Jessie,20610 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Arthur, Kristi, W,16675 | 4385.03 | 3578.27 | 0.00 | 806.76 | 0.00 |
| Raji, Grant, R,16185 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Sai, Terrance,19106 | 64.95 | 0.00 | 0.00 | 21.98 | 42.97 |
| Sanz, Kari, V,27341 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Wu, Arturo, A,28321 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Diaz, Jacquelyn, K,18747 | 6089.59 | 0.00 | 3578.27 | 2511.32 | 0.00 |
| Mehta, Erick, E,14123 | 61.58 | 0.00 | 0.00 | 28.98 | 32.60 |
| Chander, Keith, A,24174 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Zhang, Jenny, H,24609 | 2120.93 | 0.00 | 1000.44 | 1120.49 | 0.00 |
| Bailey, Savannah, J,23428 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lal, Alicia,15734 | 4426.41 | 0.00 | 0.00 | 2071.42 | 2354.99 |
| Yuan, Calvin,17905 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Yang, Crystal, A,23665 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Gomez, Jill,29315 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
| Goel, Bradley,15803 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Zheng, Alisha,22203 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Romero, Billy,20419 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Beck, Barbara,26547 | 1407.96 | 0.00 | 0.00 | 782.99 | 624.97 |
| Li, Vincent, D,21207 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Cox, Nicole, V,22950 | 3917.54 | 0.00 | 0.00 | 3917.54 | 0.00 |
| Ortega, Latasha,24270 | 2844.51 | 0.00 | 0.00 | 2181.56 | 662.95 |
| Lopez, Darren,29081 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Xu, Alejandro, R,26585 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Vazquez, Rodney, M,13047 | 241.93 | 0.00 | 0.00 | 0.00 | 241.93 |
| Deng, Carl,18284 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Gill, Latasha, M,25713 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Suarez, Carolyn, B,18222 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Lopez, Kristi,28137 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Martinez, Frederick,11991 | 8128.02 | 0.00 | 3374.99 | 0.00 | 4753.03 |
| Jones, Nathan,15024 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Madan, Marco,18895 | 27.77 | 0.00 | 0.00 | 27.77 | 0.00 |
| Zheng, Erica, K,23643 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kumar, Katie, P,12341 | 6840.62 | 0.00 | 2049.10 | 0.00 | 4791.52 |
| Goel, Karla, L,11146 | 112.93 | 0.00 | 0.00 | 53.95 | 58.98 |
| Rana, Nancy, H,26150 | 1992.46 | 0.00 | 782.99 | 0.00 | 1209.47 |
| Brooks, Jared,24476 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Henderson, Marcus, D,15212 | 68.96 | 0.00 | 0.00 | 0.00 | 68.96 |
| Hernandez, Alberto, D,25029 | 2272.20 | 0.00 | 0.00 | 1000.44 | 1271.76 |
| Raman, Virginia,26159 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Subram, Meredith, S,14261 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Raman, Candace, M,11766 | 8280.48 | 0.00 | 3399.99 | 2419.46 | 2461.03 |
| Navarro, Kathleen, J,19269 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| She, Alvin, E,16657 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Alonso, Alfredo, T,23323 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Cai, Jessie, A,12249 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Deng, Gilbert, C,15765 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Huang, Crystal, L,26023 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Kapoor, Candace,18282 | 30.97 | 0.00 | 0.00 | 21.98 | 8.99 |
| Navarro, Jaime, T,27690 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Hall, Jeremiah, M,18250 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Zhang, Glenn, A,13967 | 5721.91 | 0.00 | 0.00 | 2049.10 | 3672.81 |
| Alonso, Jonathon, A,15238 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Ma, Amy, E,17309 | 6030.61 | 3578.27 | 0.00 | 0.00 | 2452.34 |
| Mr., Shakespear, Paul, J.,17326 | 4467.76 | 0.00 | 3578.27 | 0.00 | 889.49 |
| Long, Julian,12034 | 72.25 | 0.00 | 0.00 | 0.00 | 72.25 |
| Ye, Erica, E,13010 | 5716.52 | 0.00 | 0.00 | 2071.42 | 3645.10 |
| Davis, Morgan, J,27359 | 1344.47 | 0.00 | 0.00 | 782.99 | 561.48 |
| Goel, Michele,15041 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Patel, Arthur, B,26671 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chande, Cassie,11103 | 8182.50 | 0.00 | 3374.99 | 2388.45 | 2419.06 |
| Jenkins, Anna, M,17234 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Jackson, Eduardo, C,11749 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Shan, Shawna, K,27869 | 2462.55 | 0.00 | 0.00 | 0.00 | 2462.55 |
| Kapoor, Bryant,22946 | 3911.53 | 0.00 | 0.00 | 3911.53 | 0.00 |
| Sharma, Kelvin, D,26655 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| White, Taylor, D,25011 | 1589.40 | 0.00 | 0.00 | 1000.44 | 588.96 |
| Liu, Trisha, V,20214 | 5304.25 | 0.00 | 3578.27 | 0.00 | 1725.98 |
| Gutierrez, Jonathon, R,16529 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Gonzalez, Eric, C,19092 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Vazquez, Joe, C,20418 | 4207.24 | 0.00 | 3578.27 | 628.97 | 0.00 |
| Munoz, Teresa, R,27712 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Serrano, Mallory, E,26751 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Alexander, Hailey, C,19666 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Cai, Curtis,21259 | 3907.54 | 0.00 | 2181.56 | 0.00 | 1725.98 |
| Ortega, Max,23413 | 3617.83 | 0.00 | 0.00 | 3617.83 | 0.00 |
| Sharma, Corey, M,17495 | 119.91 | 0.00 | 0.00 | 0.00 | 119.91 |
| Kapoor, Kristina,11997 | 7029.78 | 0.00 | 3399.99 | 1249.84 | 2379.95 |
| Ortega, Shannon,26375 | 1971.45 | 0.00 | 0.00 | 782.99 | 1188.46 |
| Griffin, Blake, S,18699 | 5308.24 | 0.00 | 3578.27 | 1729.97 | 0.00 |
| Wu, Shannon, F,15268 | 2840.91 | 0.00 | 0.00 | 2071.42 | 769.49 |
| Tang, Julie,26589 | 1966.46 | 0.00 | 0.00 | 782.99 | 1183.47 |
| Becker, Kathryn,24588 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Nara, Ricardo,28934 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Raje, Raul, L,26785 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Nara, Sharon,18482 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Patel, Kaitlin, L,16615 | 95.84 | 0.00 | 0.00 | 0.00 | 95.84 |
| Zhang, Susan, S,18216 | 38.92 | 0.00 | 0.00 | 8.99 | 29.93 |
| Hayes, Alexis,13048 | 190.23 | 0.00 | 0.00 | 0.00 | 190.23 |
| Raji, Maurice, C,20619 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Garcia, Tina,17231 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Andersen, Deborah,19610 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Sanz, Victor,17295 | 4392.74 | 3578.27 | 0.00 | 0.00 | 814.47 |
Generated 2025-11-04 06:23:45.767 UTC