[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 |
|---|---|---|---|---|---|
| Raje, Grant, S,24162 | 3004.83 | 0.00 | 0.00 | 2443.35 | 561.48 |
| Andersen, Drew, K,22412 | 3018.33 | 0.00 | 2443.35 | 574.98 | 0.00 |
| Gonzalez, Ebony,11034 | 6491.32 | 3399.99 | 0.00 | 0.00 | 3091.33 |
| Arthur, Cassandra, M,22410 | 2983.34 | 0.00 | 2443.35 | 539.99 | 0.00 |
| Patel, Marco, L,19575 | 60.05 | 0.00 | 0.00 | 23.78 | 36.27 |
| Mehta, Denise,13080 | 6844.41 | 0.00 | 2049.10 | 2362.27 | 2433.04 |
| Yuan, Grant, C,24909 | 2149.91 | 0.00 | 1000.44 | 1149.47 | 0.00 |
| Anand, Tamara,29088 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Vazquez, Armando,22571 | 2835.02 | 0.00 | 2181.56 | 653.46 | 0.00 |
| Martinez, Ian,12585 | 2629.07 | 0.00 | 2049.10 | 0.00 | 579.97 |
| Serrano, Max, E,12010 | 8203.50 | 0.00 | 3374.99 | 2384.96 | 2443.55 |
| Vazquez, Theresa, F,22581 | 2749.32 | 0.00 | 2181.56 | 567.76 | 0.00 |
| Rubio, Nelson,26433 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| Mehta, Ebony, J,22854 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Fernandez, Allen,19596 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Suarez, Erika,15120 | 5217.70 | 0.00 | 0.00 | 2049.10 | 3168.60 |
| Lal, Kara,22579 | 2730.54 | 0.00 | 2181.56 | 548.98 | 0.00 |
| Martinez, Ann,12009 | 8195.50 | 0.00 | 3399.99 | 2376.45 | 2419.06 |
| Yuan, Maurice,24380 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Suarez, Joy, B,12665 | 74.54 | 0.00 | 0.00 | 2.29 | 72.25 |
| Vance, Monica, G,12338 | 8265.00 | 0.00 | 3374.99 | 2436.97 | 2453.04 |
| Raman, César, C,24004 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Gill, Jaime, M,26152 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Madan, Candace,22409 | 2746.04 | 0.00 | 2181.56 | 564.48 | 0.00 |
| Yuan, Chad, C,21173 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Gutierrez, Hector,26423 | 2001.97 | 0.00 | 782.99 | 0.00 | 1218.98 |
| Simmons, Isabel, H,26432 | 123.98 | 0.00 | 0.00 | 123.98 | 0.00 |
| Ms., Robinson, Dorothy, B.,11952 | 8169.00 | 0.00 | 3374.99 | 2395.96 | 2398.05 |
| Blanco, Alberto, R,27867 | 2443.55 | 0.00 | 0.00 | 0.00 | 2443.55 |
| Price, Megan,24907 | 2183.91 | 0.00 | 1000.44 | 1183.47 | 0.00 |
| Blanco, Kari,19627 | 41.75 | 0.00 | 0.00 | 41.75 | 0.00 |
| Navarro, Latasha, L,11100 | 8172.51 | 3374.99 | 0.00 | 2399.47 | 2398.05 |
| Sai, Bryant, S,22577 | 2743.04 | 0.00 | 2181.56 | 561.48 | 0.00 |
| Lu, Valerie,22913 | 4684.39 | 0.00 | 2181.56 | 0.00 | 2502.83 |
| Dominguez, Theodore, F,21987 | 4638.89 | 0.00 | 2181.56 | 0.00 | 2457.33 |
| Romero, Gary,22181 | 4673.88 | 0.00 | 2181.56 | 0.00 | 2492.32 |
| Zeng, Ernest, M,12992 | 158.51 | 0.00 | 0.00 | 36.27 | 122.24 |
| Kelly, Emma, A,15646 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Adams, Sydney,27367 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| 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 |
| Goel, Roger, A,23652 | 3907.54 | 0.00 | 0.00 | 2181.56 | 1725.98 |
| She, Brittney, M,22942 | 3971.53 | 0.00 | 2181.56 | 0.00 | 1789.97 |
| Ramos, Gloria, A,21365 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Gill, Carolyn,23094 | 67.93 | 0.00 | 0.00 | 67.93 | 0.00 |
| Xu, Calvin, E,27583 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Lal, Kelsey, T,24913 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
| Suri, Lydia,13126 | 6815.08 | 0.00 | 2049.10 | 0.00 | 4765.98 |
| Wang, Jeffery, E,18188 | 6093.20 | 3578.27 | 0.00 | 0.00 | 2514.93 |
| Ramos, Kristy,16682 | 66.58 | 0.00 | 0.00 | 36.59 | 29.99 |
| Becker, Gregory, M,13104 | 6894.44 | 0.00 | 2071.42 | 2394.97 | 2428.05 |
| Jimenez, Jaime, E,29095 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Shen, Lindsey,26560 | 1396.44 | 0.00 | 782.99 | 0.00 | 613.45 |
| Schmidt, Joe, M,22905 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Johnson, Logan, K,22931 | 3882.55 | 0.00 | 2181.56 | 1700.99 | 0.00 |
| Fernandez, Brandy, B,22958 | 4208.31 | 0.00 | 2443.35 | 0.00 | 1764.96 |
| Lewis, Hannah,26561 | 1336.96 | 0.00 | 782.99 | 0.00 | 553.97 |
| Sai, Preston, D,17046 | 4467.74 | 3578.27 | 0.00 | 889.47 | 0.00 |
| Edwards, Carlos,16680 | 104.86 | 0.00 | 0.00 | 0.00 | 104.86 |
| Rai, Calvin,15229 | 2833.57 | 0.00 | 0.00 | 2049.10 | 784.47 |
| Guo, Louis, D,15764 | 4413.39 | 0.00 | 0.00 | 2071.42 | 2341.97 |
| Sanchez, Bryant, C,13113 | 6832.41 | 0.00 | 2071.42 | 0.00 | 4760.99 |
| Alvarez, Stacy,11901 | 8248.01 | 0.00 | 3399.99 | 2374.98 | 2473.04 |
| Kovar, Nancy, F,26568 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Perez, Toni,15581 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| Munoz, Ebony,13106 | 5697.52 | 0.00 | 2071.42 | 0.00 | 3626.10 |
| Kapoor, Bryant,22946 | 3911.53 | 0.00 | 2181.56 | 1729.97 | 0.00 |
| Smith, Christian, L,14313 | 222.44 | 0.00 | 0.00 | 0.00 | 222.44 |
| Morgan, Sara,13134 | 5648.92 | 0.00 | 2049.10 | 0.00 | 3599.82 |
| Ortega, Lance, C,12354 | 6797.13 | 0.00 | 2049.10 | 2309.97 | 2438.06 |
| Vazquez, Diane, D,11987 | 279.23 | 0.00 | 0.00 | 165.28 | 113.95 |
| Blanco, Cheryl,13524 | 4528.75 | 0.00 | 2071.42 | 2457.33 | 0.00 |
| Ms., Salavaria, Sharon,11964 | 8173.53 | 0.00 | 3399.99 | 2329.99 | 2443.55 |
| Jai, Carly,22986 | 2756.54 | 0.00 | 2181.56 | 0.00 | 574.98 |
| Martinez, Emma,16734 | 128.97 | 0.00 | 0.00 | 128.97 | 0.00 |
| Tang, Wayne, S,13090 | 6812.42 | 0.00 | 2049.10 | 2344.26 | 2419.06 |
| Luo, Dustin,17240 | 4385.03 | 3578.27 | 0.00 | 0.00 | 806.76 |
| Stone, Mitchell,25013 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Zhou, Heather, M,24914 | 2149.91 | 0.00 | 1000.44 | 1149.47 | 0.00 |
| Shan, Elijah, L,26795 | 1992.46 | 0.00 | 0.00 | 782.99 | 1209.47 |
| Li, Glenn, A,29295 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Chapman, Pamela, L,27145 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Xu, Kate, R,28957 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Wu, Ernest, L,11147 | 8195.50 | 3374.99 | 0.00 | 2376.96 | 2443.55 |
| Serrano, Neil, L,17076 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Foster, Lucas,13519 | 4492.45 | 0.00 | 2049.10 | 2443.35 | 0.00 |
| Raji, Brendan,13103 | 6842.60 | 0.00 | 2049.10 | 2395.45 | 2398.05 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 2181.56 | 1308.47 | 0.00 |
| Anand, Alison, J,24009 | 2746.04 | 0.00 | 0.00 | 2181.56 | 564.48 |
| Tang, Latoya, F,22910 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| 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 |
| Xu, Terry,24228 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Diaz, Samuel,14065 | 5608.55 | 0.00 | 0.00 | 3286.27 | 2322.28 |
| She, Keith, L,26563 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Romero, Meredith, J,29452 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Kumar, Cristina, N,15426 | 115.92 | 0.00 | 0.00 | 106.93 | 8.99 |
| Gutierrez, Joy, A,18466 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Munoz, Audrey, V,12003 | 8256.50 | 0.00 | 3374.99 | 2399.47 | 2482.04 |
| Wang, Alan,13622 | 6841.43 | 0.00 | 2071.42 | 0.00 | 4770.01 |
| Patel, Summer, G,26753 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Gutierrez, Clinton,21001 | 3018.33 | 0.00 | 2443.35 | 574.98 | 0.00 |
| Xu, Sharon, A,23344 | 3882.55 | 0.00 | 2181.56 | 1700.99 | 0.00 |
| Suarez, Jerome, L,20622 | 6139.59 | 0.00 | 3578.27 | 0.00 | 2561.32 |
| Lin, Damien, L,23414 | 3391.03 | 0.00 | 2181.56 | 1209.47 | 0.00 |
| Ramos, Danny,23121 | 4144.34 | 0.00 | 2443.35 | 1700.99 | 0.00 |
| Moreno, Monique, R,23118 | 3913.82 | 0.00 | 2181.56 | 1732.26 | 0.00 |
| Gomez, Gary,15640 | 34.57 | 0.00 | 0.00 | 34.57 | 0.00 |
| Raji, Brad, C,23409 | 3917.54 | 0.00 | 2181.56 | 1735.98 | 0.00 |
| Ye, Damien, M,13620 | 6848.07 | 0.00 | 2049.10 | 0.00 | 4798.97 |
| Raji, Andres, E,13955 | 6888.44 | 0.00 | 2071.42 | 0.00 | 4817.02 |
| Zhu, Roger, J,28098 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Diaz, Felicia, J,15026 | 29.98 | 0.00 | 0.00 | 24.99 | 4.99 |
| Rana, Pedro, F,13970 | 6843.14 | 0.00 | 2049.10 | 0.00 | 4794.04 |
| Jimenez, Naomi,24922 | 2145.92 | 0.00 | 1000.44 | 1145.48 | 0.00 |
| Pal, Dustin,26588 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Johnson, Elizabeth,11004 | 8196.01 | 3399.99 | 0.00 | 4796.02 | 0.00 |
| Allen, Kaylee,26653 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Madan, Johnathan, D,13626 | 6909.09 | 0.00 | 0.00 | 4436.04 | 2473.05 |
| 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 |
| Liang, Darryl,26658 | 1390.95 | 0.00 | 0.00 | 1390.95 | 0.00 |
| Anand, Cassie, M,29342 | 801.83 | 0.00 | 0.00 | 0.00 | 801.83 |
| Sanz, Bruce,23117 | 3931.52 | 0.00 | 0.00 | 3931.52 | 0.00 |
| Liu, Krystal, D,13526 | 4549.76 | 0.00 | 0.00 | 4549.76 | 0.00 |
Generated 2026-07-22 12:01:40.218 UTC