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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Martin, Ricky, C,16608101.570.000.0071.5829.99
Mehta, Deanna, P,172806089.593578.270.000.002511.32
Adams, Savannah,2353639.980.000.000.0039.98
Morgan, Natalie,1514963.970.000.000.0063.97
Fernandez, Emmanuel,2895514.980.000.000.0014.98
Moreno, Janet, L,1559259.980.000.0024.9934.99
Carson, Bradley,239952983.340.000.002443.35539.99
Gomez, Hector, A,2933749.990.000.000.0049.99
Yuan, Warren, P,190912.290.000.000.002.29
Martin, Hector,27860615.470.000.000.00615.47
Huang, Mandy,1826672.260.000.000.0072.26
Sanz, Larry,14067114.960.000.000.00114.96
Garcia, Toni,221934886.700.000.002443.352443.35
Subram, Ann, M,186936021.620.003578.272443.350.00
Huang, Alejandro,114648128.510.003374.992334.462419.06
Walker, Seth, E,27689539.990.000.000.00539.99
Fernandez, Geoffrey,199636054.220.003578.270.002475.95
Srini, Douglas, M,1673335.260.000.000.0035.26
Lewis, Jasmine,139646806.450.000.002071.424735.03
Fernandez, Allen,195966056.610.003578.270.002478.34
Xu, Kristen,157514446.400.000.002071.422374.98
Kapoor, Cesar, J,243023882.550.000.002181.561700.99
Guo, Jaclyn,131196829.450.000.002071.424758.03
Alan, Meghan, I,28210564.480.000.000.00564.48
Hernandez, Orlando, C,219514923.290.002443.350.002479.94
Goldberg, Mindy,161594411.650.000.002071.422340.23
Hu, Valerie, M,150443803.560.000.002049.101754.46
Schmidt, Pamela, I,2437531.730.000.000.0031.73
Sai, Barry,229074169.330.000.002443.351725.98
Zheng, Roger,2932149.970.000.000.0049.97
She, Lindsay,29456765.320.000.000.00765.32
Jai, Jodi, M,2797158.980.000.000.0058.98
Wu, Warren, M,1560263.970.000.000.0063.97
Chapman, Patricia,120377107.100.003374.990.003732.11
Li, Alvin,267641938.470.000.00782.991155.48
Hu, Alejandro,13125138.540.000.000.00138.54
Gao, Randy,251132180.410.000.001000.441179.97
Shan, Thomas, N,274831382.460.000.00782.99599.47
Serrano, Leslie, T,1401462.270.000.000.0062.27
Hernandez, Javier, A,161564344.090.000.002049.102294.99
Dominguez, Andy, L,14126135.550.000.0063.9771.58
Russell, Alexis, L,13634234.930.000.000.00234.93
Hu, Marshall, H,267971957.470.000.00782.991174.48
Yang, Wesley, K,151275182.730.000.002071.423111.31
Sharma, Kelvin, D,266551322.980.000.001322.980.00
Chen, Autumn, I,214084624.910.002181.560.002443.35
Guo, Micah, M,241632756.540.000.002181.56574.98
Gutierrez, Diana,1967667.970.000.000.0067.97
Shen, Russell, M,11150192.420.000.00143.4548.97
Suarez, Hector, L,15034103.450.000.008.9994.46
Cai, Jorge,220313896.530.000.002181.561714.97
Bradley, Emma,142115662.900.000.002049.103613.80
Lu, Susan, C,1235793.450.000.000.0093.45
Vazquez, Marvin, K,2195335.000.000.000.0035.00
Carlson, Wendy,202206060.500.003578.270.002482.23
Sanchez, Carla,1827430.970.000.000.0030.97
Gao, Cara, B,156423772.410.000.002071.421700.99
Bailey, Destiny, C,2294158.980.000.000.0058.98
Ma, Dawn, A,1395682.260.000.000.0082.26
Saunders, Patricia, J,195655308.240.003578.270.001729.97
Sanchez, Patrick, W,24382143.780.000.000.00143.78
Evans, Mason,154393804.080.000.002049.101754.98
Sharma, Arturo,136486765.440.000.002049.104716.34
Liang, Louis, M,127066851.410.000.002071.424779.99
Xie, Nina,12997118.180.000.000.00118.18
Jimenez, Joy,28312574.980.000.000.00574.98
Peterson, Allison, A,2642160.470.000.000.0060.47
Henderson, Xavier, K,1299396.250.000.000.0096.25
Diaz, Kellie, A,1833034.980.000.0034.980.00
Fernandez, Kristi,1958528.990.000.000.0028.99
Chow, Christy, M,126816784.130.002049.100.004735.03
He, Amy,224112770.520.000.002181.56588.96
Zheng, Erica, K,236434.990.000.000.004.99
Zeng, Amy,242422756.540.000.002181.56574.98
Saunders, Ruben, G,27983539.990.000.000.00539.99
Xu, Barbara,1407459.880.000.000.0059.88
Rivera, Evan, Y,267571344.470.000.001344.470.00
Rai, Rafael, H,18715123.960.000.000.00123.96
Malhotra, Geoffrey, W,1829824.270.000.000.0024.27
Raman, Deanna, H,17053123.960.000.000.00123.96
Nath, Keith,1961761.750.000.000.0061.75
Raje, Gregory, C,2291139.980.000.000.0039.98
Watson, Alexandra, H,252491868.56699.100.000.001169.46
Malhotra, Terrance, E,20223187.380.000.000.00187.38
Martin, Ruben,224002737.820.000.002181.56556.26
Romero, Ruben,1663268.870.000.000.0068.87
Navarro, Carolyn,110698104.050.003399.992319.992384.07
Malhotra, Meredith,29314564.480.000.000.00564.48
Zheng, Jaclyn, F,119108113.030.003374.992319.992418.05
She, Glenn, L,291179.990.000.000.009.99
Hernandez, Monique, J,15138123.450.000.0034.9988.46
Arun, Brenda,136306824.730.000.002071.424753.31
Zhang, Edwin,157854454.350.000.002071.422382.93
Moreno, Diana, J,29298548.980.000.000.00548.98
Zhou, Ernest, P,157922645.400.000.002645.400.00
Rodriguez, Douglas, W,196525314.250.003578.270.001735.98
Sanz, Kari, V,273411322.980.000.00782.99539.99
Xu, Tasha, E,1194882.260.000.000.0082.26
Zhao, Jamie,1617972.160.000.000.0072.16
Ye, Edwin,183344698.760.003578.270.001120.49
Schmidt, Monica,1201273.960.000.008.9964.97
Nelson, Natalie, C,2292858.980.000.000.0058.98
Nath, Tasha, J,184876021.620.003578.272443.350.00
Gill, Hector, M,261871932.460.000.00782.991149.47
Torres, Kari,184866021.620.003578.272443.350.00
Yuan, Christine,110466616.813374.990.000.003241.82
Vazquez, Kristi,2834939.980.000.000.0039.98
Dominguez, Jimmy,219594702.390.002181.560.002520.83
Yang, Stacey,142155665.890.000.002049.103616.79
Jenkins, Noah, A,2437913.980.000.000.0013.98
Zhang, James,1468438.550.000.000.0038.55
Liu, Trisha, V,202145304.250.003578.270.001725.98
Andersen, Jaime,2526860.470.000.000.0060.47
Perez, Brenda,118998189.500.003374.992395.452419.06
Li, Dawn, B,1396240.220.000.0040.220.00
Shan, Dylan,1967758.980.000.000.0058.98
Kumar, Jenny, C,234293936.540.000.002181.561754.98
Romero, Paula, B,166914471.743578.270.00893.470.00
Srini, Carolyn, S,273711350.750.000.00782.99567.76
Prasad, Francisco,16628187.580.000.000.00187.58
Ferrier, Jaclyn, D,172994382.753578.270.000.00804.48
Huang, Wesley,2932023.970.000.000.0023.97
Munoz, Anne,1579898.960.000.000.0098.96
Smith, Christian, L,14313222.440.000.000.00222.44
Kumar, Lacey,139606871.740.000.002071.424800.32
Xu, Wesley, K,29182539.990.000.000.00539.99
Griffin, Caroline,177264721.730.003578.270.001143.46
Blanco, Mallory,219584696.490.002181.560.002514.93
Van, Brett,26166128.970.000.000.00128.97
Coleman, Brittany,1557934.980.000.0034.980.00
Gomez, Arthur,249172179.910.000.001000.441179.47
Sanz, Arthur,27688166.280.000.00166.280.00
Collins, Rebecca, M,261531957.470.00782.990.001174.48
Carlson, Lance, E,228564.990.000.000.004.99
Rana, Evelyn, D,18262142.450.000.000.00142.45
Yang, Colin, J,206126060.500.003578.270.002482.23
Griffin, Olivia,2120839.980.000.000.0039.98
Gutierrez, Micheal, S,272991322.980.000.00782.99539.99
Jiménez, Deanna,28115562.960.000.00562.960.00
Madan, Geoffrey, M,1524151.910.000.000.0051.91
Xu, Julie,183016056.610.003578.272478.340.00
He, Eugene, L,136456817.120.000.002049.104768.02
Serrano, Tabitha,283272407.040.000.002407.040.00
Kumar, Tamara, A,252222120.930.000.001000.441120.49
Hernandez, Mathew, A,151844441.380.000.002071.422369.96
Vazquez, Bruce, P,2041767.970.000.000.0067.97
Jordan, Ross, F,111248129.020.003399.992309.972419.06
Subram, Adriana,2342429.480.000.000.0029.48
Williams, Nicholas, A,2580921.490.000.000.0021.49
Moreno, Krista, J,167456021.623578.270.002443.350.00
Yang, Warren, F,1790835.720.000.0035.720.00
Ye, Franklin, L,1395282.260.000.000.0082.26
Zeng, Marshall, M,209874132.240.003578.270.00553.97
Muñoz, Jaime, C,245063563.840.000.002443.351120.49
Chander, Shawn, S,202165338.740.003578.270.001760.47
Liu, Clayton, L,2137315.230.000.0015.230.00
Flores, Noah,172564362.740.003578.270.00784.47
Russell, Ashley,120008183.000.003399.990.004783.01
Vance, Kristi, T,2833847.970.000.000.0047.97
Serrano, Dana, S,12678341.430.000.0089.46251.97
Nath, Rafael,235333917.540.000.002181.561735.98
Chandra, Rebekah,28486776.330.000.000.00776.33
Gonzalez, Dominique, J,2797658.980.000.000.0058.98
Ashe, Joanna, F,209972744.520.002181.560.00562.96
Perez, Carmen, C,131396854.450.000.002071.424783.03
Lopez, Savannah,257091308.060.00699.100.00608.96
Jai, Dylan, J,2312839.980.000.000.0039.98
West, James, M,1514890.750.000.0059.4831.27
Mehta, Pamela,22005135.460.000.000.00135.46
Andersen, Rafael, E,12691247.460.000.000.00247.46
Fernandez, Candace,111058095.990.003399.992294.992401.01
Huang, Dawn, E,119434734.290.003374.99539.99819.31
Zimmerman, Krystal,1722877.270.000.000.0077.27
Henderson, Angela, T,118988179.030.003399.992394.972384.07
Gutierrez, Carrie, C,28139127.280.000.000.00127.28
Nara, Lindsay, M,252474.990.000.000.004.99
Martin, Byron, E,2521739.980.000.000.0039.98
Carlson, Frank,118968117.970.003374.992341.972401.01
Huang, Jorge,1729186.270.000.0053.9932.28
Serrano, Deanna, W,151444344.090.000.002049.102294.99
Liang, Omar,2424517.270.000.000.0017.27
Shan, Bridget,2933839.980.000.000.0039.98
Liu, Erica, A,2156474.980.000.000.0074.98
Jackson, Eduardo, C,1174939.970.000.000.0039.97
Weber, Jay, A,2524421.930.000.0021.930.00
Ma, Cara,18885110.460.000.00110.460.00
Serrano, Tyrone,113605025.800.003399.990.001625.81
Raje, Shawn,1705483.980.000.000.0083.98
Chande, Raul, L,2117635.000.000.0035.000.00
Zhou, Rafael, A,244949.990.000.009.990.00
Sun, Jamie,213892770.520.002181.560.00588.96
Chander, Edwin, T,173704742.740.003578.270.001164.47
Hayes, Alexis,13048190.230.000.000.00190.23
Shan, Darrell, J,2734569.990.000.000.0069.99
Perez, Marie,1399666.260.000.000.0066.26
Huang, Arturo,289522473.040.000.002473.040.00
Murphy, Seth, A,257041239.090.00699.100.00539.99
Ramos, Rodney, C,14059106.750.000.0074.4832.27
Navarro, Lori,2118232.280.000.000.0032.28
Rodriguez, Jonathan, J,1304664.970.000.0029.9834.99
Edwards, Carlos,16680104.860.000.000.00104.86
Martin, Jay,1959733.980.000.000.0033.98
Sullivan, Henry, L,2060323.780.000.000.0023.78
Coleman, Jocelyn,206066054.220.003578.270.002475.95
West, Nathan,2437067.930.000.000.0067.93
James, Evan, V,1111985.220.000.0035.2349.99
Suarez, Carolyn, B,182226044.590.003578.272466.320.00
Chande, Katrina, L,199686021.620.003578.270.002443.35
Munoz, Robyn,142145759.870.000.002049.103710.77
Vazquez, Carolyn,2365039.980.000.000.0039.98
Rubio, Monique, M,291017.280.000.000.007.28
Powell, Rachel,208184230.730.003578.27652.460.00
Shan, Gregory,206146035.600.003578.270.002457.33
Alvarez, Randall,267501938.470.000.00782.991155.48
Chen, Jaclyn, C,2284737.290.000.000.0037.29
Kumar, Tony, P,197836021.620.003578.270.002443.35
Malhotra, Darren, L,202456085.590.003578.270.002507.32
Pal, Mohamed, D,126986786.750.002071.420.004715.33
Sanchez, Marie,2292490.950.000.0090.950.00
Travers, Jimmy, V,126746829.470.002071.420.004758.05
Lin, Jorge,2759313.980.000.000.0013.98
Gill, Orlando,2136093.970.000.000.0093.97
Sanchez, Cynthia, S,236623917.540.000.002181.561735.98
Prasad, George, C,157674379.090.000.002049.102329.99
Gutierrez, Frank, G,2284674.980.000.0074.980.00
Garcia, Chelsea,2196142.280.000.0042.280.00
Ye, Damien, M,136206848.070.000.002049.104798.97
Yuan, Terry, R,136466843.600.000.002049.104794.50
Long, Isabelle, W,231043490.030.000.003490.030.00
Yang, Colleen,22167123.980.000.00123.980.00
Guo, Glenn, J,1871224.270.000.0021.982.29
Zheng, Claudia,186916070.590.003578.272492.320.00
Patterson, Jennifer, M,151295177.730.000.002071.423106.31
Serrano, Mallory, E,267511903.480.000.00782.991120.49
Suarez, Natasha,1467937.970.000.000.0037.97
Tang, Latoya, F,229103882.550.000.002181.561700.99
She, Susan,199566060.500.003578.270.002482.23
Martinez, Manuel, J,158322611.410.000.002071.42539.99
Sanz, Bruce,231173931.520.000.002181.561749.96
Huang, Eugene, L,110016383.883374.990.002419.93588.96
Raji, Misty,165204727.743578.270.000.001149.47
Murphy, Grace, J,236554144.340.000.002443.351700.99
Ye, Alejandro, W,150293826.400.000.002071.421754.98
Zhou, Warren,197916058.210.003578.270.002479.94
Flores, Adam, L,110446515.303374.990.000.003140.31
Subram, Joe,136316817.120.000.002049.104768.02
Rubio, Juan,1617032.280.000.000.0032.28
He, Gilbert,155894416.380.000.002071.422344.96
Chande, Mindy, V,274721345.950.000.00782.99562.96
Nath, Bethany,16177133.340.000.000.00133.34

Generated 2025-11-01 21:36:09.711 UTC