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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Gill, Lee, L,276941184.460.000.000.001184.46
Xu, Alejandro, R,265851903.480.000.00782.991120.49
Butler, Jason,175104369.740.003578.270.00791.47
Yuan, Sharon,1200855.760.000.000.0055.76
Sun, Louis, E,1618283.970.000.000.0083.97
Raji, Brendan,131036842.600.000.002049.104793.50
Weber, Deanna, L,148553759.080.000.002049.101709.98
Chande, Katrina, L,199686021.620.003578.270.002443.35
Suarez, Nelson,273551383.450.000.00782.99600.46
Ye, Amy,11073191.900.000.000.00191.90
Blanco, Orlando,225753018.330.000.002443.35574.98
Srini, Carolyn, S,273711350.750.000.00782.99567.76
Hu, Edwin,242404.990.000.000.004.99
Liu, Kelli, A,244804175.610.000.002443.351732.26
Turner, Rebecca, W,276991155.480.000.000.001155.48
Fernandez, Brenda, L,164934197.253578.270.000.00618.98
Sanz, Rodney,1692644.950.000.000.0044.95
Arthur, Joel,277011155.480.000.000.001155.48
She, Mindy, J,13009168.670.000.000.00168.67
Gomez, Randall, R,117628228.010.003399.992389.962438.06
Zheng, Jaclyn, F,119108113.030.003374.992319.992418.05
She, Melvin,165164733.753578.270.001155.480.00
Raje, Karla,289367.280.000.007.280.00
Alvarez, Adrienne, L,17067113.960.000.000.00113.96
Henderson, Marcus, D,1521268.960.000.000.0068.96
Martin, Hector,27860615.470.000.000.00615.47
Alonso, Joanna, M,27862548.980.000.000.00548.98
Subram, Joe,136316817.120.000.002049.104768.02
Washington, Sydney,289244.990.000.000.004.99
Rubio, Daisy, A,16181170.060.000.000.00170.06
Cai, Alvin, D,1111535.230.000.0027.287.95
Saunders, Brandy,119464697.310.003399.99554.97742.35
Rana, Evelyn, D,18262142.450.000.000.00142.45
Diaz, Tyrone,13116230.250.000.0032.27197.98
Ramos, Lance, S,289492473.050.000.002473.050.00
Johnson, Sydney,1957190.950.000.0033.9856.97
Goldberg, Mindy,161594411.650.000.002071.422340.23
Kumar, Lacey,139606871.740.000.002071.424800.32
Dominguez, Kristi, M,136446864.460.000.002071.424793.04
Alonso, Kristine,166864157.733578.270.000.00579.46
Zhao, Bianca,139716772.130.000.002049.104723.03
Serrano, Joy, L,14069173.940.000.000.00173.94
Hall, Haley,274891383.450.000.00782.99600.46
Gill, Anne,274691331.970.000.00782.99548.98
Liang, Eugene,1397277.270.000.000.0077.27
Nara, Edwin, R,110978099.030.003374.992304.982419.06
Zheng, Alan,110505007.303374.990.00854.97777.34
Ramos, Rodney, C,14059106.750.000.0074.4832.27
Gomez, Ricky,187376021.620.003578.272443.350.00
Sanders, Gabriella,119068151.000.003374.992391.942384.07
Suarez, Natasha,1467937.970.000.000.0037.97
Tang, Dawn, R,164965960.233578.270.000.002381.96
Raji, Christy,1558462.270.000.000.0062.27
Serrano, Neil, L,17076103.460.000.000.00103.46
Hernandez, Ross,1467781.260.000.000.0081.26
Weber, Levi, A,13120205.390.000.0049.48155.91
Zhu, Jenny, J,17078186.940.000.00186.940.00
Zeng, Heather, E,1828772.160.000.0072.160.00
Yuan, Jaclyn,249042199.900.000.001000.441199.46
Moore, Lucas, J,1502138.980.000.000.0038.98
Zhao, Laura, T,2458968.970.000.000.0068.97
Malhotra, Brett, E,187316054.060.003578.270.002475.79
Liu, Susan,187186035.600.003578.270.002457.33
Lal, Bradley,131562663.690.000.002071.42592.27
Chander, Tonya,15794113.970.000.000.00113.97
Raman, Brett, L,229304900.680.000.002443.352457.33
Sanchez, Nancy, L,222074921.690.000.002443.352478.34
Jai, Lacey, C,1137174.980.000.000.0074.98
Lin, Alan,229737.280.000.000.007.28
King, Mackenzie, M,269161322.980.000.00782.99539.99
Mehta, Erick, E,1412361.580.000.000.0061.58
Zheng, Claudia,186916070.590.003578.270.002492.32
Goel, Alicia, H,204234177.740.003578.270.00599.47
Hernandez, Joe,1515484.980.000.000.0084.98
Rivera, Evan, Y,267571344.470.000.00782.99561.48
Gonzales, Victoria,117518215.020.003399.990.004815.03
Chander, Dustin,118958149.040.003374.990.004774.05
Liu, Ronnie,2613021.490.000.000.0021.49
Moreno, Kristi,234153588.830.000.002443.351145.48
Goel, Alisha, C,267671331.970.000.00782.99548.98
Kumar, Barbara, N,274991331.970.000.00782.99548.98
Li, Colin, J,1844521.490.000.000.0021.49
Diaz, Devin, D,15829187.980.000.000.00187.98
Martin, Jay,1959733.980.000.000.0033.98
Chander, Edwin, T,173704742.740.003578.270.001164.47
Sun, Todd,2201876.970.000.000.0076.97
Sanz, Jimmy,25810114.460.000.000.00114.46
Suarez, Alfredo,196015314.250.003578.270.001735.98
Nelson, Natalie, C,2292858.980.000.000.0058.98
Fernandez, Geoffrey,199636054.220.003578.270.002475.95
Rodriguez, Pamela,29065777.340.000.000.00777.34
Mr., Spencer, Phil,199606120.110.003578.270.002541.84
Gao, Todd, M,110618129.023374.990.002369.962384.07
Ye, Ramon,113574943.800.003374.990.001568.81
Subram, Rebekah,2603021.490.000.000.0021.49
Lin, Karen,2424348.970.000.000.0048.97
Carlson, Jose,1995474.450.000.0060.4713.98
Sanders, Kaylee, C,202216035.600.003578.270.002457.33
Alonso, Raquel,1731351.920.000.000.0051.92
Jiménez, Darren, W,28931166.280.000.000.00166.28
Lin, Mandy, C,250352183.910.000.001000.441183.47
Gill, Billy, L,1670092.970.000.000.0092.97
Becker, Latoya, W,1733030.970.000.000.0030.97
Patel, Cynthia, M,15222123.450.000.000.00123.45
Bailey, Melissa, C,1957282.250.000.000.0082.25
Gutierrez, Jonathon, R,165294752.753578.270.000.001174.48
Lopez, Deanna, L,251192148.210.000.001000.441147.77
Stewart, Bryan, M,169284698.763578.270.000.001120.49
Deng, Tasha,114598141.330.003399.992322.282419.06
Powell, Aaron,252414.990.000.000.004.99
Jimenez, Jimmy,273651371.950.000.00782.99588.96
Tang, Wayne, S,130906812.420.000.002049.104763.32
Ma, Darryl, R,1559981.240.000.000.0081.24
Zhu, Jessie, D,1266634.560.000.000.0034.56
Diaz, Aaron, C,186956029.570.003578.270.002451.30
Rai, Brad, S,184906029.570.003578.270.002451.30
Holt, Krystal,165184698.763578.270.000.001120.49
Chavez, Corey, R,1573159.980.000.000.0059.98
Kumar, Cristina, N,15426115.920.000.000.00115.92
Jimenez, Erik, H,2198935.000.000.000.0035.00
Kapoor, Denise, M,187256044.590.003578.270.002466.32
Ms., Salavaria, Sharon,119648173.530.003399.990.004773.54
Xu, Cara,235263563.840.000.002443.351120.49
Hernandez, Tabitha, L,1960325.480.000.000.0025.48
Hu, Barbara,19567104.960.000.000.00104.96
Blanco, Lori, A,15735116.250.000.000.00116.25
She, Ashlee,28319556.930.000.000.00556.93
Chander, Bethany, K,114468237.010.003399.992354.982482.04
Navarro, Meredith,277034.990.000.000.004.99
Zhu, Damien, M,1582243.210.000.000.0043.21
Ma, Omar, I,1523239.970.000.000.0039.97
Cai, Jessie, A,12249114.960.000.000.00114.96
Chen, Cedric, R,170654417.753578.270.000.00839.48
Zhang, Cara,12351117.970.000.000.00117.97
Watson, Anna,202386021.620.003578.270.002443.35
He, Amy,224112770.520.000.002181.56588.96
Kapoor, Ruben, D,111098245.010.003374.992476.962393.06
Lee, Austin,2615169.990.000.000.0069.99
Xie, Michele, M,1503978.960.000.000.0078.96
Guo, Alisha, P,235713563.840.000.002443.351120.49
Chander, Gregory, J,2200174.980.000.000.0074.98
Serrano, Jacquelyn,2196339.990.000.000.0039.99
Perez, Dominique,1234468.700.000.0032.2736.43
Kumar, Ricardo, K,141333764.070.000.002049.101714.97
Barnes, Mariah, H,196216021.620.003578.270.002443.35
Shan, Derek, R,197826089.590.003578.270.002511.32
Taylor, Christopher, E,2117137.290.000.000.0037.29
Ashe, Misty, R,231294.990.000.000.004.99
Simmons, Jacqueline, W,13137177.940.000.000.00177.94
Andersen, Brendan,151215202.730.000.002071.423131.31
Carlson, Mathew, A,230124.990.000.000.004.99
Li, Aimee,179154792.730.003578.270.001214.46
Allen, Luis, C,260191957.470.00782.990.001174.48
Nara, Dale, L,212264659.800.002181.560.002478.24
Munoz, Felicia, D,2040659.980.000.000.0059.98
Nara, Tonya, C,17251123.960.000.0069.9753.99
Zhu, Ernest,201594167.230.003578.27588.960.00
Reed, Riley, A,201574118.260.003578.27539.990.00
Mr., Rovira Diez, Pablo,2119042.280.000.0042.280.00
Lal, Franklin, A,141013679.900.000.002888.58791.32
Ruiz, Melody,13621167.400.000.000.00167.40
Alexander, Alyssa, M,1728237.270.000.000.0037.27
Gill, Orlando,2136093.970.000.000.0093.97
Yuan, Colin,1175858.050.000.000.0058.05
Perez, Bryant, L,150423807.400.000.002071.421735.98
Thomas, Sydney,143225111.440.000.002049.103062.34
Martin, Tabitha,2526923.780.000.000.0023.78
Prasad, Cory,197484.990.000.000.004.99
Hernandez, Ebony, S,235743337.040.000.002181.561155.48
Diaz, Carolyn, C,243603626.820.000.002443.351183.47
Vance, Phillip,293082438.060.000.000.002438.06
Mehta, Denise,130806844.410.000.002049.104795.31
Patel, Stanley, L,249152145.920.000.001000.441145.48
Zeng, Alisha, A,15727134.460.000.000.00134.46
Garcia, Frederick, J,16489112.730.000.0088.4624.27
Huang, Micah,251307.280.000.000.007.28
Ramos, Victor, D,242469.990.000.000.009.99
Sanz, Nelson, M,1405649.480.000.000.0049.48
Coleman, Brittany,1557934.980.000.0034.980.00
Patel, Jillian,266671390.950.000.001390.950.00
Gutierrez, Desiree,15216101.740.000.0027.2874.46
Sanchez, Marie,2292490.950.000.0090.950.00
Evans, Adam, H,2582048.970.000.0048.970.00
Martin, Felicia, L,15018112.460.000.00112.460.00
Goel, April, C,16166108.850.000.0069.9738.88
Lin, Darryl, J,1503141.270.000.0032.288.99
Guo, Krystal, S,17381188.930.000.00188.930.00
Ross, Brandon,141323804.080.000.002049.101754.98
Williams, Wyatt, E,196146217.210.003578.270.002638.94
Lal, Kelsey, T,249132155.920.000.001000.441155.48
Luo, Julie, M,2912169.970.000.000.0069.97
Goel, Ricardo, T,259611938.470.00782.990.001155.48
Alvarez, Tyrone, K,27693539.990.000.000.00539.99
Beck, April,143025140.730.000.002071.423069.31
Dominguez, Wendy,110356451.313374.990.000.003076.32
Raman, Veronica, R,1235995.740.000.000.0095.74
Simpson, Sharon, L,2512339.980.000.000.0039.98
Subram, Cory, B,27599603.490.000.000.00603.49
Kovár, Whitney,131055585.450.000.002049.103536.35
Coleman, Luis, L,142305661.900.000.002049.103612.80
Wu, Aimee,16690165.070.000.000.00165.07
Tang, Christy, R,236603917.540.000.002181.561735.98
Raman, Geoffrey, P,154353801.390.000.002071.421729.97
Suarez, Erika,151205217.700.000.002049.103168.60
Prasad, Clifford,1560466.750.000.000.0066.75
Vazquez, Rodney, M,13047241.930.000.000.00241.93
Raman, Deanna, H,17053123.960.000.000.00123.96
Raman, Virginia,2615969.990.000.000.0069.99
Liu, Karen, F,1400863.970.000.0034.9928.98
Lu, Rosa, A,166634471.743578.270.00893.470.00
Alexander, Gabriel, C,14073156.840.000.0038.88117.96
Shen, Roger, G,140113831.890.000.003831.890.00
Gonzalez, Shane, Y,141253772.410.000.003772.410.00
Lopez, Carla, G,283262442.540.000.002442.540.00
Zhou, Arturo, F,27910574.980.000.00574.980.00
Luo, Raul, Q,201544153.250.003578.27574.980.00
Rubio, Robyn, A,184696021.620.003578.272443.350.00
Jai, Ethan,1521741.260.000.0031.279.99
Prasad, Denise,1829478.260.000.000.0078.26
Mr., Solanki, Ajay,18295144.270.000.000.00144.27
Xu, Tara,195925377.230.003578.270.001798.96
Jimenez, Joy,28312574.980.000.000.00574.98
Liu, Christy,197846021.620.003578.270.002443.35
Yuan, Deborah,120214043.460.003399.990.00643.47
Lal, Darrell,1995325.480.000.000.0025.48
Lin, Rafael,14099200.260.000.0027.28172.98
Bradley, Victoria,29454742.350.000.000.00742.35
Moreno, Danny, M,29458811.320.000.000.00811.32
Zhao, Jamie,1617972.160.000.000.0072.16
Zeng, Jon, O,143105200.660.000.002071.423129.24
Ma, Colin,2642869.990.000.000.0069.99
Li, Trisha, A,182966117.690.003578.272539.420.00
Raje, Lindsey,246142120.930.001000.441120.490.00
Arthur, Kristi, W,166754385.033578.270.00806.760.00
Shan, Sheena, J,2156548.980.000.0048.980.00
Jai, Jaime, M,248944.990.000.004.990.00
Jai, Brad, C,1826764.980.000.0034.9929.99
Lin, Claudia, A,14312191.270.000.00166.2824.99
Suri, Holly, M,18286141.550.000.0069.9771.58
Flores, Miranda,1724383.980.000.0053.9929.99
Gonzalez, Roy, M,1304059.980.000.000.0059.98
Alonso, Billy, M,2285239.990.000.000.0039.99
Gill, Joanna,2618638.980.000.000.0038.98
Rubio, Natasha, K,13627214.250.000.0066.97147.28
Suri, Pedro,264221980.960.000.00782.991197.97
Suri, Whitney, J,219744925.170.000.002443.352481.82
Cai, Jorge,220313896.530.000.002181.561714.97
Xu, Willie, C,131606839.460.000.002071.424768.04
Lal, Alisha, C,2187234.980.000.000.0034.98
Xie, Lindsey, M,251324.990.000.000.004.99

Generated 2024-11-10 11:31:47.583 UTC