[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Dominguez, Lee, R,24597 | 4009.50 | 0.00 | 0.00 | 2181.56 | 1827.94 |
| Arthur, Kristi, W,16675 | 4385.03 | 3578.27 | 0.00 | 0.00 | 806.76 |
| Chander, Lindsay, R,19972 | 49.70 | 0.00 | 0.00 | 0.00 | 49.70 |
| Yuan, Bradley,17920 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Zhang, Kristen,27484 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Deng, Tasha,11459 | 8141.33 | 0.00 | 3399.99 | 0.00 | 4741.34 |
| Henderson, Wyatt,16697 | 87.08 | 0.00 | 0.00 | 0.00 | 87.08 |
| Xu, Alison,14227 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Young, Allison, R,23644 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Suri, Holly, M,18286 | 141.55 | 0.00 | 0.00 | 0.00 | 141.55 |
| Subram, Ronald, P,27733 | 157.29 | 0.00 | 0.00 | 0.00 | 157.29 |
| Sanchez, Andre,15595 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Shen, Brendan, L,14305 | 3652.20 | 0.00 | 0.00 | 2049.10 | 1603.10 |
| Gutierrez, Tabitha, A,21884 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Guo, Cara, R,15721 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Huang, Rosa, P,15181 | 4448.38 | 0.00 | 0.00 | 2071.42 | 2376.96 |
| Goel, Carly, C,12989 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Johnson, Sydney,19571 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Liang, Tiffany,11068 | 113.36 | 0.00 | 0.00 | 0.00 | 113.36 |
| Lopez, Patricia,28305 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Gutierrez, Jaime, A,25227 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sharma, Corey, M,17495 | 119.91 | 0.00 | 0.00 | 0.00 | 119.91 |
| White, Taylor, D,25011 | 1589.40 | 0.00 | 0.00 | 1000.44 | 588.96 |
| Jai, Melvin, M,27722 | 564.21 | 0.00 | 0.00 | 0.00 | 564.21 |
| Xu, Kelvin,18305 | 160.55 | 0.00 | 0.00 | 0.00 | 160.55 |
| Zheng, Dennis, E,25567 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Romero, Wendy, H,11372 | 4965.81 | 0.00 | 3374.99 | 0.00 | 1590.82 |
| Arthur, Jay, R,12694 | 6785.13 | 0.00 | 0.00 | 2049.10 | 4736.03 |
| Zimmerman, Jenny,18197 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Serrano, Diane, E,14857 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Sanchez, Manuel,15126 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Wang, Jaclyn, M,17063 | 100.25 | 0.00 | 0.00 | 0.00 | 100.25 |
| Vazquez, Lawrence,19632 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Ashe, Marshall,28932 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Blanco, Jimmy, V,14013 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Evans, Xavier,19098 | 122.24 | 0.00 | 0.00 | 0.00 | 122.24 |
| Zhu, Clarence, A,18462 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Deng, Kenneth,20235 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Torres, Alfredo,27685 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Guo, Lisa, S,17314 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Andersen, Rafael, E,12691 | 247.46 | 0.00 | 0.00 | 0.00 | 247.46 |
| Andersen, Brendan,15121 | 5202.73 | 0.00 | 0.00 | 2071.42 | 3131.31 |
| Torres, Melinda, J,14033 | 6809.96 | 0.00 | 0.00 | 2071.42 | 4738.54 |
| Rai, Shaun,26431 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Wu, Warren, M,15602 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Ye, Martha,22200 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Pal, Drew,11902 | 63.04 | 0.00 | 0.00 | 0.00 | 63.04 |
| Kapoor, Kristina,11997 | 7029.78 | 0.00 | 3399.99 | 0.00 | 3629.79 |
| Zeng, Brittney, K,13670 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Kapoor, Bryant,22946 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Mehta, Gerald,20234 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Zhang, Susan, S,18216 | 38.92 | 0.00 | 0.00 | 0.00 | 38.92 |
| Jai, Karla,18263 | 126.94 | 0.00 | 0.00 | 0.00 | 126.94 |
| Moreno, Pedro, A,18248 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Guo, Cedric, R,27487 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Lin, Margaret, C,18306 | 87.77 | 0.00 | 0.00 | 0.00 | 87.77 |
| Fernandez, Marie,28929 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Cai, Roger, A,13002 | 294.94 | 0.00 | 0.00 | 0.00 | 294.94 |
| Sanchez, Lydia, S,12579 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Xie, Marshall, M,19796 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Dominguez, Raquel, A,27470 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Vazquez, Joe, C,20418 | 4207.24 | 0.00 | 3578.27 | 0.00 | 628.97 |
| Shan, Thomas, N,27483 | 1382.46 | 0.00 | 0.00 | 782.99 | 599.47 |
| Parker, Timothy, C,22943 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Liu, Jessie,11106 | 8079.05 | 0.00 | 3399.99 | 2294.99 | 2384.07 |
| Blue, Richard,12006 | 144.74 | 0.00 | 0.00 | 0.00 | 144.74 |
| He, Jake, M,24472 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Sara, Ruben, A,19566 | 164.91 | 0.00 | 0.00 | 0.00 | 164.91 |
| Alonso, Jonathon, A,15238 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Ms., Sanchez, Madalena, J.,13020 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Liang, Vincent,20402 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Simmons, Jordyn,16494 | 5961.20 | 3578.27 | 0.00 | 0.00 | 2382.93 |
| Rai, Sharon,20225 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Rana, Raymond,25115 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Hill, Jennifer,18291 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Luo, Shawn,12246 | 3947.25 | 0.00 | 3374.99 | 0.00 | 572.26 |
| Ye, Krystal, M,26923 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Foster, Madison,14038 | 6819.12 | 0.00 | 0.00 | 2049.10 | 4770.02 |
| Goel, April, C,16166 | 108.85 | 0.00 | 0.00 | 0.00 | 108.85 |
| Kumar, Kate,17321 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Lin, Dawn, N,15805 | 127.47 | 0.00 | 0.00 | 0.00 | 127.47 |
| Yuan, Keith, N,22926 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Alvarez, Gloria, B,18297 | 6119.59 | 0.00 | 3578.27 | 0.00 | 2541.32 |
| Perez, Joe, A,14326 | 5207.70 | 0.00 | 0.00 | 2071.42 | 3136.28 |
| Gonzalez, Virginia,11929 | 4965.78 | 0.00 | 3374.99 | 0.00 | 1590.79 |
| Zeng, Heather, E,18287 | 72.16 | 0.00 | 0.00 | 0.00 | 72.16 |
| Rodriguez, Kristi,14345 | 3639.92 | 0.00 | 0.00 | 2049.10 | 1590.82 |
| She, Bradley, L,16016 | 117.93 | 0.00 | 0.00 | 0.00 | 117.93 |
| Martinez, Ivan,27872 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Madan, Marco,18895 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Zhang, Suzanne, R,20316 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cook, Sydney, D,13118 | 5669.90 | 0.00 | 0.00 | 2049.10 | 3620.80 |
| Jiménez, Darren, W,28931 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Liang, Omar,24245 | 17.27 | 0.00 | 0.00 | 0.00 | 17.27 |
| Yuan, Franklin,24594 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gill, Kellie,17292 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Black, Rafael,11966 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
| Andersen, Mitchell, H,25026 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Dominguez, Ebony, R,17350 | 127.47 | 0.00 | 0.00 | 0.00 | 127.47 |
| Gill, Lee, L,27694 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Ruiz, Carolyn, M,27863 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Patel, Gerald,23095 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Xu, Alejandro, R,26585 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Mehta, Preston, G,18692 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Ma, Lacey, K,18723 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Prasad, Preston, C,20812 | 4127.25 | 0.00 | 3578.27 | 0.00 | 548.98 |
| Tang, Rafael, A,11908 | 8079.05 | 0.00 | 3374.99 | 0.00 | 4704.06 |
| Subram, Martin, S,19590 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Raji, Brad, C,23409 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Liu, Krystal, D,13526 | 4549.76 | 0.00 | 0.00 | 2071.42 | 2478.34 |
| Alvarez, Arthur,24892 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gutierrez, Jonathon, R,16529 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Raji, Tammy, K,17071 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Navarro, Melinda,11454 | 8089.04 | 0.00 | 3374.99 | 2294.99 | 2419.06 |
| Simmons, Jacqueline, W,13137 | 177.94 | 0.00 | 0.00 | 0.00 | 177.94 |
| Brown, Cameron, D,13041 | 153.95 | 0.00 | 0.00 | 0.00 | 153.95 |
| Garcia, Chelsea,21961 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Fernandez, Shane, A,13127 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Nara, Rafael, J,17052 | 96.92 | 0.00 | 0.00 | 0.00 | 96.92 |
| Fernandez, George,19974 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Jimenez, Jimmy,27365 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Yang, Clarence, D,25121 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Sanz, Roy, R,11917 | 8121.33 | 0.00 | 3399.99 | 0.00 | 4721.34 |
| Torres, Kari,18486 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Yang, Louis, J,23013 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
Generated 2025-12-20 21:40:21.584 UTC