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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Vazquez, Victor, R,29453742.350.000.000.00742.35
Stone, Mitchell,2501369.970.000.000.0069.97
Chande, Cassie,111038182.503374.990.002388.452419.06
Martinez, Ethan, C,202605314.250.003578.270.001735.98
Xu, Kelvin, K,212223936.540.002181.560.001754.98
Goel, Alejandro, K,130776766.630.002049.100.004717.53
Watson, Adrian, K,13641144.740.000.00117.4627.28
Hernandez, Beth, L,29084742.350.000.000.00742.35
Hernandez, Jessie, A,241722735.530.000.002181.56553.97
Guo, Autumn, A,1421386.260.000.0058.9827.28
Yuan, Kelsey, D,1303494.710.000.000.0094.71
Lopez, Brandy, S,1819999.940.000.000.0099.94
Ferrier, Leslie, M,285352433.040.000.002433.040.00
Xu, Terry,2422815.230.000.000.0015.23
Ma, Amy, E,173096030.613578.270.000.002452.34
Li, Kristen, R,15153113.970.000.0088.9824.99
Huang, Tamara, E,1405386.260.000.0086.260.00
Carlson, Briana,264361957.470.00782.990.001174.48
Raje, Gilbert,110558168.013374.990.002394.972398.05
Malhotra, Janelle,2642569.990.000.000.0069.99
Carlson, Jose,1995474.450.000.0060.4713.98
Patel, Summer, G,267531957.470.000.00782.991174.48
Xu, Karl,233213060.820.000.002443.35617.47
Williams, Alexis, D,14674142.470.000.000.00142.47
Van, Brenda, J,2489039.980.000.0039.980.00
Beck, Cedric, L,2240369.990.000.0069.990.00
Liu, Lacey, L,235453882.550.000.002181.561700.99
Rodriguez, Pedro, L,179114698.763578.270.000.001120.49
Sai, Kari, E,1423183.970.000.0024.9958.98
Perez, Dominique,1234468.700.000.0044.2124.49
Serrano, Rebekah,141303814.060.000.003814.060.00
Moreno, Janet, L,1559259.980.000.0024.9934.99
Lal, Franklin, A,141013679.900.000.002888.58791.32
Kumar, Ricardo, K,141333764.070.000.003764.070.00
Sun, Rafael,267491322.980.000.001322.980.00
Xu, Roger,2796839.980.000.0039.980.00
Lal, Kenneth, J,187015357.740.003578.271779.470.00
Gill, Kristine,199776044.590.003578.270.002466.32
Lin, Mandy, C,250352183.910.000.001000.441183.47
Liu, Candice,287202419.060.000.002419.060.00
Ramirez, Isaiah,119058155.980.003374.992367.932413.06
Carlson, Wendy,202206060.500.003578.270.002482.23
Yang, Ronnie,235243598.830.000.003598.830.00
She, Ricardo, A,1423378.970.000.000.0078.97
Sharma, Jerry, C,136516812.120.000.002049.104763.02
Sai, Rachael,119128095.320.003374.990.004720.33
Ramos, Tanya, R,140456804.130.000.002049.104755.03
Lu, Sandra, N,135214514.770.000.004514.770.00
Ramos, Jessie, R,117648129.020.003399.992344.962384.07
Sullivan, Carla, A,206116021.620.003578.270.002443.35
Romero, Latasha,142205696.190.000.002071.423624.77
Zhang, Jenny, H,246092120.930.001000.441120.490.00
Munoz, Tanya,234363950.520.000.002181.561768.96
Mehta, Evelyn, S,204204132.240.003578.27553.970.00
Garcia, Rebekah, M,140073772.410.000.003772.410.00
James, Evan, V,1111985.220.000.0035.2349.99
Vazquez, Casey, S,131326880.620.000.002049.104831.52
Perez, Johnathan, D,204264139.750.003578.27561.480.00
Tang, Jenny, E,142105621.240.000.003286.272334.97
Raji, Kelli, G,131236765.440.000.002049.104716.34
Rai, Rafael, H,18715123.960.000.000.00123.96
Shan, Johnny,119997043.270.003399.991308.312334.97
Chande, Derek,267431371.950.000.001371.950.00
Nath, Michele, L,110568207.503374.990.002413.452419.06
Raje, Lacey, T,123586787.760.002071.422297.282419.06
Wang, Rosa, I,119938131.320.003374.990.004756.33
Becker, Grant,2139032.280.000.000.0032.28
Bailey, Destiny, C,2294158.980.000.000.0058.98
Browning, Jay, M,242512983.340.000.002443.35539.99
Chande, Tonya,119928123.030.003399.990.004723.04
She, Kristin, L,1996197.970.000.008.9988.98
Mehta, Michele,26143123.980.000.000.00123.98
Goel, Marshall, M,27691603.490.000.000.00603.49
Blanco, Jésus, E,204486044.590.003578.270.002466.32
Chen, Bianca,248914.990.000.000.004.99
Luo, Barbara,2797829.480.000.0029.480.00
Zhu, Colin,1997383.440.000.0022.9760.47
Wu, Laura,206156060.500.003578.270.002482.23
Chen, Louis, J,17059123.960.000.000.00123.96
Suarez, Daisy, A,182886093.200.003578.272514.930.00
Carlson, Eddie,233474.990.000.000.004.99
Peterson, Juan, H,130826906.390.002071.420.004834.97
Zhao, Lacey, M,277131158.960.000.000.001158.96
Goel, Karla, L,11146112.930.000.0053.9558.98
Alonso, Teresa,1313883.970.000.0058.9824.99
Prasad, Ebony,243683946.520.000.002181.561764.96
Ye, Alvin, B,155752910.900.000.002071.42839.48
Ruiz, Leslie, J,260327.280.000.007.280.00
Saunders, Brandy,119464697.310.003399.99554.97742.35
Raji, Warren, J,267961957.470.000.00782.991174.48
Liang, Dennis,14034104.240.000.000.00104.24
Liang, Steve,1431781.260.000.0049.9931.27
Perez, Preston,1237061.530.000.0034.5626.97
Vazquez, Rebekah, A,157844379.090.000.002049.102329.99
Suri, Kristopher, M,2284950.230.000.000.0050.23
Raje, Cristina, S,179174733.753578.270.000.001155.48
Patel, Jillian,266671390.950.000.001390.950.00
Alexander, Elizabeth,130896800.450.000.002071.424729.03
Raman, Shane,166615908.253578.270.000.002329.98
Beck, Alicia, L,172484382.753578.270.000.00804.48
Rubio, Mallory, S,1109888.960.000.0029.9858.98
Jai, Katrina,1304459.980.000.000.0059.98
Ms., Sherwood, Irma, J.,245984228.310.000.002443.351784.96
Gutierrez, Carrie, C,28139127.280.000.000.00127.28
Navarro, Kristy, J,1957074.940.000.0045.9528.99
Moreno, Leslie, C,11114122.890.000.007.95114.94
Garcia, Stefanie, E,277431155.480.000.000.001155.48
Collins, Rebecca, M,261531957.470.00782.990.001174.48
Sanchez, Marie,2292490.950.000.0090.950.00
Deng, Colin, B,1829932.220.000.000.0032.22
Weber, Cynthia,269211336.960.000.00782.99553.97
Ortega, Alfredo, W,259581903.480.00782.990.001120.49
Martin, Felicia, L,15018112.460.000.00112.460.00
Goel, Bethany,27511548.980.000.000.00548.98
Ruiz, Naomi,236493945.530.000.002181.561763.97
Sai, Holly, V,2676937.290.000.000.0037.29
Lin, Darryl, J,1503141.270.000.0032.288.99
Sanchez, Patrick, W,24382143.780.000.000.00143.78
Cai, Candice,267471938.470.000.00782.991155.48
Lopez, Terrance, T,14217139.450.000.0089.4649.99
Raman, Ronald, M,17077138.450.000.0088.4649.99
Goel, Carly, C,129896817.120.002049.102369.972398.05
Ye, Christy,142195744.220.000.002071.423672.80
Long, Emily, L,261401917.460.00782.990.001134.47
Zeng, Alvin, M,11118115.850.000.000.00115.85
Lal, Jodi, J,2294464.470.000.0064.470.00
Kumar, Jenny, C,234293936.540.000.002181.561754.98
Mehta, Deanna, P,172806089.593578.270.002511.320.00
Raman, Jay, M,136186763.150.000.002049.104714.05
Becker, Leonard, C,22405123.980.000.00123.980.00
Serrano, Francis, R,235473598.830.000.003598.830.00
Nara, Dawn, M,218914921.690.002443.350.002478.34
Raman, Candace, M,117668280.480.003399.992419.462461.03
Vance, Phillip,293082438.060.000.002438.060.00
Romero, Jessie,250302180.410.000.001000.441179.97
Raji, Donna,2490661.960.000.0061.960.00
Andersen, Brendan,151215202.730.000.002071.423131.31
Ruiz, Gloria,123435567.930.002049.101223.842294.99
Pal, Donna, S,235723617.830.000.003617.830.00
Liang, Martha,165254752.753578.270.001174.480.00
She, Jerry, C,142775196.740.000.002071.423125.32
Garcia, Frederick, J,16489112.730.000.00112.730.00
Evans, Carlos, J,235384198.330.000.002443.351754.98
Ramos, Monique,164956002.233578.270.000.002423.96
Nara, Dale, L,212264659.800.002181.560.002478.24
Ramos, Victor, D,242469.990.000.009.990.00
Lopez, Donald, A,267401938.470.000.00782.991155.48
Lin, Kelvin, A,130756843.940.002071.422294.992477.53
Johnson, Emma, M,1513662.270.000.0034.9927.28
Kapoor, Dominic, J,1669967.580.000.0032.6034.98
Li, Stacey,140645694.210.000.003375.252318.96
She, Melvin,165164733.753578.270.001155.480.00
Muñoz, Pedro, A,234333882.550.000.002181.561700.99
Sanz, Nelson, M,1405649.480.000.0024.4924.99
Li, Alvin,267641938.470.000.00782.991155.48
Sanz, Eddie, A,19580173.930.000.0053.99119.94
Gonzalez, Clifford,245053302.050.000.002181.561120.49
Xie, Kelli, J,204526156.700.003578.270.002578.43
Nath, Grant, A,2894714.980.000.000.0014.98
Lal, Andres, L,166235973.243578.270.000.002394.97
Alonso, Armando, M,136476793.150.000.002049.104744.05
Serrano, Kristi,206166093.200.003578.270.002514.93
Vazquez, Andy,196205279.260.003578.270.001700.99
Shen, Priscilla, A,28215589.960.000.00589.960.00
She, Tamara, M,142245621.220.000.002049.103572.12
Ma, Autumn,209944191.720.003578.27613.450.00
Andersen, Gilbert, T,273531371.950.000.00782.99588.96
Ramos, Craig,14209193.970.000.004.99188.98
Xu, Alicia,1137079.970.000.000.0079.97
Yuan, Deborah,120214043.460.003399.990.00643.47
Suarez, Nelson,273551383.450.000.00782.99600.46
Gomez, Danny, V,166365932.743578.270.000.002354.47
Miller, Zachary, M,151692919.890.000.002071.42848.47
Raje, Bonnie,206296060.500.003578.270.002482.23
Adams, Sydney,2736769.990.000.000.0069.99
Madan, Summer, D,123476839.120.002049.102370.962419.06
Gill, Orlando,2136093.970.000.000.0093.97
Rubio, Sabrina, A,209844153.250.003578.27574.980.00
Goel, Roger, A,236523907.540.000.002181.561725.98
Luo, Ashlee,235344179.330.000.002443.351735.98
Chandra, Veronica,146815178.400.000.002049.103129.30
Liang, Gilbert,122423948.970.003374.990.00573.98
Goldstein, Dustin,123378137.010.003399.992343.962393.06
Gill, Monique, L,1772721.980.000.0021.980.00
Thomas, Sydney,143225111.440.000.002049.103062.34
Perez, Molly,259411255.360.00699.100.00556.26
Sun, Lacey, L,1513181.260.000.000.0081.26
Diaz, Ruben, A,2513639.980.000.0039.980.00
Patterson, Jordan,17238147.480.000.00147.480.00
Cook, Victoria, J,206206044.590.003578.270.002466.32
Cooper, Katherine, R,14314122.950.000.000.00122.95
Li, Elijah,167406099.103578.270.002520.830.00
Liu, Karen, F,1400863.970.000.0034.9928.98
Madan, Johnathan, D,136266909.090.000.002049.104859.99
Peterson, Lucas,17298174.450.000.000.00174.45
Jones, Emily,166595873.263578.270.000.002294.99
Gonzalez, Shane, Y,141253772.410.000.003772.410.00
Chapman, Kristi, l,219863882.550.002181.560.001700.99
Raman, Arthur,240012983.340.000.002443.35539.99
Rodriguez, Ebony,1451782.970.000.000.0082.97
Liang, Colin,13639188.960.000.0068.96120.00
Zhao, Marshall, C,220333917.540.002181.560.001735.98
Lu, Curtis,110118133.043399.990.004733.050.00
Guo, Randy, L,2295664.470.000.000.0064.47
Guo, Susan, A,2654314.230.000.0014.230.00
Xie, Brendan,130182642.380.002071.420.00570.96
Raje, Devon,292892433.040.000.002433.040.00
Yuan, Bethany, G,110306471.323399.990.000.003071.33
Serrano, Tabitha,283272407.040.000.002407.040.00
Hernandez, Javier, A,161564344.090.000.002049.102294.99
Raji, Katrina, M,165174698.763578.270.001120.490.00
Watson, Maria,172294471.743578.270.000.00893.47
Alonso, Brandi,1706186.270.000.000.0086.27
Ross, Brandon,141323804.080.000.003804.080.00
Lal, Shawna,179244733.753578.270.000.001155.48
Dominguez, Robin,166854183.233578.270.000.00604.96
Sara, Adriana, M,15146161.940.000.000.00161.94
Lal, Kelsey, T,249132155.920.000.001000.441155.48
Lopez, Cesar,17500156.960.000.000.00156.96
Ramos, Joy,131296823.150.000.002049.104774.05
Madan, Erick, W,1421282.260.000.000.0082.26
She, Alvin, E,166575900.553578.270.000.002322.28
Sara, Troy, R,225832821.510.000.002181.56639.95
Ramos, Meredith, A,2330767.930.000.000.0067.93
Jimenez, Latasha, E,13121121.250.000.0054.9966.26
Hernandez, Jill, L,13003230.250.000.0071.25159.00
Arun, Barry,2770039.980.000.000.0039.98
Serrano, Derrick,167074377.753578.270.00799.480.00
Ma, Darryl, R,1559981.240.000.0049.9731.27
Hernandez, Ross,1467781.260.000.000.0081.26
Hu, Glenn, R,248974.990.000.000.004.99
Sharma, Donna,119986962.100.003374.991249.842337.27
He, Curtis, D,249212180.410.000.001000.441179.97
Ashe, Joanna, F,209972744.520.002181.56562.960.00
Arthur, Kristi, W,166754385.033578.270.00806.760.00
Deng, Jodi,161612700.050.000.002049.10650.95
Ramos, Eddie, T,13954128.460.000.000.00128.46
Rodriguez, Dylan, E,1661175.530.000.0042.9332.60
Pal, Jenny,15132151.940.000.000.00151.94
Lu, Rosa, A,166634471.743578.270.00893.470.00
Andersen, Ashlee, J,11059116.930.000.00116.930.00
Chandra, Harold, K,1723686.270.000.000.0086.27
Sanz, Kellie,167084406.743578.270.00828.470.00
Deng, Tasha,114598141.330.003399.992322.282419.06
Zeng, Tiffany, B,2189039.990.000.000.0039.99
Goel, Derek,170454480.733578.270.00902.460.00
Flores, Miranda,1724383.980.000.0053.9929.99
Martinez, Heidi, L,2292268.970.000.000.0068.97
Roberts, Jordan,234324179.330.000.002443.351735.98
Luo, Julie, M,2912169.970.000.000.0069.97

Generated 2024-09-19 22:07:13.524 UTC