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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Jimenez, Jill,110286474.623374.990.000.003099.63
Diaz, Dana, C,12361217.460.000.000.00217.46
Stone, Mitchell,2501369.970.000.000.0069.97
Ramos, Craig,14209193.970.000.004.99188.98
Xu, Terry,2422815.230.000.000.0015.23
Gutierrez, Joy, A,1846653.990.000.000.0053.99
Carlson, Briana,264361957.470.00782.990.001174.48
Patel, Summer, G,267531957.470.000.00782.991174.48
Liang, Glenn,219834144.340.002443.350.001700.99
Malhotra, Veronica, J,259221274.080.00699.100.00574.98
Bryant, Fernando, M,206096117.690.003578.270.002539.42
Hu, Leah,119948169.030.003374.992374.982419.06
Zeng, Marshall, M,209874132.240.003578.27553.970.00
Suri, Troy, M,122513924.970.003374.990.00549.98
Alonso, Meredith, M,206216117.690.003578.270.002539.42
Rubio, Sabrina, A,209844153.250.003578.27574.980.00
Morcos, Hany,208214118.260.003578.27539.990.00
Perez, Ronald,259441274.080.00699.100.00574.98
Garcia, Ruth,206236093.200.003578.270.002514.93
Garcia, Ruben,196136093.200.003578.270.002514.93
Kumar, Tony, P,197836021.620.003578.270.002443.35
Tang, Sharon, M,1582367.960.000.000.0067.96
Perez, Marie,1399666.260.000.000.0066.26
Garcia, Andre, H,127056854.110.002049.100.004805.01
Rana, Henry,273421348.460.000.00782.99565.47
Hernandez, Victor, T,2353759.980.000.000.0059.98
Huang, Lacey, J,1195163.520.000.000.0063.52
Srini, Candace,154372.290.000.000.002.29
Sara, Ross,243674179.330.000.002443.351735.98
Munoz, Ebony,131065697.520.000.002071.423626.10
Anderson, Victoria,157994423.380.000.002071.422351.96
Torres, Carolyn,1526170.740.000.0053.4717.27
Alonso, Teresa,1313883.970.000.0058.9824.99
Fernandez, Nancy,1485472.960.000.000.0072.96
Moreno, Kathleen, C,1523459.980.000.0034.9924.99
Cai, Vincent, L,1175758.050.000.0024.4933.56
Blue, Richard,12006144.740.000.0092.9751.77
Zhou, Colleen,2312213.980.000.000.0013.98
Moreno, Dwayne, T,2310385.480.000.000.0085.48
Raje, Raul, L,2678574.980.000.000.0074.98
Ortega, Renee,1844721.490.000.000.0021.49
Rodriguez, Francisco,243613391.030.000.002181.561209.47
Gutierrez, Gary, C,127016868.440.002071.420.004797.02
Goel, Barbara,129886915.440.002049.100.004866.34
Li, Justin,1412457.590.000.0032.6024.99
Srini, Beth, A,259136.280.000.000.006.28
Luo, Bethany,1958236.270.000.000.0036.27
Patel, Douglas,179274726.043578.270.000.001147.77
Rivera, Jada,2197032.280.000.000.0032.28
Ruiz, Alberto, L,2521227.770.000.000.0027.77
Guo, Tiffany,259271272.520.00699.100.00573.42
Serrano, Max, E,120108203.500.003374.992384.962443.55
Stone, Christine, D,259481819.590.00699.100.001120.49
Rubio, Kristy,122433914.980.003374.990.00539.99
Nath, Ricardo, C,120398213.000.003374.992394.462443.55
Martinez, Troy, L,208234216.750.003578.27638.480.00
Munoz, Casey, W,125702654.060.002049.100.00604.96
Kumar, Katie, P,123416840.620.002049.102294.992496.53
Gao, Wesley,123466864.460.002071.422354.982438.06
Raman, Ruth, L,211994144.340.002443.350.001700.99
Blanco, Larry, E,212164935.670.002443.350.002492.32
Young, Morgan, L,123426838.120.002049.102369.962419.06
Pal, Sheena, D,211973917.540.002181.560.001735.98
Xu, Rafael, N,211954144.340.002443.350.001700.99
He, Louis, E,212114900.680.002443.350.002457.33
Nara, Katrina, Z,246082120.930.001000.441120.490.00
Ruiz, Gloria,123435567.930.002049.101223.842294.99
Sai, Regina,211924229.320.002443.350.001785.97
Flores, Katherine,211803882.550.002181.560.001700.99
She, Corey, T,212144659.900.002181.560.002478.34
Nath, Cassie,246062155.920.001000.441155.480.00
Gill, Ricky, A,1560728.980.000.000.0028.98
Lu, Warren, H,289257.280.000.000.007.28
Ma, Brittney,125842633.390.002071.420.00561.97
Shen, Dustin,27974553.970.000.000.00553.97
Morgan, Natalie,1514963.970.000.000.0063.97
Blanco, Wendy, J,19604171.730.000.00147.9523.78
Martinez, Edgar, B,1874160.470.000.000.0060.47
Sara, Ebony,249232159.400.000.001000.441158.96
Hu, Alejandro,13125138.540.000.000.00138.54
Chande, Alvin, W,2489323.780.000.000.0023.78
Raman, Pamela, C,2736978.980.000.000.0078.98
Gutierrez, Natasha,170484382.753578.270.000.00804.48
She, Willie,170554347.763578.270.000.00769.49
Van, Cassandra,135254607.230.000.002071.422535.81
Moreno, Kristine, K,28481778.620.000.000.00778.62
Cai, Warren,249182120.930.000.001000.441120.49
Sara, Ann, A,2357639.980.000.000.0039.98
Huang, Colleen, S,213792992.330.002443.350.00548.98
Shan, Yolanda,127026911.100.002049.100.004862.00
Chow, Christy, M,126816784.130.002049.100.004735.03
Kumar, Yolanda, J,1819485.960.000.000.0085.96
Sun, Louis, E,1618283.970.000.000.0083.97
Hernandez, Wendy, A,15124122.440.000.000.00122.44
Martin, Ruben,224002737.820.002181.560.00556.26
Chander, Alisha,125722611.410.002071.420.00539.99
Diaz, Stacy, L,123406752.130.002049.102318.962384.07
Vance, Denise, L,212054886.700.002443.350.002443.35
Allen, Mary,212034633.900.002181.560.002452.34
She, Eugene, L,209982806.510.002181.56624.950.00
Gomez, Sheila, J,211654673.880.002181.560.002492.32
Arun, Nancy, C,211694647.880.002181.560.002466.32
Xu, Jaclyn, L,126856904.110.002049.102416.952438.06
Wood, Maria,126676813.120.002049.102344.962419.06
Mr., Schmidt, Irving, W,126696791.100.002049.102357.932384.07
Zhang, Jenny, H,246092120.930.001000.441120.490.00
Romero, Ricky,213612997.320.002443.35553.970.00
Rivera, Mariah,202615314.250.003578.270.001735.98
Tang, Latoya, F,229103882.550.000.002181.561700.99
She, Kathryn, I,264431938.470.000.00782.991155.48
Gao, Edwin,257161302.590.00699.100.00603.49
Ramos, Kendra,2489615.230.000.000.0015.23
Ma, Christy,1502040.260.000.000.0040.26
Zhang, Ramon, D,12352274.240.000.000.00274.24
Kumar, Tommy,17297100.250.000.0037.2762.98
Ramos, Danny,231214144.340.000.002443.351700.99
Sanz, Marvin,196126029.570.003578.270.002451.30
Jenkins, Anna, M,1723491.260.000.000.0091.26
Liu, Clarence,197976021.620.003578.270.002443.35
Sai, Rachael,119128095.320.003374.990.004720.33
Li, Vincent, D,21207123.960.000.000.00123.96
Ramos, Joy,131296823.150.000.002049.104774.05
Miller, Dalton, D,131306797.150.000.002049.104748.05
Lal, Leonard,261601938.470.00782.990.001155.48
Cai, Jorge,220313896.530.002181.560.001714.97
Xu, Willie, C,131606839.460.000.002071.424768.04
Malhotra, Meredith,29314564.480.000.000.00564.48
Nara, Dale, L,212264659.800.002181.560.002478.24
Lopez, Kristopher, L,215604702.390.002181.560.002520.83
Madan, Jarrod, C,215554715.490.002181.560.002533.93
Zhu, Candice, S,212194696.490.002181.560.002514.93
Martinez, Sarah, S,126706785.130.002049.102351.962384.07
Lal, Kate,215574886.700.002443.350.002443.35
Martinez, Ian,125852629.070.002049.100.00579.97
Zhang, Aimee,260251917.460.00782.990.001134.47
Gill, Jaime, M,261521938.470.00782.990.001155.48
Hernandez, Jacquelyn, J,215684659.800.002181.560.002478.24
Vazquez, Marie,218994663.790.002181.560.002482.23
Gonzalez, Kaylee, L,218954657.510.002181.560.002475.95
Navarro, Sheila, L,218894624.910.002181.560.002443.35
Yang, Darryl, K,215714624.910.002181.560.002443.35
Pal, Mohamed, D,126986786.750.002071.420.004715.33
Ferrier, Jenny,219554900.680.002443.350.002457.33
Serrano, Stacy,246132148.210.001000.441147.770.00
Serrano, Diane, E,1485787.970.000.0078.988.99
Jones, Ethan,130516831.740.002071.420.004760.32
Xu, Keith, J,2512464.470.000.000.0064.47
Sai, Ivan, E,1730094.220.000.000.0094.22
Zhao, Gilbert,231193945.530.000.002181.561763.97
Gao, Jorge,235733337.040.000.002181.561155.48
Jimenez, Naomi,249222145.920.000.001000.441145.48
Pal, Tasha,2285339.990.000.000.0039.99
Hayes, Eric, A,22964123.980.000.000.00123.98
Pal, Dale,1845175.470.000.000.0075.47
Madan, Denise, R,2524839.980.000.000.0039.98
Patel, Whitney, F,244684144.340.000.002443.351700.99
Perez, Carmen, C,131396854.450.000.002071.424783.03
Deng, Russell, J,2031467.930.000.000.0067.93
Alonso, Jimmy, T,18280126.560.000.000.00126.56
Ortega, Lawrence,14685146.740.000.000.00146.74
Deng, Colin, B,1829932.220.000.000.0032.22
Ms., Rousey, Linda, R.,212794.990.000.000.004.99
Mehta, Ann, M,14518126.950.000.0063.9762.98
Jiménez, Bruce, L,236403936.540.000.002181.561754.98
Zhu, Erica,252212143.900.000.001000.441143.46
Nath, Jaime,110336495.293374.990.000.003120.30
She, Nichole, M,119098105.310.003374.992297.282433.04
Perez, Janelle,16172186.040.000.000.00186.04
Carlson, Theresa, L,19629109.440.000.0060.4748.97
Kumar, Warren, A,240032806.530.000.002181.56624.97
Xu, Clarence,218774624.910.002181.560.002443.35
Suarez, Brandi,218744638.890.002181.560.002457.33
Pal, Tamara,126896846.920.002071.422331.952443.55
Ramos, Jay, D,218824886.700.002443.350.002443.35
Chander, Latoya, C,261381957.470.00782.990.001174.48
Flores, Alexandra, C,261651957.470.00782.990.001174.48
Ma, Rafael, T,130222644.020.002049.100.00594.92
Torres, Jacqueline,219764198.330.002443.350.001754.98
Ward, Brooke,130075671.240.002071.420.003599.82
Malhotra, Toni,261621903.480.00782.990.001120.49
Gutierrez, Philip, M,219793936.540.002181.560.001754.98
Raje, Rafael, M,130006799.450.002071.422294.992433.04
Hernandez, Frank, G,221984661.500.002181.560.002479.94
Serrano, Dana, S,12678341.430.000.00248.4692.97
Gill, Meredith, E,2426849.970.000.000.0049.97
Xu, Barbara,1407459.880.000.000.0059.88
Ramirez, Olivia, D,197856076.610.003578.270.002498.34
Hayes, Alexis,13048190.230.000.000.00190.23
Henderson, Xavier, K,1299396.250.000.0067.2628.99
Raman, Harold, F,28484778.620.000.000.00778.62
Rai, Christy,1668369.870.000.000.0069.87
Beck, Alisha, E,1146347.920.000.007.9539.97
Wang, Erica, J,221682997.320.002443.350.00553.97
Xu, Arturo,136196808.100.000.002049.104759.00
Reed, Kimberly, D,1731169.970.000.000.0069.97
Lopez, Sergio, L,1512381.260.000.000.0081.26
Suarez, Hector, L,15034103.450.000.008.9994.46
Goel, Yolanda, M,264351957.470.000.00782.991174.48
Xu, Kristen,157514446.400.000.002071.422374.98
Rodriguez, Bobby,157524408.690.000.002071.422337.27
Gutierrez, Pedro, S,1522471.920.000.0036.9334.99
Madan, Stanley,196026093.200.003578.270.002514.93
Sara, Phillip, R,2511639.980.000.000.0039.98
Gray, Jeremiah,233314144.340.000.002443.351700.99
Gill, Kristine,199776044.590.003578.270.002466.32
Subram, Douglas,273521357.970.000.00782.99574.98
Munoz, Deanna,110548223.023399.990.002403.972419.06
Pal, Willie, J,1175546.250.000.000.0046.25
Harrison, Colleen, L,202196044.590.003578.270.002466.32
Serrano, Reginald, J,130252690.400.002071.420.00618.98
Romero, Francis,221964632.860.002181.560.002451.30
Yuan, Jaclyn,249042199.900.001000.441199.460.00
Moreno, Felicia, A,129876759.470.002071.422294.992393.06
Hu, Krystal, D,130127017.440.002071.422493.982452.04
Lin, Kelvin, A,130756843.940.002071.422294.992477.53
Sai, Bruce,221944633.900.002181.560.002452.34
Wang, Jon, A,261911938.470.00782.990.001155.48
Blanco, Orlando,225753018.330.002443.350.00574.98
Prasad, Henry, M,243643965.520.000.002181.561783.96
Yuan, Louis, C,181934145.543578.270.000.00567.27
Srini, Veronica,119967058.700.003374.991291.772391.94
Sharma, Misty,257081253.070.00699.100.00553.97
Johnston, Tamara, H,18492218.260.000.000.00218.26
Zhou, Krystal,235933990.010.000.002181.561808.45
Zhao, Susan, L,2512239.980.000.000.0039.98
Anand, Johnny,140585652.520.000.003355.242297.28
Huang, Mandy,1826672.260.000.000.0072.26
Munoz, Robyn,142145759.870.000.002049.103710.77
Ferrier, Linda, D,1314964.970.000.0034.9929.98
Chandra, Arthur, L,140326859.430.000.002071.424788.01
Kapoor, Rachael, D,1191162.460.000.000.0062.46
Hernandez, Gina,140495290.680.000.002071.423219.26
Gutierrez, Jaime, C,114578211.480.003374.992359.962476.53
He, Susan, A,244673337.040.000.002181.561155.48
Lopez, Summer,1203669.550.000.002.2967.26
She, Glenn, L,291179.990.000.000.009.99
Nath, Bethany,16177133.340.000.000.00133.34
Fernandez, Lydia, M,145233807.400.000.002071.421735.98
Xu, Tony, L,225762721.550.002181.560.00539.99
Nara, Kelsey, A,249052195.910.001000.441195.470.00
Mehta, Denise,130806844.410.002049.102362.272433.04
Romero, Julio,228574886.700.002443.350.002443.35
Vazquez, Theresa, F,225812749.320.002181.560.00567.76
Edwards, Kaylee, M,228514632.860.002181.560.002451.30
Shen, Mitchell, M,229044759.990.000.002181.562578.43
Fernandez, Arthur, J,223992785.050.000.002785.050.00
Gonzalez, Carolyn, H,224072756.540.000.002181.56574.98
Luo, Lindsey, R,222015012.270.000.002443.352568.92
Luo, Devon, D,228504657.510.000.002181.562475.95
Cai, Karen,225722997.320.000.002443.35553.97

Generated 2024-09-19 01:28:18.248 UTC