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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Kumar, Lacey,139606871.740.000.002071.424800.32
Dominguez, Darren, M,139666842.120.000.002049.104793.02
Allen, Kaylee,266531938.470.000.00782.991155.48
Madan, Johnathan, D,136266909.090.000.002049.104859.99
Liang, Darryl,266581390.950.000.001390.950.00
Munoz, Meredith,139575645.240.000.002071.423573.82
Ortega, Max,234133617.830.000.003617.830.00
Sai, Lydia, L,139685181.700.000.002862.742318.96
Xu, Arturo,136196808.100.000.002049.104759.00
Suarez, Rebekah,136496812.130.000.002049.104763.03
Li, Wesley,233223042.820.000.002443.35599.47
Gray, Jeremiah,233314144.340.000.002443.351700.99
Sara, Barry, R,139656872.390.000.002071.424800.97
Vazquez, Jerome,231163936.540.000.002181.561754.98
Zhao, Gilbert,231193945.530.000.002181.561763.97
Hernandez, Gina,140495290.680.000.002071.423219.26
Martinez, Monica, A,141293750.090.000.002049.101700.99
Fernandez, Cassandra, C,141343835.070.000.002049.101785.97
Liu, Lacey, L,235453882.550.000.002181.561700.99
Patel, Jillian,266671390.950.000.001390.950.00
Blanco, Monique, W,141033612.220.000.002855.89756.33
Powell, Adam,234233936.540.000.002181.561754.98
Martin, Anne, V,250342164.910.000.001000.441164.47
Sun, Rafael,267491322.980.000.001322.980.00
Sharma, Edwin, K,250211554.410.000.001000.44553.97
Yang, Ronnie,235243598.830.000.003598.830.00
Jiménez, Bruce, L,236403936.540.000.002181.561754.98
Adams, Amber,267462001.450.000.00782.991218.46
Rivera, Nathaniel, M,140515606.910.000.003286.922319.99
Zheng, Curtis, S,236454198.330.000.002443.351754.98
Munoz, Tanya,234363950.520.000.002181.561768.96
Garcia, Rebekah, M,140073772.410.000.003772.410.00
Moore, Thomas,140103861.390.000.003861.390.00
Tang, Jenny, E,142105621.240.000.002071.423549.82
Cai, Candice,267471938.470.000.00782.991155.48
Ross, Brandon,141323804.080.000.002049.101754.98
Clark, Madison, A,140625647.920.000.003272.942374.98
Rana, Meredith,250322184.900.000.001000.441184.46
Jimenez, Melody, S,140663612.190.000.002853.57758.62
Alonso, Casey, E,234223911.530.000.002181.561729.97
Lopez, Rachael,234253951.520.000.002181.561769.96
Lopez, Donald, A,267401938.470.000.00782.991155.48
Chandra, Veronica,146815178.400.000.002049.103129.30
Romero, Gina,142345687.720.000.002071.423616.30
Thomas, Sydney,143225111.440.000.002049.103062.34
Raji, Terry,155974391.410.000.002071.422319.99
Rai, Colleen,2893329.480.000.000.0029.48
Chen, Alisha, J,142255603.920.000.002049.103554.82
Vazquez, Ruben, B,143015142.750.000.002071.423071.33
Raman, Arthur,240012983.340.000.002443.35539.99
Alvarez, Marvin,236513917.540.000.002181.561735.98
Barnes, Taylor,142795137.710.000.002049.103088.61
She, Tamara, M,142245621.220.000.002049.103572.12
Shen, Grant, B,267631957.470.000.00782.991174.48
Goel, Alisha, C,267671331.970.000.001331.970.00
Butler, Katherine, F,267601322.980.000.001322.980.00
Yang, Randy, E,240002983.340.000.002443.35539.99
Munoz, Monique,240082730.540.000.002181.56548.98
Sanchez, Cynthia, S,236623917.540.000.002181.561735.98
Rai, Terrence, R,250372174.920.000.001000.441174.48
He, Colin, B,143005322.730.000.002071.423251.31
Lal, Karl, R,142645217.730.000.002822.762394.97
Huang, Randy,240073042.820.000.002443.35599.47
Flores, Antonio, D,142593630.930.000.002888.58742.35
Zimmerman, Candice, J,267541938.470.000.00782.991155.48
Shen, Karl, M,151514344.090.000.002049.102294.99
Suri, Jillian, L,151804466.390.000.002071.422394.97
Rowe, Jacquelyn, I,13615146.910.000.007.95138.96
Peterson, Allison, A,2642160.470.000.000.0060.47
Pal, Clayton,27721166.280.000.000.00166.28
Washington, Abigail,236613961.030.000.002181.561779.47
Alvarez, Larry, T,142355682.200.000.002071.423610.78
Harris, Thomas,240022744.520.000.002181.56562.96
Hernandez, Kristine,142865234.400.000.002049.103185.30
Diaz, Josue,152074446.400.000.002071.422374.98
Weber, Cynthia,269211336.960.000.00782.99553.97
Saunders, Bobby, D,22205120.480.000.000.00120.48
Sharma, Christian,1580962.590.000.0032.6029.99
Suarez, Erika,151205217.700.000.002049.103168.60
Hernandez, Jaime,241703018.330.000.002443.35574.98
Chander, Drew, J,251112145.920.000.001000.441145.48
Black, Shawna, C,152054433.690.000.002071.422362.27
Wang, Martha, D,242722735.530.000.002181.56553.97
Raje, Grant, S,241623004.830.000.002443.35561.48
Luo, Lacey,241752743.040.000.002181.56561.48
Hu, Marshall, H,267971957.470.000.00782.991174.48
Martinez, Lydia,241692735.530.000.002181.56553.97
Xu, Jaclyn,242522744.520.000.002181.56562.96
Chander, Keith, A,241742983.340.000.002443.35539.99
Hernandez, Mathew, A,151844441.380.000.002071.422369.96
Tang, Drew, W,151784445.060.000.002049.102395.96
Lopez, George,150403807.400.000.002071.421735.98
Romero, Frank, M,152092916.560.000.002049.10867.46
Alvarez, Tabitha,150283826.400.000.002071.421754.98
Liang, Margaret,17254147.480.000.0093.4953.99
Huang, Jake,1958995.260.000.000.0095.26
Gao, Rafael, R,1873324.270.000.002.2921.98
Gao, Gilbert,241653046.840.000.002443.35603.49
Shan, Elijah, L,267951992.460.000.00782.991209.47
Shan, Colleen, D,151504379.080.000.002049.102329.98
Shan, Shaun,242743018.330.000.002443.35574.98
Evans, Mason,154393804.080.000.002049.101754.98
Alvarez, Kristy,155884486.070.000.002049.102436.97
Kapoor, Cesar, J,243023882.550.000.002181.561700.99
Martin, Ebony, F,152234366.410.000.002071.422294.99
Navarro, Leslie, E,243714193.820.000.002443.351750.47
Gutierrez, Kristine, G,251332155.920.000.001000.441155.48
Barnes, Faith, F,157264393.360.000.002049.102344.26
Chen, Clayton, A,152194399.080.000.002049.102349.98
Malhotra, Harold,152274469.560.000.002049.102420.46
Zhou, Clayton,273481382.460.000.00782.99599.47
Gonzalez, Jan, A,152623772.410.000.002071.421700.99
Patel, Deanna, H,273541322.980.000.00782.99539.99
Gill, Diane,155784509.900.000.002071.422438.48
Sun, Christy,252182184.900.000.001000.441184.46
Kelly, Emma, A,156463804.080.000.002049.101754.98
Carlson, Francis,273401350.750.000.00782.99567.76
Zhu, Erica,252212143.900.000.001000.441143.46
Sai, Ruth, D,244613302.050.000.002181.561120.49
Jimenez, Teresa, L,243723356.040.000.002181.561174.48
Chow, Warren, L,243053945.530.000.002181.561763.97
Moreno, Naomi, C,156014429.570.000.002049.102380.47
Liu, Micah, J,152204384.080.000.002049.102334.98
Sara, Tina,243074158.320.000.002443.351714.97
Chander, Roger,252142149.910.000.001000.441149.47
Jiménez, Brandi,243784173.320.000.002443.351729.97
Torres, Michele, A,161764404.080.000.002049.102354.98
Ruiz, Danny,2445621.490.000.000.0021.49
Liang, Dennis,14034104.240.000.000.00104.24
Smith, Allen,1407274.980.000.000.0074.98
Ma, Christy,1502040.260.000.000.0040.26
Munoz, Diane, R,15795132.440.000.000.00132.44
Raje, Casey, A,14686203.460.000.000.00203.46
Martin, Alyssa,1958721.490.000.000.0021.49
Jiménez, Orlando, M,21283124.940.000.000.00124.94
Chander, Alejandro, M,2445575.470.000.000.0075.47
Cox, Isaac,157974415.680.000.002071.422344.26
Ye, Damien, M,136206848.070.000.002049.104798.97
Arun, Brenda,136306824.730.000.002071.424753.31
Hughes, Lucas, E,266571357.970.000.001357.970.00
Romero, Lawrence, C,166876070.593578.270.002492.320.00
Rai, Clarence, D,110186533.283399.990.002341.97791.32
Yang, Jon, V,110008248.993399.990.002341.972507.03
Martinez, Tyler, T,282012419.060.000.002419.060.00
Torres, Carolyn,1526170.740.000.000.0070.74
Kapoor, Summer,28353548.980.000.000.00548.98
Adams, Isabella,1571539.970.000.000.0039.97
Romero, Kathleen,1401924.990.000.000.0024.99
Cai, Vincent, L,1175758.050.000.0024.4933.56
Blue, Richard,12006144.740.000.000.00144.74
Chander, Lindsay, R,1997249.700.000.000.0049.70
Sanz, Diane, M,2015313.980.000.000.0013.98
Hall, Amanda,266561345.950.000.001345.950.00
Mehta, Marco,110078211.003399.990.004811.010.00
Johnson, Elizabeth,110048196.013399.990.002376.962419.06
Chen, Steve, R,189024186.230.003578.27607.960.00
Ruiz, Julio,110058121.333374.990.002362.272384.07
Navarro, Kathleen, J,192694118.260.003578.27539.990.00
Munoz, Shannon, S,2912249.970.000.000.0049.97
Hernandez, Alberto, D,250292272.200.000.001000.441271.76
Sanchez, Bryant, C,131136832.410.000.002071.424760.99
Suri, Lydia,131266815.080.000.002049.104765.98
Anand, Andrés,110968063.040.003374.992294.992393.06
Natsuhara, Tony,230972770.520.000.002181.56588.96
Griffin, Rachel,182556067.200.003578.270.002488.93
Li, Jack, J,140715617.920.000.002049.103568.82
Yang, Stacey,142155665.890.000.002049.103616.79
Mehta, Brett,114508173.260.003374.992370.222428.05
Andersen, Carl, J,110578088.043374.990.002319.992393.06
Sanz, Arthur,27688166.280.000.00166.280.00
Zhang, Barbara,16338169.430.000.0058.47110.96
Butler, Austin, W,1829374.240.000.0074.240.00
Sanz, Mathew, L,1455763.970.000.0063.970.00
Wright, Miguel,2581186.450.000.0086.450.00
Black, Priscilla,1576662.270.000.0034.9927.28
Ortega, Lawrence,14685146.740.000.000.00146.74
Deng, Colin, B,1829932.220.000.000.0032.22
Mehta, Ann, M,14518126.950.000.0063.9762.98
Arun, Nancy, C,211694647.880.002181.560.002466.32
Moore, Michael,172474432.723578.270.000.00854.45
Butler, Elijah, D,2155129.990.000.000.0029.99
Bailey, Savannah, J,2342839.980.000.000.0039.98
Carlson, Theresa, L,19629109.440.000.000.00109.44
Kumar, Warren, A,240032806.530.000.002181.56624.97
Ma, Jorge, O,1405286.260.000.0027.2858.98
Johnson, Emma, M,1513662.270.000.0034.9927.28
Sharma, Julie, R,1819194.470.000.008.9985.48
Taylor, Jennifer,184706021.620.003578.272443.350.00
Ward, Shelby,2613239.980.000.0039.980.00
Navarro, Dana, J,1112579.690.000.0047.4232.27
Deng, Kurt, D,13635215.740.000.0032.27183.47
Andersen, Kelvin, C,2136639.980.000.0039.980.00
Rai, Tonya,252432155.920.000.001000.441155.48
Carlson, Jonathon, N,1707378.970.000.000.0078.97
Rai, Christy,1668369.870.000.000.0069.87
Zhou, Krystal,235933990.010.000.002181.561808.45
Zheng, Edwin, J,142165653.920.000.002049.103604.82
Anand, Johnny,140585652.520.000.003355.242297.28
Zheng, Jaclyn, F,119108113.030.003374.992319.992418.05
Jai, Clayton,123396865.460.002071.420.004794.04
Srini, Douglas, M,1673335.260.000.000.0035.26
Suri, Barry,1525378.960.000.000.0078.96
Chandra, Arthur, L,140326859.430.000.002071.424788.01
Kapoor, Patricia, R,2188342.280.000.0042.280.00
Parker, Mason, W,259236.280.000.006.280.00
James, Evan, V,1111985.220.000.0035.2349.99
Sun, Clayton,285334.990.000.004.990.00
Zhao, Ernest, C,187005328.230.003578.271749.960.00
Bradley, Diane, A,1514062.270.000.0027.2834.99
Ms., Simon, Britta,259461873.580.00699.100.001174.48
Xu, Edwin, J,252721873.58699.100.000.001174.48
Madan, Geoffrey, M,1524151.910.000.000.0051.91
Ortega, Joanna,179094761.740.003578.270.001183.47
Anand, Kara,119898139.530.003374.990.004764.54
Suarez, Joy, B,1266574.540.000.000.0074.54
Dominguez, Kristine, A,140206831.760.000.002071.424760.34
Munoz, Latasha,119678153.020.003374.992358.972419.06
Chander, Russell, E,29067539.990.000.000.00539.99
Zeng, Ernest, M,12992158.510.000.0036.27122.24
Martin, Ethan, M,13998245.250.000.0097.97147.28
Huang, Jorge,1729186.270.000.0053.9932.28
Vazquez, Neil, K,287192384.070.000.002384.070.00
Suarez, Daisy, A,182886093.200.003578.272514.930.00
She, Rafael, I,201524142.750.003578.27564.480.00
Zhang, Willie, T,16023166.890.000.000.00166.89
Alvarez, Marc, B,1822145.950.000.000.0045.95
Perez, Toni,15581113.940.000.000.00113.94
Perez, Patricia,250221564.920.000.001000.44564.48
Jones, Ethan,130516831.740.000.002071.424760.32
Henderson, Paige, C,1732554.940.000.000.0054.94
Black, Peter, E,2121364.260.000.000.0064.26
Lu, Crystal, A,151454368.700.000.002071.422297.28
Xie, Wayne, S,183026029.570.003578.272451.300.00
Van, Brenda, J,2489039.980.000.0039.980.00
Prasad, Gerald, B,1203581.240.000.0064.9716.27
Martin, Ricky, C,16608101.570.000.0071.5829.99
Garcia, Harold, K,14087341.970.000.00159.00182.97
Lal, Franklin, A,141013679.900.000.002888.58791.32
Wood, Jacqueline,1670597.960.000.000.0097.96
Zhou, Jaclyn, C,211794935.670.002443.350.002492.32
Romero, Meredith, J,29452742.350.000.000.00742.35
Lal, Cristina, M,146712934.370.000.002071.42862.95
Shan, Tony, M,1617531.270.000.000.0031.27
Blanco, Sheila, I,1772436.960.000.000.0036.96
Davis, Nicole,2295739.980.000.000.0039.98
Diaz, Felicia, J,1502629.980.000.000.0029.98
Martin, Joe,146685216.690.000.002071.423145.27
Richardson, Abigail, S,142365710.230.000.002071.423638.81
Xu, Tonya,1732480.940.000.000.0080.94
Shan, Darrell, J,2734569.990.000.000.0069.99

Generated 2025-11-03 11:37:18.602 UTC