[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 1875 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sara, Ebony,24923 | 2159.40 | 0.00 | 0.00 | 1000.44 | 1158.96 |
| Carson, Bradley,23995 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Gray, Faith,22914 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Zhang, Tiffany, R,17318 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Subram, Joe,13631 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Xie, Derek,14287 | 5141.43 | 0.00 | 0.00 | 2049.10 | 3092.33 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 0.00 | 1179.97 |
| Dominguez, Neil, K,23663 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Sharma, Jerry, C,13651 | 6812.12 | 0.00 | 0.00 | 2049.10 | 4763.02 |
| Perez, Janelle,16172 | 186.04 | 0.00 | 0.00 | 0.00 | 186.04 |
| Andersen, Willie, M,27970 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Sanchez, Patrick, W,24382 | 143.78 | 0.00 | 0.00 | 0.00 | 143.78 |
| Raji, Andres, E,13955 | 6888.44 | 0.00 | 0.00 | 2071.42 | 4817.02 |
| Lee, Richard, I,23996 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Sai, Troy,16515 | 4733.75 | 3578.27 | 0.00 | 1155.48 | 0.00 |
| Ross, Arianna, E,26774 | 1331.97 | 0.00 | 0.00 | 1331.97 | 0.00 |
| Moreno, Bruce, F,26652 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Simmons, Isabel, H,26432 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Lin, Kelvin, A,13075 | 6843.94 | 0.00 | 0.00 | 2071.42 | 4772.52 |
| She, Ricardo, A,14233 | 78.97 | 0.00 | 0.00 | 0.00 | 78.97 |
| Anand, Bradley,19626 | 39.46 | 0.00 | 0.00 | 0.00 | 39.46 |
| Guo, Sandra,23664 | 3941.53 | 0.00 | 0.00 | 2181.56 | 1759.97 |
| Sanders, Arianna, E,22859 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gao, Micah, W,25106 | 2170.92 | 0.00 | 0.00 | 1000.44 | 1170.48 |
| Ramos, Juan,13633 | 6803.14 | 0.00 | 0.00 | 2049.10 | 4754.04 |
| Goel, Bethany,27511 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Serrano, Mallory, E,26751 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Scott, Alex, T,14348 | 2989.38 | 0.00 | 0.00 | 2071.42 | 917.96 |
| Ramos, Jerome, L,29187 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Wang, Trisha, V,17259 | 4404.73 | 3578.27 | 0.00 | 0.00 | 826.46 |
| Gill, Carolyn,23094 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Zimmerman, Tiffany, E,23325 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Mehta, Carolyn,28205 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Ramos, Francis,16345 | 4173.24 | 3578.27 | 0.00 | 0.00 | 594.97 |
| Zhang, Damien, C,26758 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| He, Curtis, D,24921 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Rivera, Evan, Y,26757 | 1344.47 | 0.00 | 0.00 | 1344.47 | 0.00 |
| Yuan, Cassie, J,24453 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Luo, Christine, J,24159 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| He, Eugene, L,13645 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Shan, Shawna, K,27869 | 2462.55 | 0.00 | 0.00 | 0.00 | 2462.55 |
| Thompson, Fernando,16350 | 5903.19 | 3578.27 | 0.00 | 0.00 | 2324.92 |
| Lin, Sandra, A,25052 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Sharma, Kelvin, D,26655 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Sharma, Cedric, A,14060 | 99.47 | 0.00 | 0.00 | 49.99 | 49.48 |
| Ramos, Joe,12353 | 6765.46 | 0.00 | 2071.42 | 0.00 | 4694.04 |
| Shan, Tasha,15192 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Alonso, Alfredo, T,23323 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Chande, Bonnie, L,23992 | 3167.82 | 0.00 | 0.00 | 2443.35 | 724.47 |
| Xu, Casey, J,13158 | 221.91 | 0.00 | 0.00 | 64.97 | 156.94 |
| Martinez, Heidi, L,22922 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| She, Yolanda, M,18304 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Shen, Devon, G,27358 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Simmons, Jordyn,16494 | 5961.20 | 3578.27 | 0.00 | 0.00 | 2382.93 |
| Gill, Gina, F,24177 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Sara, Marco, L,15641 | 96.75 | 0.00 | 0.00 | 0.00 | 96.75 |
| Subram, Raymond,23994 | 2790.52 | 0.00 | 0.00 | 2181.56 | 608.96 |
| Zhu, Dawn,26661 | 1912.47 | 0.00 | 0.00 | 782.99 | 1129.48 |
| Jones, Destiny,15171 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Deng, Tracy, E,21978 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Goel, Roger, A,23652 | 3907.54 | 0.00 | 0.00 | 2181.56 | 1725.98 |
| Rodriguez, Arthur,15438 | 3788.68 | 0.00 | 0.00 | 2071.42 | 1717.26 |
| Griffin, Olivia,21208 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Madan, Kristi, I,29184 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Li, Gilbert,23999 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Perez, Evelyn,14346 | 3583.26 | 0.00 | 0.00 | 2071.42 | 1511.84 |
| Chander, Melvin, L,24266 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Jimenez, Kathleen,26654 | 1346.76 | 0.00 | 0.00 | 1346.76 | 0.00 |
| Gill, Gary, B,25108 | 2199.41 | 0.00 | 0.00 | 1000.44 | 1198.97 |
| Sharma, Raul, E,16347 | 5918.50 | 3578.27 | 0.00 | 0.00 | 2340.23 |
| Raje, Kurt,15210 | 2926.39 | 0.00 | 0.00 | 2071.42 | 854.97 |
| Alvarez, Lori, C,26662 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Lopez, Virginia, J,27338 | 1339.92 | 0.00 | 0.00 | 782.99 | 556.93 |
| Gao, Stacey,16662 | 4355.71 | 3578.27 | 0.00 | 777.44 | 0.00 |
| Zhu, Suzanne, E,25112 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Suarez, Dana, M,23541 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Liu, Randy,15015 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Li, Elijah,16740 | 6099.10 | 3578.27 | 0.00 | 2520.83 | 0.00 |
| Zhao, Colin, D,24241 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Hernandez, Raquel, W,13997 | 4586.35 | 0.00 | 0.00 | 2071.42 | 2514.93 |
| Guo, Micah, M,24163 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 8.99 | 64.97 |
| Wang, Lacey,24173 | 2771.52 | 0.00 | 0.00 | 2181.56 | 589.96 |
| Cook, Isaac, M,13994 | 4528.75 | 0.00 | 0.00 | 2071.42 | 2457.33 |
| Ye, Alejandro, W,15029 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Liu, Autumn, J,20985 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Lin, Jake,24248 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Hill, Aaron,25818 | 35.96 | 0.00 | 0.00 | 0.00 | 35.96 |
| Suarez, Meredith,15032 | 3800.08 | 0.00 | 0.00 | 2049.10 | 1750.98 |
| Serrano, Julio,20992 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Ma, Roger, V,15130 | 5215.40 | 0.00 | 0.00 | 2049.10 | 3166.30 |
| Chavez, Colin,16032 | 90.95 | 0.00 | 0.00 | 21.98 | 68.97 |
| Romero, Deanna, K,23570 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Li, Marshall,12687 | 6805.47 | 0.00 | 2071.42 | 0.00 | 4734.05 |
| Huang, Rosa, P,15181 | 4448.38 | 0.00 | 0.00 | 2071.42 | 2376.96 |
| Dominguez, Sabrina, M,28116 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Suri, Stanley, J,27496 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Jones, Emily,16659 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Chande, Ashlee, N,23096 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Deng, Johnny,21409 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Raji, Warren, J,26796 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Zheng, Jeffery, W,15030 | 3786.39 | 0.00 | 0.00 | 2071.42 | 1714.97 |
| Raman, Abby, T,15122 | 5193.72 | 0.00 | 0.00 | 2071.42 | 3122.30 |
| Huang, Lisa, L,14102 | 3667.23 | 0.00 | 0.00 | 2910.90 | 756.33 |
| Martinez, Emma,16734 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Arthur, Kristi, W,16675 | 4385.03 | 3578.27 | 0.00 | 806.76 | 0.00 |
| Ortega, Latasha,24270 | 2844.51 | 0.00 | 0.00 | 2181.56 | 662.95 |
| Serrano, Joanna, J,26663 | 1976.94 | 0.00 | 0.00 | 782.99 | 1193.95 |
| Gonzalez, Joel, A,15043 | 3846.89 | 0.00 | 0.00 | 2071.42 | 1775.47 |
| Rodriguez, Allen, L,17732 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Perez, Rachael, D,26762 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Gonzalez, Shane, Y,14125 | 3772.41 | 0.00 | 0.00 | 3772.41 | 0.00 |
| Gutierrez, Micheal, S,27299 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Zhu, Gilbert,11921 | 63.24 | 0.00 | 0.00 | 0.00 | 63.24 |
| Andersen, Deborah,19610 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Pal, Donna, S,23572 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Hernandez, Jessie, A,24172 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Romero, Renee, E,16639 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Gomez, Teresa, D,24164 | 2760.02 | 0.00 | 0.00 | 2181.56 | 578.46 |
| Gao, Jorge,23573 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Zeng, Amy,24242 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Ruiz, Bruce, W,16171 | 103.86 | 0.00 | 0.00 | 0.00 | 103.86 |
| Gao, Randy,25113 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Murphy, Grace, J,23655 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
Generated 2025-11-03 20:52:48.286 UTC