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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Andersen, Tara, L,244653356.040.000.002181.561174.48
Cooper, Alex, L,273621407.450.000.00782.99624.46
Ye, Erica, E,130105716.520.002071.420.003645.10
Gutierrez, Cheryl, O,252132184.900.000.001000.441184.46
Gonzalez, Savannah, F,156443803.680.000.002071.421732.26
Jenkins, Amanda,152144490.880.000.002071.422419.46
Kelly, Emma, A,156463804.080.000.002049.101754.98
Fernandez, Donald, C,244623617.830.000.002443.351174.48
Serrano, Danny,243813970.520.000.002181.561788.96
Garcia, Roy, H,155854367.020.000.002049.102317.92
Suarez, Briana, A,152662935.370.000.002071.42863.95
Liang, Lacey, A,157194429.570.000.002049.102380.47
Raji, Damien, K,242823917.540.000.002181.561735.98
Sara, Ross,243674179.330.000.002443.351735.98
Chander, Roger,252142149.910.000.001000.441149.47
Torres, Michele, A,161764404.080.000.002049.102354.98
Anand, Chad,244843563.840.000.002443.351120.49
Mehta, Heidi,142265656.240.000.002071.423584.82
Madan, Michele, A,126766859.460.002071.422349.982438.06
Li, Aimee,179154792.733578.270.000.001214.46
Lal, Terry,182776070.590.003578.270.002492.32
Carlson, Audrey, A,2526360.470.000.000.0060.47
Munoz, Felicia, D,2040659.980.000.000.0059.98
Pal, Sheena, D,211973917.540.002181.560.001735.98
Flores, Brianna,27706553.970.000.000.00553.97
Nath, Omar, F,146725237.720.000.002071.423166.30
Gill, Ricky, A,1560728.980.000.000.0028.98
She, Jenny,275861120.490.000.000.001120.49
Gao, Bianca, C,131125717.890.000.002049.103668.79
Williams, Alexis, D,14674142.470.000.000.00142.47
Black, Michele,1399564.970.000.000.0064.97
Suri, Barry,1525378.960.000.000.0078.96
Martin, Natasha, N,274901331.970.000.00782.99548.98
Ruiz, Marie, J,274981350.750.000.00782.99567.76
Zhou, Ernest, P,157922645.400.000.002645.400.00
Munoz, Natasha, M,246013882.550.000.002181.561700.99
Xu, Crystal, E,157544416.380.000.002071.422344.96
Guo, Rosa, M,244743882.550.000.002181.561700.99
He, Omar,158312646.360.000.002646.360.00
Chande, Willie, B,161632641.390.000.002071.42569.97
Zheng, Kristen, J,244633917.540.000.002181.561735.98
He, Susan, A,244673337.040.000.002181.561155.48
Lal, Gabriel,274731398.460.000.00782.99615.47
Cooper, Cody, A,160283807.400.000.002071.421735.98
Kovar, Tabitha,158332611.410.000.002611.410.00
Alonso, Diana, L,245903911.530.000.002181.561729.97
Moore, Olivia, A,252312189.900.000.001000.441189.46
Xu, Colin,157902668.380.000.002668.380.00
Anderson, Victoria,157994423.380.000.002071.422351.96
Rai, Tonya,252432155.920.000.001000.441155.48
She, Sharon, F,2201769.990.000.000.0069.99
Lu, Glenn,12692156.260.000.000.00156.26
Tang, Grant, H,1146690.190.000.000.0090.19
Vance, Kristi, T,2833847.970.000.000.0047.97
Wang, Alejandro,173106029.573578.270.000.002451.30
Chander, Drew, J,251112145.920.000.001000.441145.48
Shen, Kelvin,224063018.330.000.002443.35574.98
Liang, Ronnie,2458430.480.000.000.0030.48
Li, Barbara,157884443.380.000.002071.422371.96
Navarro, Renee,157934369.090.000.002049.102319.99
Raman, Cindy,161574391.410.000.002071.422319.99
Alonso, Naomi,158302680.380.000.002680.380.00
Deng, Gilbert, C,157654369.090.000.002049.102319.99
Rana, Ross,252402120.930.000.001000.441120.49
Rai, Melvin, J,246043681.800.000.003681.800.00
Hill, Luis,275001371.950.000.00782.99588.96
Perez, Kyle, J,161804386.370.000.002049.102337.27
Shen, Franklin,2714439.990.000.000.0039.99
Perez, Bryant, L,150423807.400.000.002071.421735.98
Lal, Nina, L,142635647.930.000.002049.103598.83
Kumar, Katie, P,123416840.620.002049.102294.992496.53
Martin, Tabitha,2526923.780.000.000.0023.78
Gomez, Brandi, M,14675187.980.000.000.00187.98
Malhotra, Joel, E,1634358.250.000.000.0058.25
Morgan, Melissa, M,2022274.450.000.000.0074.45
Xylaras, Ioannis,202155279.260.003578.270.001700.99
Nara, Latoya, J,182086035.600.003578.272457.330.00
Patel, Ruben, I,197654132.240.003578.27553.970.00
Deng, April,111178184.993399.990.002365.942419.06
Townsend, Darren,184675279.260.003578.271700.990.00
Liu, Jessie,111068079.050.003399.992294.992384.07
Gao, Todd, M,110618129.023374.990.002369.962384.07
Raje, Kelli, A,281362384.070.000.002384.070.00
Gao, Jon, C,114568224.460.003399.992391.432433.04
Sanchez, Joel,184685333.250.003578.271754.980.00
She, Kathryn, I,264431938.470.000.00782.991155.48
Diaz, Dana, C,12361217.460.000.000.00217.46
Carlson, Billy, C,19667150.950.000.000.00150.95
Diaz, Tyrone,13116230.250.000.0032.27197.98
Prasad, Francisco,16628187.580.000.000.00187.58
Alvarez, Tyrone, K,27693539.990.000.000.00539.99
Parker, Gabriella,213944657.510.002181.560.002475.95
Chander, Alisha,125722611.410.002071.420.00539.99
Zhou, Jon, L,110608153.023399.990.002319.992433.04
Suri, Cesar,175124170.543578.270.00592.270.00
Lopez, Manuel, M,140505650.240.000.003295.262354.98
Moreno, Larry, W,282072461.550.000.002461.550.00
Beck, Ashlee, L,266661336.960.000.001336.960.00
Raje, Terrence,182466030.610.003578.272452.340.00
Zheng, Alan,110505007.303374.990.00854.97777.34
Cai, Roger, A,13002294.940.000.00167.99126.95
Suri, Pedro,264221980.960.000.00782.991197.97
Zimmerman, Candice, J,267541938.470.000.00782.991155.48
Gao, Amy,219963946.520.002181.560.001764.96
Malhotra, Meredith,29314564.480.000.000.00564.48
Weber, Deanna, L,148553759.080.000.002049.101709.98
Ye, Amy,11073191.900.000.00103.9687.94
Lee, Dalton, J,169314767.733578.270.000.001189.46
Dominguez, Micheal,261421952.450.00782.990.001169.46
Madan, Jarrod, C,215554715.490.002181.560.002533.93
Munoz, Ebony,131065697.520.000.002071.423626.10
Martinez, Sarah, S,126706785.130.002049.102351.962384.07
Prasad, Clifford,1560466.750.000.000.0066.75
Gao, Candice, M,17493130.960.000.000.00130.96
Vazquez, Diane, D,11987279.230.000.000.00279.23
Walker, Seth, E,27689539.990.000.000.00539.99
Serrano, Gloria, G,215564930.680.002443.350.002487.33
Jai, Tommy, C,150272853.570.000.002049.10804.47
Raman, Virginia,2615969.990.000.000.0069.99
Alvarez, Linda,140475643.540.000.003321.262322.28
Gonzalez, George, L,119424792.290.003399.99614.96777.34
Saunders, Micheal,175134260.243578.270.00681.970.00
Alonso, Danny, S,182176056.613578.270.002478.340.00
Nath, Cassie,246062155.920.001000.441155.480.00
Lin, Bianca,111078171.013374.990.002376.962419.06
Zhao, Jamie,1617972.160.000.000.0072.16
Madan, Denise, R,2524839.980.000.000.0039.98
Lopez, Savannah,257091308.060.00699.100.00608.96
Blanco, Mallory,219584696.490.002181.560.002514.93
Ramos, Carolyn,179264715.703578.270.000.001137.43
Chande, Melvin, R,114608137.520.003399.992294.992442.54
Martinez, Emma,16734128.970.000.0049.9978.98
Zhou, Carol, L,2445421.490.000.000.0021.49
Shan, Franklin, C,2771858.980.000.000.0058.98
Alonso, Jonathon, A,1523898.960.000.000.0098.96
Rodriguez, Kristi,143453639.920.000.002049.101590.82
Martinez, Tyler, T,282012419.060.000.002419.060.00
Lal, Katie, E,182106044.593578.270.002466.320.00
Goel, Karla, L,11146112.930.000.0053.9558.98
Raji, Colleen,27707561.480.000.000.00561.48
Zeng, Jon, O,143105200.660.000.002071.423129.24
Lopez, Kristopher, L,215604702.390.002181.560.002520.83
Xie, Casey,212174659.900.002181.560.002478.34
Kapoor, Arthur,2448323.970.000.000.0023.97
Luo, Lacey,241752743.040.000.002181.56561.48
King, Kevin, W,214024624.910.002181.560.002443.35
Yang, Alan, L,1560539.970.000.000.0039.97
Lopez, Sergio, L,1512381.260.000.000.0081.26
James, Evan, V,1111985.220.000.0035.2349.99
Goel, Yolanda, M,264351957.470.000.00782.991174.48
Mehta, Marco,110078211.003399.990.004811.010.00
Sara, Edgar, A,111048173.033399.990.002334.982438.06
Johnson, Elizabeth,110048196.013399.990.004796.020.00
Ruiz, Julio,110058121.333374.990.004746.340.00
Long, Angelica, C,282062398.050.000.002398.050.00
Mehta, Tina, C,114448136.020.003374.992376.962384.07
Lal, Karl, R,142645217.730.000.002822.762394.97
Pal, Christine, I,182426121.710.003578.272543.440.00
Harris, Eduardo, S,182386030.613578.270.002452.340.00
Xie, Lindsey, M,251324.990.000.000.004.99
Huang, Lacey, J,1195163.520.000.000.0063.52
Moreno, Janet, L,1559259.980.000.0024.9934.99
She, Mindy, J,13009168.670.000.000.00168.67
Torres, Wendy, A,182696113.200.003578.270.002534.93
Ortega, Monique, C,123556818.110.002049.102350.962418.05
Campbell, Haley, L,1730462.270.000.000.0062.27
Liu, Warren,150143860.870.000.002071.421789.45
Suarez, Alfredo,196015314.250.003578.270.001735.98
Rana, Johnathan, R,2749737.290.000.000.0037.29
Fernandez, Geoffrey,199636054.220.003578.270.002475.95
Martinez, Daniel, P,177254698.763578.270.000.001120.49
Navarro, Janet, J,28320539.990.000.000.00539.99
Gonzalez, Francisco, L,122453967.260.003399.990.00567.27
Torres, Joanna, E,244644.990.000.000.004.99
Lin, Jeffery, J,2734778.980.000.000.0078.98
Raji, Dale,1926542.280.000.000.0042.28
Ramos, Jaime,1572070.220.000.0035.2334.99
Sai, Ross, A,219664659.900.002181.560.002478.34
Jai, Gregory,1634246.470.000.000.0046.47
Prasad, Arthur,142755158.370.000.002800.442357.93
Gonzalez, Kristopher, C,192644132.240.003578.27553.970.00
Sai, Abby, L,111018262.523399.990.002439.992422.54
Xu, Julie,183016056.610.003578.272478.340.00
Lin, Wesley,2140742.280.000.0042.280.00
Sanz, Mathew, L,1455763.970.000.0063.970.00
Wu, Mandy,183096090.590.003578.272512.320.00
Ma, Roger, V,151305215.400.000.002049.103166.30
Rodriguez, Tammy,1523359.980.000.000.0059.98
Shan, Drew,236594179.330.000.002443.351735.98
Sara, Geoffrey,261881938.470.00782.990.001155.48
Lin, Jake,242482770.520.000.002181.56588.96
Malhotra, Marco, L,29459805.330.000.000.00805.33
Jiménez, Beth, H,111208242.490.003374.992394.462473.04
Diaz, Danny, C,1819030.970.000.008.9921.98
Nara, Lindsay, M,252474.990.000.000.004.99
Cai, Vincent, L,1175758.050.000.0024.4933.56
Deng, Latoya, H,219694759.470.002181.560.002577.91
Ferrier, Linda, D,1314964.970.000.0034.9929.98
Shan, Connor, C,1890135.000.000.000.0035.00
Rai, Sharon,202256056.610.003578.270.002478.34
Rana, Raymond,251152155.920.000.001000.441155.48
Kapoor, Abby, J,29054751.340.000.000.00751.34
Hall, Jeremiah, M,182506058.213578.270.002479.940.00
Nelson, Sophia,166644377.753578.270.00799.480.00
Zhou, Rafael, A,244949.990.000.009.990.00
Martin, Beth, K,2331739.980.000.000.0039.98
Ms., Roy, Lisa, K.,214034895.690.002443.350.002452.34
Raje, Derek,125742626.390.002071.420.00554.97
Sanz, Francis,125772614.080.002049.100.00564.98
Andersen, Jaime,2526860.470.000.000.0060.47
Liu, Jenny,1616581.810.000.000.0081.81
Ma, Jeffery,1826469.970.000.000.0069.97
Rodriguez, Carla, V,212304171.620.002443.350.001728.27
Vazquez, Juan, P,225782735.530.002181.560.00553.97
Suri, Shane, L,251262174.920.000.001000.441174.48
Gill, Kellie,1729294.220.000.000.0094.22
Chander, Cassie, M,1825845.950.000.000.0045.95
Patel, Gerald,230954.990.000.000.004.99
Bailey, Melissa, C,1957282.250.000.0023.7858.47
Martin, Reginald,14054210.770.000.000.00210.77
Gill, Theodore,1114941.260.000.000.0041.26
Rodriguez, Jarrod,136366831.760.000.002071.424760.34
Xu, Roger,2796839.980.000.0039.980.00
Liu, Candice,287202419.060.000.002419.060.00
Lu, Sandra, N,135214514.770.000.004514.770.00
Zhang, Jenny, H,246092120.930.001000.441120.490.00
Nath, Michele, L,110568207.503374.990.002413.452419.06
Martin, Lance,2523639.980.000.000.0039.98
Nara, Karla, C,258271873.580.00699.100.001174.48
Young, Morgan, L,123426838.120.002049.102369.962419.06
Torres, Kristy, M,130352638.060.002049.100.00588.96
Serrano, Linda,11071110.230.000.0042.2667.97
Chandra, Tina, S,139745237.730.000.002867.762369.97
Raji, Tammy, K,170714417.753578.270.000.00839.48
Simmons, Jacqueline, W,13137177.940.000.00112.9764.97
Brown, Cameron, D,13041153.950.000.0088.9864.97
Li, Jenny, B,2216978.980.000.000.0078.98
Nara, Rafael, J,1705296.920.000.0042.9353.99
Yang, Clarence, D,251212155.920.000.001000.441155.48
Martin, Anne, V,250342164.910.000.001000.441164.47
Sandberg, Kristine,122413989.460.003399.990.00589.47
Luo, Barbara,2797829.480.000.0029.480.00
Suarez, Daisy, A,182886093.200.003578.272514.930.00
Rivera, Nathaniel, M,140515606.910.000.003286.922319.99
Ruiz, Leslie, J,260327.280.000.007.280.00
Liang, Steve,1431781.260.000.0049.9931.27
Nara, Jaclyn, M,119305035.810.003399.990.001635.82
Sai, Ronald, B,136436799.450.000.002071.424728.03
Vazquez, Ross,11148126.240.000.0053.9972.25
Rodriguez, Toni, J,2525139.980.000.000.0039.98

Generated 2024-09-19 16:22:43.323 UTC