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

287 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Liang, Lacey, A,157194429.570.000.002049.102380.47
Oliver, Lee,2911969.970.000.000.0069.97
Mr., Solanki, Ajay,18295144.270.000.000.00144.27
Gomez, Marvin, C,28479831.330.000.000.00831.33
Madan, Bruce, G,1820665.960.000.000.0065.96
Deng, Tracy, E,2197837.290.000.000.0037.29
Sullivan, Henry, L,2060323.780.000.000.0023.78
Chander, Carl,14315109.710.000.000.00109.71
Madan, Kristi, I,291842420.340.000.000.002420.34
Dominguez, Darren, M,139666842.120.000.002049.104793.02
Madan, Johnathan, D,136266909.090.000.002049.104859.99
Ramirez, Cole, E,136166872.060.000.002049.104822.96
Liu, Krystal, D,135264549.760.000.002071.422478.34
Sai, Lydia, L,139685181.700.000.002071.423110.28
Sutton, Kern, A,266601957.470.000.00782.991174.48
Sara, Barry, R,139656872.390.000.002071.424800.97
Romero, Walter, A,250201549.420.000.001000.44548.98
Powell, Adam,234233936.540.000.002181.561754.98
Suarez, Dana, M,235413337.040.000.002181.561155.48
Sun, Rafael,267491322.980.000.001322.980.00
Jiménez, Bruce, L,236403936.540.000.002181.561754.98
Hernandez, Raquel, W,139974586.350.000.002071.422514.93
Rivera, Nathaniel, M,140515606.910.000.003286.922319.99
Kumar, Ricardo, K,141333764.070.000.002049.101714.97
Wood, Richard, W,243773945.530.000.002181.561763.97
Subram, Stefanie,12371214.040.000.000.00214.04
Perez, Cesar, L,27982603.490.000.000.00603.49
Muñoz, Pedro, A,234333882.550.000.002181.561700.99
Ross, Brandon,141323804.080.000.002049.101754.98
Munoz, Darren,235394144.340.000.002443.351700.99
Hernandez, Ebony, S,235743337.040.000.002181.561155.48
Rubio, Derrick, P,235253302.050.000.002181.561120.49
Raje, Johnny,139755138.720.000.002049.103089.62
Lal, Franklin, A,141013679.900.000.002888.58791.32
Munoz, Shannon, S,2912249.970.000.000.0049.97
Ma, Laura, L,245033617.830.000.002443.351174.48
Ramos, Byron,143063653.230.000.002071.421581.81
Perez, Joe, A,143265207.700.000.002071.423136.28
Cai, Suzanne,250512174.920.000.001000.441174.48
Yang, Crystal, A,236654207.320.000.002443.351763.97
She, Tamara, M,142245621.220.000.002049.103572.12
Lee, Richard, I,239962744.520.000.002181.56562.96
Butler, Katherine, F,267601322.980.000.001322.980.00
Ross, Arianna, E,267741331.970.000.001331.970.00
Serrano, Mallory, E,267511903.480.000.00782.991120.49
Sun, Aimee, R,1831960.470.000.000.0060.47
Gomez, Mallory, R,248987.280.000.000.007.28
Jenkins, Noah, A,2437913.980.000.000.0013.98
Anand, Alícia, J,291132453.040.000.000.002453.04
She, Candice,291782452.040.000.000.002452.04
Arun, Ross, C,236583936.540.000.002181.561754.98
Alvarez, Randall,267501938.470.000.00782.991155.48
Raman, César, C,240042744.520.000.002181.56562.96
Yuan, Carl, P,241603046.840.000.002443.35603.49
Rodriguez, Heidi, L,251202155.920.000.001000.441155.48
Martin, Briana, L,152132818.590.000.002049.10769.49
Moore, Sarah,289389.990.000.000.009.99
Gonzalez, Savannah, F,156443803.680.000.002071.421732.26
Rana, Raymond,251152155.920.000.001000.441155.48
Chandra, Jarrod,241713006.310.000.002443.35562.96
Zeng, Erica,269241350.750.000.00782.99567.76
Martinez, Jermaine, L,151704391.410.000.002071.422319.99
Alvarez, Tabitha,150283826.400.000.002071.421754.98
Kumar, Luke,241612983.340.000.002443.35539.99
Kumar, Rafael, L,1908824.270.000.002.2921.98
Nara, Melvin, E,27147123.980.000.000.00123.98
Tang, Louis, A,1829239.250.000.000.0039.25
Carlson, Theresa, L,19629109.440.000.000.00109.44
Gao, Gilbert,241653046.840.000.002443.35603.49
Yang, Clarence, D,251212155.920.000.001000.441155.48
Shan, Colleen, D,151504379.080.000.002049.102329.98
Sanchez, Andre,155954369.090.000.002049.102319.99
Andersen, Gilbert, T,273531371.950.000.00782.99588.96
Evans, Mason,154393804.080.000.002049.101754.98
Alonso, Meghan, A,244573356.040.000.002181.561174.48
Rai, Calvin,152292833.570.000.002049.10784.47
Martin, Ebony, F,152234366.410.000.002071.422294.99
Diaz, Carolyn, C,243603626.820.000.002443.351183.47
Suri, Shane, L,251262174.920.000.001000.441174.48
Martin, Byron, E,2521739.980.000.000.0039.98
Becker, Julie,13614114.210.000.000.00114.21
Gutierrez, Cheryl, O,252132184.900.000.001000.441184.46
Sun, Christy,252182184.900.000.001000.441184.46
Moreno, Lori, M,152264391.410.000.002071.422319.99
Alan, Bob, A,273661322.980.000.00782.99539.99
Navarro, Mallory,243653331.030.000.002181.561149.47
Kelly, Emma, A,156463804.080.000.002049.101754.98
Davis, Morgan, J,273591344.470.000.00782.99561.48
Chow, Warren, L,243053945.530.000.002181.561763.97
Garcia, Roy, H,155854367.020.000.002049.102317.92
Sara, Ross,243674179.330.000.002443.351735.98
Diaz, Megan, A,243034207.320.000.002443.351763.97
Anand, Chad,244843563.840.000.002443.351120.49
Kumar, Bethany,29299548.980.000.000.00548.98
Sanchez, Ross,283104.990.000.000.004.99
Xie, Nina,12997118.180.000.000.00118.18
Liang, Steve,1431781.260.000.0049.9931.27
Mr., Schmidt, Steve,157894486.070.000.002049.102436.97
Zhou, Ernest, P,157922645.400.000.002071.42573.98
Jenkins, Joan,161554489.570.000.002049.102440.47
Lal, Gabriel,274731398.460.000.00782.99615.47
Luo, Jerry, M,245864144.340.000.002443.351700.99
Alonso, Diana, L,245903911.530.000.002181.561729.97
Navarro, Eddie, C,245043563.840.000.002443.351120.49
Hu, Susan,252422120.930.000.001000.441120.49
Shen, Devon, G,2735878.980.000.000.0078.98
Pal, Terrence, M,1303759.980.000.000.0059.98
Li, Justin,1412457.590.000.000.0057.59
Gonzalez, Clifford,245053302.050.000.002181.561120.49
Patel, Harold,245853366.020.000.002181.561184.46
Deng, Gilbert, C,157654369.090.000.002049.102319.99
Flores, Connor,157554404.080.000.002049.102354.98
Hernandez, Javier, A,161564344.090.000.002049.102294.99
Johnston, Tamara, H,18492218.260.000.000.00218.26
Suri, Barry,1525378.960.000.000.0078.96
Diaz, Dana, C,12361217.460.000.000.00217.46
King, Maria, E,282022419.060.000.002419.060.00
Xu, Peter, K,282042419.060.000.002419.060.00
Xu, Kate, R,289572419.060.000.000.002419.06
Perez, Rachael, D,26762133.490.000.000.00133.49
Lal, Clarence, L,2447039.980.000.000.0039.98
Griffin, Noah, E,2911873.960.000.000.0073.96
Zhao, Crystal,259066.280.000.000.006.28
Ramos, Robyn, O,15828172.250.000.000.00172.25
Rivera, Jada,2197032.280.000.000.0032.28
Ruiz, Alberto, L,2521227.770.000.000.0027.77
Stewart, Margaret, C,29096574.980.000.000.00574.98
Malhotra, Kristina,2503125.480.000.000.0025.48
Wu, Lisa,2615894.480.000.000.0094.48
Pal, Gilbert,27744643.950.000.00643.950.00
Gill, Ricky, A,1560728.980.000.000.0028.98
Lin, Kelli, A,2139229.990.000.000.0029.99
Prasad, Denise,1829478.260.000.000.0078.26
Adams, Sydney,2736769.990.000.000.0069.99
Mrs., Nara, Barbara,12704217.460.000.000.00217.46
Nath, Latoya, A,27582561.920.000.000.00561.92
Hall, Mary, R,202774.990.000.000.004.99
Chander, Gregory, J,2200174.980.000.000.0074.98
Lin, Wesley,2140742.280.000.0042.280.00
Sanz, Arthur,27688166.280.000.00166.280.00
Butler, Austin, W,1829374.240.000.0074.240.00
Wright, Miguel,2581186.450.000.0086.450.00
Malhotra, Ross, R,2930714.980.000.0014.980.00
Black, Priscilla,1576662.270.000.0034.9927.28
Li, Ramon,2124834.980.000.000.0034.98
Chapman, Pamela, L,2714535.000.000.000.0035.00
Gonzalez, Tabitha, A,2613639.980.000.000.0039.98
Kumar, Shawna, L,1908578.260.000.000.0078.26
Kapoor, Phillip,27581539.990.000.000.00539.99
Davis, Nicole,2295739.980.000.000.0039.98
Serrano, Jacquelyn,2196339.990.000.000.0039.99
Perez, Dominique,1234468.700.000.0032.2736.43
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
Lin, Suzanne,292874.990.000.004.990.00
Zhou, Rafael, A,244949.990.000.009.990.00
Morgan, Jared, A,2821339.980.000.000.0039.98
He, Jessie,29094796.340.000.000.00796.34
Pal, Nichole, J,2674169.990.000.000.0069.99
Fernandez, Kristi,1958528.990.000.000.0028.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
Vance, Phillip,293082438.060.000.000.002438.06
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
Kapoor, Patricia, R,2188342.280.000.0042.280.00
Zhao, Jamie,1617972.160.000.000.0072.16
Madan, Denise, R,2524839.980.000.000.0039.98
Alonso, Jimmy, T,18280126.560.000.000.00126.56
Gonzales, Alexis,2352121.980.000.000.0021.98
Moore, Devin, J,16167102.570.000.000.00102.57
Carlson, Marie,29311603.960.000.000.00603.96
Suarez, Hector, L,15034103.450.000.000.00103.45
Goel, Chad,2821939.980.000.000.0039.98
Jimenez, Joy,28312574.980.000.000.00574.98
Lal, Darrell,1995325.480.000.000.0025.48
Nara, Ricardo,2893464.470.000.000.0064.47
Romero, Roberto, A,18285141.550.000.000.00141.55
Nara, Tonya, C,17251123.960.000.0069.9753.99
Mr., Rovira Diez, Pablo,2119042.280.000.0042.280.00
Li, Cara,275871145.480.000.000.001145.48
Nara, Calvin, J,1136786.260.000.000.0086.26
Perez, Marie,1399666.260.000.000.0066.26
Chande, Carl,1893259.260.000.000.0059.26
Tang, Leonard, L,28109778.620.000.00778.620.00
Sai, Cassandra, R,28110845.310.000.00845.310.00
Wu, Jamie, S,2759564.470.000.000.0064.47
Alvarez, Arthur,248927.280.000.000.007.28
Bradley, Victoria,29454742.350.000.000.00742.35
Moreno, Danny, M,29458811.320.000.000.00811.32
Ma, Colin,2642869.990.000.000.0069.99
Diaz, Kellie, A,1833034.980.000.0034.980.00
Goel, Shawna, L,29332165.280.000.00165.280.00
Lal, Alisha, C,2187234.980.000.000.0034.98
Xie, Lindsey, M,251324.990.000.000.004.99
Lewis, Nicole,21881128.970.000.000.00128.97
Campbell, Haley, L,1730462.270.000.000.0062.27
He, Karen, C,27861539.990.000.000.00539.99
Sullivan, Ruth,277231155.480.000.000.001155.48
Adams, Savannah,2353639.980.000.000.0039.98
Yang, Martha, G,2221035.000.000.000.0035.00
Alonso, Jonathon, A,1523898.960.000.000.0098.96
Hernandez, Hailey, A,1872786.270.000.000.0086.27
Subram, Ivan, A,2614778.980.000.000.0078.98
Madan, Brandy, A,276871183.470.000.000.001183.47
Jiménez, Briana, T,28118588.960.000.000.00588.96
Chandra, Troy,2140674.980.000.0074.980.00
Rodriguez, Joel, C,16488119.950.000.00119.950.00
Sanz, Linda, P,2294512.940.000.000.0012.94
Washington, Julian, C,2333031.970.000.000.0031.97
Shen, Wayne, P,2364712.940.000.000.0012.94
Liu, Jenny,1616581.810.000.000.0081.81
Carlson, Joanna,1559434.990.000.000.0034.99
Parker, Gabriel,1960683.970.000.000.0083.97
Long, Julian,1203472.250.000.000.0072.25
Guo, Cara, R,15721118.960.000.000.00118.96
Rubio, Deanna, T,1957333.980.000.000.0033.98
Suarez, Gina,2024869.970.000.000.0069.97
Hernandez, Marvin, A,230777.280.000.000.007.28
Luo, Colin, L,2121039.990.000.000.0039.99
Suri, Evelyn, A,2122356.980.000.000.0056.98
Wang, Randy, G,2512568.490.000.000.0068.49
Srini, Jay, M,1832662.980.000.000.0062.98
Rodriguez, Ruth, R,2617938.980.000.000.0038.98
Huang, Arturo,289522473.040.000.000.002473.04
Ye, Gilbert,29344548.980.000.000.00548.98
Arthur, Carla,1671091.260.000.000.0091.26
Zhang, Alejandro, P,21992184.260.000.000.00184.26
Fernandez, Emmanuel,2895514.980.000.000.0014.98
Li, Jenny, B,2216978.980.000.000.0078.98
Yang, Louis, J,2301312.940.000.000.0012.94
Wu, Margaret,289282473.050.000.000.002473.05
Romero, Mallory,2643469.990.000.000.0069.99
Butler, Jose,29064815.810.000.000.00815.81
Prasad, Candace, S,2214869.990.000.000.0069.99
Yang, Leah, J,1518659.480.000.000.0059.48
Subram, Arthur, E,2735069.990.000.000.0069.99
Wang, Willie,2930423.970.000.000.0023.97
Lin, Clarence,29069756.330.000.000.00756.33
Ruiz, Sabrina, A,2221442.280.000.000.0042.28
Fernandez, Michele, M,2488423.780.000.000.0023.78
Lee, Grace, J,28318574.980.000.000.00574.98
Jai, Dylan, J,2312839.980.000.000.0039.98
Hernandez, Clinton,29462854.820.000.000.00854.82
Deng, Casey, C,1967442.280.000.000.0042.28
Raji, Shawna, P,1396149.990.000.000.0049.99
Chande, Louis, A,1668168.870.000.000.0068.87
Collins, James, E,2674269.990.000.000.0069.99
Arthur, Johnathan,1873036.960.000.000.0036.96
Gill, Lawrence, J,2022444.460.000.000.0044.46
Martin, Arthur, L,2894349.970.000.000.0049.97
Rana, Rachael, A,1827094.470.000.000.0094.47
Coleman, Paige, L,1526369.970.000.000.0069.97
Patel, Arthur, B,2667169.990.000.000.0069.99
She, Alicia, W,1725062.980.000.000.0062.98
Mehta, Michele,26143123.980.000.000.00123.98
Kumar, Colin,2918869.970.000.000.0069.97
Johnson, Daniel,1105158.980.000.000.0058.98
She, Jeffery, M,2714942.280.000.000.0042.28
Blanco, Krista, L,2758039.980.000.000.0039.98
Luo, Priscilla, R,1790727.770.000.000.0027.77
Gutierrez, Jaime, A,2522739.980.000.000.0039.98
Alonso, Natasha, L,2500914.980.000.000.0014.98
Jai, Melvin, M,27722564.210.000.000.00564.21
Xu, Trisha,2028237.270.000.000.0037.27
Alexander, Hailey, C,1966635.000.000.000.0035.00
Sun, Edwin, O,2117074.980.000.000.0074.98
Gao, Lisa, A,197534.990.000.000.004.99
Shen, Calvin, W,2614578.980.000.000.0078.98
Sanz, Meghan, L,28352562.960.000.000.00562.96
Munoz, Briana,234374.990.000.000.004.99
Ferrier, Mathew,2342639.980.000.000.0039.98
Lopez, Kristi,281377.280.000.000.007.28
Jai, Tara, E,27363132.970.000.000.00132.97
Diaz, Frank, F,29086805.330.000.000.00805.33
Ward, Nathaniel,252337.280.000.000.007.28
Subram, Ross, L,230857.280.000.000.007.28
Guo, Jorge, L,2659069.990.000.000.0069.99
Shan, Warren,2197132.280.000.000.0032.28
Luo, Maurice, C,2749138.980.000.000.0038.98
Suarez, Meghan, L,2217724.270.000.000.0024.27
_SUM9051988.22546835.112386860.532383298.863734993.72

Generated 2024-11-10 10:36:25.316 UTC