[ROOT]  dt  FactInternetSale  WHERE DimCurrency.AlternateKey EQ 'AUD'  >   PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount   <  ORDER BY 2020   <  SKIP 2500  >   <  TAKE 250  >   

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Blanco, Krista, L,2758039.980.000.000.0039.98
Luo, Priscilla, R,1790727.770.000.000.0027.77
Alonso, Jerome, H,27977553.970.000.000.00553.97
Lopez, Patricia,2830529.480.000.000.0029.48
Alexander, Hailey, C,1966635.000.000.000.0035.00
Pal, Nina,29297613.450.000.000.00613.45
Gao, Lisa, A,197534.990.000.000.004.99
Henderson, Isabella, L,2198175.970.000.000.0075.97
Gutierrez, Joy, A,1846653.990.000.000.0053.99
Fernandez, Marie,289297.280.000.000.007.28
Liang, Eugene,1397277.270.000.000.0077.27
Munoz, Briana,234374.990.000.000.004.99
Ma, Louis,2187935.000.000.000.0035.00
Jai, Alison,236574.990.000.000.004.99
Gao, Eugene,29464756.330.000.000.00756.33
Davis, Ryan, C,278702419.060.000.000.002419.06
Guo, Lisa, S,1731478.960.000.000.0078.96
Zhao, Crystal,259066.280.000.000.006.28
Schmidt, Danny, M,289267.280.000.000.007.28
Zhang, James,1468438.550.000.000.0038.55
Subram, Ross, L,230857.280.000.000.007.28
Ruiz, Alberto, L,2521227.770.000.000.0027.77
Lu, Warren, H,289257.280.000.000.007.28
Shen, Michele,27985539.990.000.000.00539.99
Ramos, Kendra,2489615.230.000.000.0015.23
Gill, Joanna,2618638.980.000.000.0038.98
Reed, Kimberly, D,1731169.970.000.000.0069.97
Chandra, Virginia, M,2758815.230.000.000.0015.23
Cox, Angel, M,1879330.480.000.000.0030.48
Li, Cara,275871145.480.000.000.001145.48
Ramos, Rebekah, L,27984561.480.000.000.00561.48
Green, Kyle,283284.990.000.000.004.99
Madan, Carla, D,28135548.980.000.000.00548.98
Vazquez, Jonathon,1790621.490.000.000.0021.49
Garcia, Stefanie, E,277431155.480.000.000.001155.48
Vance, Henry,27986553.970.000.000.00553.97
Kumar, Jaime, O,290613.990.000.000.003.99
Torres, Alfredo,2768574.980.000.000.0074.98
Sanz, Sabrina, A,1965042.280.000.000.0042.28
Rai, Shaun,2643123.780.000.000.0023.78
Raje, Donna, A,2060723.780.000.000.0023.78
Martinez, Ivan,278722393.060.000.000.002393.06
Liang, Omar,2424517.270.000.000.0017.27
Gill, Lee, L,276941184.460.000.000.001184.46
Alvarez, Arthur,248927.280.000.000.007.28
Garcia, Levi, G,2123239.980.000.000.0039.98
Arthur, Joel,277011155.480.000.000.001155.48
Serrano, Gerald, M,275914.990.000.000.004.99
Subram, Ivan, A,2614778.980.000.000.0078.98
Washington, Sydney,289244.990.000.000.004.99
Munoz, Teresa, R,277121174.480.000.000.001174.48
Ye, Gilbert,29344548.980.000.000.00548.98
Mehta, Pamela,22005135.460.000.000.00135.46
Ruiz, Alfredo,2197585.480.000.000.0085.48
Chow, Shannon,1844425.480.000.000.0025.48
Suri, Toni,184644698.760.003578.270.001120.49
Cook, Sydney, D,131185669.900.000.002049.103620.80
Chandra, Arthur, L,140326859.430.000.002071.424788.01
Moore, Devin, J,16167102.570.000.000.00102.57
Morgan, Melissa, M,2022274.450.000.000.0074.45
Ruiz, Carolyn, M,27863565.470.000.000.00565.47
Xu, Alejandro, R,265851903.480.000.00782.991120.49
Chen, Jon,269201336.960.000.00782.99553.97
Yuan, Sharon,1200855.760.000.000.0055.76
Hu, Edwin,242404.990.000.000.004.99
Suarez, Casey,265481322.980.000.00782.99539.99
Wu, Glenn, R,29343553.970.000.000.00553.97
Martinez, Frederick,119918128.020.003374.990.004753.03
Sanz, Rodney,1692644.950.000.000.0044.95
He, Karen, C,27861539.990.000.000.00539.99
Henderson, Marcus, D,1521268.960.000.000.0068.96
Martin, Hector,27860615.470.000.000.00615.47
Subram, Joe,136316817.120.000.002049.104768.02
Lu, Randy,2644178.980.000.000.0078.98
Jiménez, Briana, T,28118588.960.000.000.00588.96
Navarro, Marc,1634637.550.000.000.0037.55
Randall, Toni,1660566.260.000.0027.2838.98
Kumar, Lacey,139606871.740.000.002071.424800.32
Dominguez, Kristi, M,136446864.460.000.002071.424793.04
Zhao, Bianca,139716772.130.000.002049.104723.03
Serrano, Joy, L,14069173.940.000.000.00173.94
Yuan, Darrell,18271119.950.000.000.00119.95
Lal, Mitchell, C,204037.280.000.000.007.28
Hall, Haley,274891383.450.000.00782.99600.46
Gill, Anne,274691331.970.000.00782.99548.98
Serrano, Reginald, J,130252690.400.000.002071.42618.98
Ramos, Tanya, R,140456804.130.000.002049.104755.03
Suarez, Natasha,1467937.970.000.000.0037.97
Hernandez, Raquel, W,139974586.350.000.002071.422514.93
Schmidt, Joe, M,229054624.910.000.002181.562443.35
Alvarez, Kendra, R,152672853.580.000.002049.10804.48
Moreno, Leslie, C,11114122.890.000.007.95114.94
Serrano, Neil, L,17076103.460.000.000.00103.46
Gutierrez, Jay, C,13155226.950.000.0084.47142.48
Chen, Jake,228454633.900.000.002181.562452.34
Gao, Susan,274711386.480.000.00782.99603.49
Luo, Jerry, M,245864144.340.000.002443.351700.99
Zheng, Jenny, R,119474747.300.003374.99629.96742.35
Diaz, Randall, T,29345574.980.000.000.00574.98
Lin, Alan,229737.280.000.000.007.28
Fernandez, Emmanuel,2895514.980.000.000.0014.98
She, Jessie, A,136506768.140.000.002049.104719.04
King, Mackenzie, M,269161322.980.000.00782.99539.99
Campbell, Haley, L,1730462.270.000.000.0062.27
Pal, Drew,1190263.040.000.006.2856.76
Torres, Ruben,110028114.043399.990.004714.050.00
Mehta, Marco,110078211.003399.990.004811.010.00
Liang, Martha,165254752.753578.270.000.001174.48
Holt, Krystal,165184698.763578.270.000.001120.49
Rai, Clarence, D,110186533.283399.990.002341.97791.32
Johnson, Elizabeth,110048196.013399.990.002376.962419.06
Alvarez, Janet, G,110068119.033399.990.002334.972384.07
Sai, Ann,273391336.960.000.00782.99553.97
Gao, Stacey,166624355.713578.270.00777.440.00
Mehta, Deanna, P,172806089.593578.270.000.002511.32
Sharma, Sharon, T,252941882.57699.100.000.001183.47
Ortega, Jessie, J,170516060.503578.270.000.002482.23
Jai, Bonnie,119778212.500.003399.990.004812.51
Lu, Suzanne, K,167124417.753578.270.000.00839.48
Raji, Donna,2490661.960.000.000.0061.96
Gray, Faith,2291459.980.000.000.0059.98
Andersen, Willie, M,2797064.470.000.000.0064.47
Nelson, Sophia,166644377.753578.270.00799.480.00
Madan, Toni,26668119.980.000.000.00119.98
Chen, Willie, C,2832229.480.000.000.0029.48
Scott, Savannah, E,169294733.753578.270.000.001155.48
Lu, Trisha,255551277.56699.100.000.00578.46
Lopez, Heidi,110528131.323374.990.002337.272419.06
Sanchez, George, M,126806880.100.002049.100.004831.00
Serrano, Derrick,167074377.753578.270.000.00799.48
Sai, Preston, D,170464467.743578.270.000.00889.47
Xu, Edwin, J,252721873.58699.100.000.001174.48
Andersen, Carl, J,110578088.043374.990.002319.992393.06
Serrano, Max, E,120108203.500.003374.990.004828.51
Chapman, Kathryn,119888078.020.003374.990.004703.03
Diaz, Ruben, A,2513639.980.000.000.0039.98
Henderson, Xavier, K,1299396.250.000.000.0096.25
Clark, Sydney,1661067.580.000.0032.6034.98
Moore, Michael,172474432.723578.270.000.00854.45
Zheng, Christy,170694426.743578.270.000.00848.47
Beck, Alicia, L,172484382.753578.270.000.00804.48
Deng, Clayton, G,172856093.203578.270.000.002514.93
Hernandez, Max,1819263.970.000.000.0063.97
Wilson, Jasmine,173296021.623578.270.000.002443.35
Xu, Barbara,291952419.060.000.000.002419.06
Cai, Cedric,195596056.610.003578.270.002478.34
Raje, Colleen, M,190846093.200.003578.270.002514.93
Navarro, Tyrone, K,255571262.870.00699.100.00563.77
Torres, Gina,179044733.750.003578.270.001155.48
Andersen, Kate,1423790.250.000.000.0090.25
Mehta, Nancy,181894118.260.003578.270.00539.99
Subram, Tabitha, C,175114150.530.003578.27572.260.00
Kumar, Wayne,175026070.590.003578.270.002492.32
Yuan, Louis, C,181934145.540.003578.270.00567.27
Chander, Damien,110808204.020.003374.992359.982469.05
Lal, Shawna,179244733.750.003578.270.001155.48
Gill, Alberto, P,177334758.240.003578.270.001179.97
Chande, Cassie,111038182.500.003374.992388.452419.06
Hernandez, Bruce,179194733.750.003578.270.001155.48
Suri, Cesar,175124170.540.003578.27592.270.00
Yang, Connor,177354752.750.003578.270.001174.48
Xu, Lacey, S,179134733.750.003578.270.001155.48
Griffin, Caroline,177264721.730.003578.270.001143.46
Alvarez, Kari, C,111088124.040.003374.992329.992419.06
Romero, Billy,204194.990.000.000.004.99
Gutierrez, Desiree,15216101.740.000.0027.2874.46
Yang, Heather,182756021.620.003578.272443.350.00
Schmidt, Pamela, I,2437531.730.000.000.0031.73
Jiménez, Beth, H,111208242.490.003374.990.004867.50
Nara, Latoya, J,182086035.600.003578.272457.330.00
Gill, Melinda, G,111518087.310.003374.990.004712.32
Suarez, Kristi, D,230992983.340.000.002443.35539.99
Alonso, Brandi,1706186.270.000.000.0086.27
Jackson, Eduardo, C,1174939.970.000.000.0039.97
Rodriguez, Monica, J,289519.990.000.000.009.99
Perez, Kevin, M,255651239.090.00699.100.00539.99
Moreno, Pedro, A,182486037.890.003578.272459.620.00
Suri, Ronald,182146093.200.003578.272514.930.00
Gomez, Derrick,186946035.600.003578.272457.330.00
Wu, Mandy,183096090.590.003578.272512.320.00
Russell, Ashley,120008183.000.003399.990.004783.01
Martin, Naomi, A,15593116.260.000.0088.9827.28
Nath, Tasha, J,184876021.620.003578.272443.350.00
Jimenez, Kathleen,266541346.760.000.001346.760.00
Liang, Colin,13639188.960.000.003.99184.97
Alonso, Lance, I,1405764.970.000.000.0064.97
Zhao, Gilbert,231193945.530.000.002181.561763.97
Zheng, Jeffery, W,150303786.390.000.002071.421714.97
Lal, Sheena,2331213.980.000.000.0013.98
Zhu, Omar,250332120.930.000.001000.441120.49
Townsend, Darren,184675279.260.003578.271700.990.00
Blanco, Erika, L,1466990.250.000.000.0090.25
Sharma, Edwin, K,250211554.410.000.001000.44553.97
Xu, Julie,183016056.610.003578.272478.340.00
Moreno, Randall, F,2120939.990.000.000.0039.99
Zheng, Edwin, J,142165653.920.000.002049.103604.82
Taylor, Jennifer,184706021.620.003578.272443.350.00
Cai, Steve, M,2215569.990.000.000.0069.99
Garcia, Rebekah, M,140073772.410.000.003772.410.00
Zheng, Vincent,184966121.710.003578.272543.440.00
Raman, Dominique, D,1302358.980.000.000.0058.98
Gill, Carolyn,2309467.930.000.000.0067.93
Sun, Jenny, L,122534066.930.003399.990.00666.94
Munoz, Felicia, D,2040659.980.000.000.0059.98
Raji, Grant, R,1618528.980.000.000.0028.98
Lal, Terry,182776070.590.003578.270.002492.32
Shen, Franklin,2714439.990.000.000.0039.99
Cai, Candice,267471938.470.000.00782.991155.48
Jai, Carly,229862756.540.000.002181.56574.98
Kapoor, Troy, E,2461039.980.000.000.0039.98
Ross, Brandon,141323804.080.000.002049.101754.98
Jai, Clayton,123396865.460.002071.420.004794.04
Romero, Raquel, Z,2291658.980.000.000.0058.98
Alexander, Austin,266731505.760.000.001505.760.00
Zhang, Willie, T,16023166.890.000.000.00166.89
Washington, Marcus,283296.280.000.000.006.28
Gonzalez, Shane, Y,141253772.410.000.003772.410.00
Price, Deb,245023623.320.000.002443.351179.97
Raman, Veronica, R,1235995.740.000.000.0095.74
Rana, Meredith,250322184.900.000.001000.441184.46
Alvarez, Gloria, B,182976119.590.003578.272541.320.00
Gill, Jay,2797583.470.000.000.0083.47
Huang, Valerie, J,267451932.460.000.00782.991149.47
Munoz, Alfredo, C,233142744.520.000.002181.56562.96
Lu, Todd, D,2426914.980.000.000.0014.98
Lopez, Donald, A,267401938.470.000.00782.991155.48
Zheng, Claudia,186916070.590.003578.272492.320.00
Bradley, Victoria,29454742.350.000.000.00742.35
Jai, Katrina,1304459.980.000.000.0059.98
Mehta, Brett,114508173.260.003374.992370.222428.05
Lin, Jorge,2759313.980.000.000.0013.98
James, Mariah, M,1910430.970.000.000.0030.97
Martinez, Sarah, S,126706785.130.002049.100.004736.03
Gutierrez, Victor, J,2735769.990.000.000.0069.99
He, Colin, B,143005322.730.000.002071.423251.31
Xie, Ricardo,187106098.580.003578.272520.310.00
Ma, Colin,2642869.990.000.000.0069.99
Nara, Yolanda,29080777.340.000.000.00777.34
Nath, Dawn, L,117598054.050.003374.992294.992384.07
Kapoor, Arthur,2448323.970.000.000.0023.97
Sanchez, Patrick, W,24382143.780.000.000.00143.78
Raman, Levi,291142384.070.000.000.002384.07
Lin, Heather, L,1571863.970.000.000.0063.97
Ramos, Byron,143063653.230.000.002071.421581.81
Alonso, Gary, C,187675314.250.003578.270.001735.98
Li, Warren, R,29185563.770.000.000.00563.77
Cai, Suzanne,250512174.920.000.001000.441174.48
Torres, Mathew, L,189004132.240.003578.27553.970.00
Raji, Lacey, E,1634188.250.000.000.0088.25
Andersen, Colin,250532183.910.000.001000.441183.47

Generated 2025-11-06 18:59:15.469 UTC