[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Lal, Cristina, M,14671 | 2934.37 | 0.00 | 0.00 | 2071.42 | 862.95 |
| Wu, Lisa,26158 | 94.48 | 0.00 | 0.00 | 94.48 | 0.00 |
| Shen, Kathryn, R,21957 | 4919.30 | 0.00 | 2443.35 | 0.00 | 2475.95 |
| Collins, Rebecca, M,26153 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Sanchez, Candace, L,21567 | 4973.28 | 0.00 | 2443.35 | 0.00 | 2529.93 |
| Carlson, Jill,21886 | 4696.49 | 0.00 | 2181.56 | 0.00 | 2514.93 |
| Shan, Tony, M,16175 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Alvarez, Erik, M,14311 | 138.45 | 0.00 | 0.00 | 74.48 | 63.97 |
| Hernandez, Armando,21950 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Zhou, Warren,19791 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Xu, Clarence,21877 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Raje, Lindsey,24614 | 2120.93 | 0.00 | 1000.44 | 1120.49 | 0.00 |
| Diaz, Devin, D,15829 | 187.98 | 0.00 | 0.00 | 187.98 | 0.00 |
| Sun, Erica, P,26135 | 1967.45 | 0.00 | 782.99 | 0.00 | 1184.46 |
| Foster, Luke,15137 | 161.94 | 0.00 | 0.00 | 161.94 | 0.00 |
| Jai, Drew, M,21562 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| Mehta, Cindy, A,21943 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Hall, Mary, R,20277 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Xu, Kara, E,22212 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Rana, Nancy, H,26150 | 1992.46 | 0.00 | 782.99 | 0.00 | 1209.47 |
| Dominguez, Micheal,26142 | 1952.45 | 0.00 | 782.99 | 0.00 | 1169.46 |
| Subram, Francisco, A,21897 | 4909.67 | 0.00 | 2443.35 | 0.00 | 2466.32 |
| Fernandez, Cassandra, C,14134 | 3835.07 | 0.00 | 0.00 | 3835.07 | 0.00 |
| Ramos, Jay, D,21882 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Chander, Latoya, C,26138 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Serrano, Hector, K,28308 | 588.96 | 0.00 | 0.00 | 588.96 | 0.00 |
| Xie, Brendan,13018 | 2642.38 | 0.00 | 2071.42 | 0.00 | 570.96 |
| Flores, Alexandra, C,26165 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Srini, Joe,22180 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| Torres, Jacqueline,21976 | 4198.33 | 0.00 | 2443.35 | 0.00 | 1754.98 |
| Murphy, Jill, J,24902 | 2120.93 | 0.00 | 1000.44 | 1120.49 | 0.00 |
| Ortega, Shannon,26375 | 1971.45 | 0.00 | 782.99 | 0.00 | 1188.46 |
| Malhotra, Toni,26162 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| Dominguez, Larry,22197 | 4740.98 | 0.00 | 2181.56 | 0.00 | 2559.42 |
| Vance, George, R,12038 | 66.76 | 0.00 | 0.00 | 2.29 | 64.47 |
| Ortega, Meghan, E,22004 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
| Lu, Micah,22174 | 3007.83 | 0.00 | 2443.35 | 564.48 | 0.00 |
| Deng, Jaime, R,21968 | 4722.88 | 0.00 | 2181.56 | 0.00 | 2541.32 |
| Serrano, Reginald, J,13025 | 2690.40 | 0.00 | 2071.42 | 0.00 | 618.98 |
| Wang, Erica, J,22168 | 2997.32 | 0.00 | 2443.35 | 553.97 | 0.00 |
| Liang, Louis, M,12706 | 6851.41 | 0.00 | 2071.42 | 2331.95 | 2448.04 |
| Romero, Francis,22196 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| Yuan, Jaclyn,24904 | 2199.90 | 0.00 | 1000.44 | 1199.46 | 0.00 |
| Sai, Ross, A,21966 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Diaz, Kendra,13021 | 2668.38 | 0.00 | 2071.42 | 0.00 | 596.96 |
| Lin, Kelvin, A,13075 | 6843.94 | 0.00 | 2071.42 | 2294.99 | 2477.53 |
| Munoz, Craig, V,13076 | 6862.14 | 0.00 | 2049.10 | 2428.97 | 2384.07 |
| Wang, Autumn,13049 | 5647.22 | 0.00 | 2071.42 | 1223.84 | 2351.96 |
| Rana, Whitney, A,13006 | 6762.15 | 0.00 | 2049.10 | 2319.99 | 2393.06 |
| Gonzalez, Meredith,22171 | 2721.55 | 0.00 | 2181.56 | 539.99 | 0.00 |
| Perez, Ebony, M,24900 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
| Suri, Whitney, J,21974 | 4925.17 | 0.00 | 2443.35 | 0.00 | 2481.82 |
| Serrano, Pedro,26189 | 1926.45 | 0.00 | 782.99 | 0.00 | 1143.46 |
| Long, Alexis,22580 | 3051.31 | 0.00 | 2443.35 | 607.96 | 0.00 |
| Arthur, Cassandra, M,22410 | 2983.34 | 0.00 | 2443.35 | 539.99 | 0.00 |
| Sanchez, Nancy, L,22207 | 4921.69 | 0.00 | 2443.35 | 0.00 | 2478.34 |
| Mehta, Denise,13080 | 6844.41 | 0.00 | 2049.10 | 2362.27 | 2433.04 |
| Carlson, Briana,26436 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Madan, Evelyn, D,22582 | 2756.54 | 0.00 | 2181.56 | 0.00 | 574.98 |
| Edwards, Kaylee, M,22851 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| Rubio, Nelson,26433 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| Shen, Alisha, J,26438 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Shen, Mitchell, M,22904 | 4759.99 | 0.00 | 2181.56 | 0.00 | 2578.43 |
| Lal, Kara,22579 | 2730.54 | 0.00 | 2181.56 | 548.98 | 0.00 |
| She, Kathryn, I,26443 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Gonzalez, Carolyn, H,22407 | 2756.54 | 0.00 | 2181.56 | 574.98 | 0.00 |
| Sanz, Lance,22573 | 2721.55 | 0.00 | 2181.56 | 539.99 | 0.00 |
| He, Amy,22411 | 2770.52 | 0.00 | 2181.56 | 588.96 | 0.00 |
| Yuan, Grant, C,24909 | 2149.91 | 0.00 | 1000.44 | 1149.47 | 0.00 |
| Goel, Yolanda, M,26435 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Price, Megan,24907 | 2183.91 | 0.00 | 1000.44 | 1183.47 | 0.00 |
| Ortega, Reginald, K,26429 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Guo, Jon,22927 | 3913.82 | 0.00 | 2181.56 | 0.00 | 1732.26 |
| Jai, Maurice,22932 | 4169.33 | 0.00 | 2443.35 | 1725.98 | 0.00 |
| Moreno, Mallory, P,22912 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Liang, Barbara, T,22953 | 3899.49 | 0.00 | 2181.56 | 1717.93 | 0.00 |
| Sai, Barry,22907 | 4169.33 | 0.00 | 2443.35 | 0.00 | 1725.98 |
| Nelson, Mary, L,13107 | 5650.90 | 0.00 | 2049.10 | 0.00 | 3601.80 |
| Mehta, Levi, M,13110 | 5583.94 | 0.00 | 2049.10 | 0.00 | 3534.84 |
| Andersen, Karl, M,23105 | 3361.53 | 0.00 | 2181.56 | 1179.97 | 0.00 |
| Goel, Tommy,22909 | 3980.52 | 0.00 | 2181.56 | 0.00 | 1798.96 |
| Davis, Isabella, A,22929 | 4673.88 | 0.00 | 2181.56 | 0.00 | 2492.32 |
| Arthur, Rebekah,22939 | 3961.03 | 0.00 | 2181.56 | 0.00 | 1779.47 |
| Gomez, Arthur,24917 | 2179.91 | 0.00 | 1000.44 | 1179.47 | 0.00 |
| Lal, Kelsey, T,24913 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
| Rai, Michele, M,26567 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Rai, Johnny, A,13135 | 6773.14 | 0.00 | 2049.10 | 2304.98 | 2419.06 |
| Kovár, Whitney,13105 | 5585.45 | 0.00 | 2049.10 | 0.00 | 3536.35 |
| Shen, Kelsey, R,22921 | 4647.88 | 0.00 | 2181.56 | 0.00 | 2466.32 |
| Diaz, Jill, F,22936 | 3946.52 | 0.00 | 2181.56 | 0.00 | 1764.96 |
| Cox, Catherine, K,13122 | 6871.43 | 0.00 | 2071.42 | 2380.95 | 2419.06 |
| Lewis, Hannah,26561 | 1336.96 | 0.00 | 782.99 | 0.00 | 553.97 |
| Kennedy, Devon, J,13133 | 6813.12 | 0.00 | 2049.10 | 0.00 | 4764.02 |
| Shen, Tamara, G,22935 | 3951.52 | 0.00 | 2181.56 | 0.00 | 1769.96 |
| Sanchez, Bryant, C,13113 | 6832.41 | 0.00 | 2071.42 | 0.00 | 4760.99 |
| Kovar, Nancy, F,26568 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Natsuhara, Tony,23097 | 2770.52 | 0.00 | 2181.56 | 0.00 | 588.96 |
| Munoz, Ebony,13106 | 5697.52 | 0.00 | 2071.42 | 0.00 | 3626.10 |
| Morgan, Sara,13134 | 5648.92 | 0.00 | 2049.10 | 0.00 | 3599.82 |
| Kumar, Tonya, A,22934 | 4173.32 | 0.00 | 2443.35 | 0.00 | 1729.97 |
| Yuan, Keith, N,22926 | 3936.54 | 0.00 | 2181.56 | 0.00 | 1754.98 |
| Mehta, Chelsea,22951 | 4242.31 | 0.00 | 2443.35 | 1798.96 | 0.00 |
| Diaz, Briana,13131 | 6737.15 | 0.00 | 2049.10 | 0.00 | 4688.05 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 782.99 | 0.00 | 578.46 |
| Wu, Clarence, L,13115 | 6779.42 | 0.00 | 2049.10 | 0.00 | 4730.32 |
| Foster, Lucas,13519 | 4492.45 | 0.00 | 2049.10 | 2443.35 | 0.00 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 2181.56 | 1308.47 | 0.00 |
| Raman, Brett, L,22930 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 2443.35 | 0.00 | 1735.98 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 2049.10 | 0.00 | 4768.04 |
| Garcia, Martin, l,23332 | 4144.34 | 0.00 | 2443.35 | 1700.99 | 0.00 |
| Arun, Brenda,13630 | 6824.73 | 0.00 | 2071.42 | 0.00 | 4753.31 |
| Perez, Ivan, S,23408 | 4218.82 | 0.00 | 2443.35 | 1775.47 | 0.00 |
| Lin, Damien, L,23414 | 3391.03 | 0.00 | 2181.56 | 1209.47 | 0.00 |
| Zhang, Glenn, A,13967 | 5721.91 | 0.00 | 2049.10 | 0.00 | 3672.81 |
| Hughes, Lucas, E,26657 | 1357.97 | 0.00 | 782.99 | 574.98 | 0.00 |
| Allen, Kaylee,26653 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Munoz, Theresa, M,13953 | 6840.75 | 0.00 | 0.00 | 2071.42 | 4769.33 |
| Rodriguez, Jarrod,13636 | 6831.76 | 0.00 | 0.00 | 2071.42 | 4760.34 |
| Dominguez, Kristi, M,13644 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Sai, Emmanuel,23417 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Suarez, Rebekah,13649 | 6812.13 | 0.00 | 0.00 | 2049.10 | 4763.03 |
| Hall, Amanda,26656 | 1345.95 | 0.00 | 0.00 | 1345.95 | 0.00 |
| Li, Wesley,23322 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Munoz, Cheryl, C,13632 | 6838.46 | 0.00 | 0.00 | 2071.42 | 4767.04 |
Generated 2026-07-21 21:18:20.025 UTC