[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1125 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ferrier, Edwin, J,15757 | 4366.41 | 0.00 | 0.00 | 2071.42 | 2294.99 |
| Moore, Devin, J,16167 | 102.57 | 0.00 | 0.00 | 0.00 | 102.57 |
| Raman, Pamela, C,27369 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Vazquez, Diane, D,11987 | 279.23 | 0.00 | 0.00 | 0.00 | 279.23 |
| Suri, Adriana,18463 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Guo, Autumn, A,14213 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Nara, Gregory,26651 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Xu, Terry,24228 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Nara, Jaclyn, M,11930 | 5035.81 | 0.00 | 3399.99 | 0.00 | 1635.82 |
| Carlson, Briana,26436 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Sai, Ronald, B,13643 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Liang, Glenn,21983 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Ray, Bobby,23575 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Cai, Shannon,26156 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Sanz, Hector,27344 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Prasad, Marco, C,15606 | 115.93 | 0.00 | 0.00 | 0.00 | 115.93 |
| Ortega, Danny, K,19794 | 6098.58 | 0.00 | 3578.27 | 0.00 | 2520.31 |
| Holt, Alisha,28350 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Xu, Martha, C,16351 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Shen, Rafael, J,16689 | 290.46 | 0.00 | 0.00 | 0.00 | 290.46 |
| Beck, Barbara,26547 | 1407.96 | 0.00 | 0.00 | 782.99 | 624.97 |
| Raji, Warren, J,26796 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Powell, Trevor, C,26922 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Vazquez, Rebekah, A,15784 | 4379.09 | 0.00 | 0.00 | 2049.10 | 2329.99 |
| Deng, April,11117 | 8184.99 | 0.00 | 3399.99 | 2365.94 | 2419.06 |
| Andersen, Jodi,26766 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Adams, Devin,21871 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Ruiz, Francis, D,21381 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hu, Alvin, E,11449 | 8130.32 | 0.00 | 3374.99 | 2362.27 | 2393.06 |
| Munoz, Ebony,13106 | 5697.52 | 0.00 | 0.00 | 2071.42 | 3626.10 |
| Sai, Jay, A,23427 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Anderson, Victoria,15799 | 4423.38 | 0.00 | 0.00 | 2071.42 | 2351.96 |
| Townsend, Darren,18467 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Jimenez, Krista,18257 | 115.95 | 0.00 | 0.00 | 0.00 | 115.95 |
| Xu, Peter, K,28204 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Yuan, Melvin,29331 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Fernandez, Candace,11105 | 8095.99 | 0.00 | 3399.99 | 2294.99 | 2401.01 |
| Sharma, Andres, C,24230 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Dominguez, Larry,22197 | 4740.98 | 0.00 | 0.00 | 2181.56 | 2559.42 |
| Sutton, Cassie, S,16613 | 129.35 | 0.00 | 0.00 | 0.00 | 129.35 |
| Wang, Shannon,11017 | 6434.31 | 3374.99 | 0.00 | 2316.97 | 742.35 |
| Gao, Jamie,26022 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Zheng, Alisha,22203 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Parker, Gabriella,21394 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Torres, Michele, A,16176 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Subram, Evelyn, S,21257 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Suri, Cesar,17512 | 4170.54 | 0.00 | 3578.27 | 592.27 | 0.00 |
| Diaz, Nelson, C,21387 | 2745.33 | 0.00 | 2181.56 | 0.00 | 563.77 |
| Lopez, Manuel, M,14050 | 5650.24 | 0.00 | 0.00 | 3295.26 | 2354.98 |
| Arun, Candace, J,21393 | 4925.17 | 0.00 | 2443.35 | 0.00 | 2481.82 |
| Ashe, Briana,22940 | 4207.32 | 0.00 | 0.00 | 4207.32 | 0.00 |
| Gutierrez, Jill, N,26024 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Zeng, Alisha, A,15727 | 134.46 | 0.00 | 0.00 | 0.00 | 134.46 |
| Ms., Roy, Lisa, K.,21403 | 4895.69 | 0.00 | 0.00 | 2443.35 | 2452.34 |
| Lu, Valerie,22913 | 4684.39 | 0.00 | 0.00 | 2181.56 | 2502.83 |
| Henderson, Cassidy,21228 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Sai, Cesar,18243 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Luo, Johnny,21359 | 3032.31 | 0.00 | 0.00 | 2443.35 | 588.96 |
| Mehta, Levi, M,13110 | 5583.94 | 0.00 | 0.00 | 2049.10 | 3534.84 |
| Huang, Colleen, S,21379 | 2992.33 | 0.00 | 0.00 | 2443.35 | 548.98 |
| Huang, Brent,18220 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Xu, Kelvin, K,21222 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Munoz, Deanna,11054 | 8223.02 | 3399.99 | 0.00 | 2403.97 | 2419.06 |
| Chow, Christy, M,12681 | 6784.13 | 0.00 | 0.00 | 2049.10 | 4735.03 |
| Suri, Rachael, J,18279 | 162.02 | 0.00 | 0.00 | 0.00 | 162.02 |
| Jai, Latoya, S,21229 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Lal, Terrence,12369 | 94.23 | 0.00 | 0.00 | 0.00 | 94.23 |
| Lal, Kate,21557 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Shen, Shawn,19270 | 4127.25 | 0.00 | 3578.27 | 548.98 | 0.00 |
| Ortega, Tyrone, H,12583 | 2646.40 | 0.00 | 0.00 | 2071.42 | 574.98 |
| Zheng, Colleen,13026 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Shen, Kathryn, R,21957 | 4919.30 | 0.00 | 0.00 | 2443.35 | 2475.95 |
| Bryant, Lauren,11752 | 137.87 | 0.00 | 0.00 | 0.00 | 137.87 |
| Navarro, Stacy, C,12688 | 6867.44 | 0.00 | 0.00 | 2071.42 | 4796.02 |
| She, Alvin, E,16657 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Srini, Roy,24888 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Diaz, Kendra,13021 | 2668.38 | 0.00 | 0.00 | 2071.42 | 596.96 |
| Arthur, Jay, R,12694 | 6785.13 | 0.00 | 0.00 | 2049.10 | 4736.03 |
| Butler, Hannah, R,13111 | 5707.20 | 0.00 | 0.00 | 2071.42 | 3635.78 |
| Hernandez, Armando,21950 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Ma, Roger, V,15130 | 5215.40 | 0.00 | 0.00 | 2049.10 | 3166.30 |
| Xu, Rafael, A,21885 | 4641.85 | 0.00 | 0.00 | 2181.56 | 2460.29 |
| Black, Tommy,24376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rubio, Philip, P,21876 | 4663.38 | 0.00 | 0.00 | 2181.56 | 2481.82 |
| Gonzalez, Donald,11079 | 32.96 | 0.00 | 0.00 | 0.00 | 32.96 |
| Mehta, Cindy, A,21943 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Ms., Seidel, Birgit,16621 | 73.86 | 0.00 | 0.00 | 0.00 | 73.86 |
| Li, David, A,21894 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Moreno, Roberto, R,21206 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Mehta, Mayra,12998 | 5694.90 | 0.00 | 0.00 | 2049.10 | 3645.80 |
| Ruiz, Natasha,21994 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Chande, Michele, C,13078 | 6850.46 | 0.00 | 0.00 | 2071.42 | 4779.04 |
| Subram, Virginia,13036 | 2677.07 | 0.00 | 0.00 | 2049.10 | 627.97 |
| Lal, Leonard,26160 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Wang, Erica, J,22168 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Moreno, Felicia, A,12987 | 6759.47 | 0.00 | 0.00 | 2071.42 | 4688.05 |
| Lee, David, J,22199 | 4693.88 | 0.00 | 0.00 | 2181.56 | 2512.32 |
| Sai, Ross, A,21966 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Hernandez, Leslie, D,12990 | 6829.47 | 0.00 | 0.00 | 2071.42 | 4758.05 |
| Munoz, Craig, V,13076 | 6862.14 | 0.00 | 0.00 | 2049.10 | 4813.04 |
| Perez, Ebony, M,24900 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Lal, Deborah, T,21982 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Sai, Bruce,22194 | 4633.90 | 0.00 | 0.00 | 2181.56 | 2452.34 |
| Deng, Latoya, H,21969 | 4759.47 | 0.00 | 0.00 | 2181.56 | 2577.91 |
| Martinez, Anna, J,12994 | 6855.44 | 0.00 | 0.00 | 2071.42 | 4784.02 |
| Serrano, Pedro,26189 | 1926.45 | 0.00 | 0.00 | 782.99 | 1143.46 |
| Martin, Ruben,22400 | 2737.82 | 0.00 | 0.00 | 2181.56 | 556.26 |
| Nara, Kelsey, A,24905 | 2195.91 | 0.00 | 0.00 | 1000.44 | 1195.47 |
| Romero, Julio,22857 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Xie, Clarence,22402 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Mehta, Ebony, J,22854 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Fernandez, Arthur, J,22399 | 2785.05 | 0.00 | 0.00 | 2181.56 | 603.49 |
| Suri, Pedro,26422 | 1980.96 | 0.00 | 0.00 | 782.99 | 1197.97 |
| Luo, Lindsey, R,22201 | 5012.27 | 0.00 | 0.00 | 2443.35 | 2568.92 |
| Madan, Candace,22409 | 2746.04 | 0.00 | 0.00 | 2181.56 | 564.48 |
| Kumar, Cedric, B,22860 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Cai, Karen,22572 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Yuan, Grant, C,24909 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Shen, Kelvin,22406 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Ruiz, Krista, C,13081 | 6772.15 | 0.00 | 0.00 | 2049.10 | 4723.05 |
| Xu, Margaret, T,22404 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Xu, Alejandro, R,26585 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Sai, Barry,22907 | 4169.33 | 0.00 | 0.00 | 2443.35 | 1725.98 |
| Nelson, Mary, L,13107 | 5650.90 | 0.00 | 0.00 | 2049.10 | 3601.80 |
| Gomez, Arthur,24917 | 2179.91 | 0.00 | 0.00 | 1000.44 | 1179.47 |
Generated 2025-12-21 08:14:36.444 UTC