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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Madan, Ronald,258281873.580.00699.100.001174.48
Kelly, Zoe,2312339.980.000.000.0039.98
Murphy, Alexa,182766106.600.003578.270.002528.33
Ramirez, Isaiah,119058155.980.003374.990.004780.99
Zhu, Jessie, D,1266634.560.000.000.0034.56
Raje, Louis, M,257071262.060.00699.100.00562.96
Ashe, Orlando, I,118978203.020.003399.990.004803.03
Moore, Sarah,289389.990.000.000.009.99
She, Gregory,184584733.750.003578.270.001155.48
Deng, Devon, H,199676029.570.003578.270.002451.30
Sharma, Keith,1572863.970.000.0028.9834.99
Rubio, Robyn, A,184696021.620.003578.272443.350.00
Alvarez, Stacy,119018248.010.003399.990.004848.02
Ye, Vincent,13013256.240.000.000.00256.24
Zhu, Clarence, A,184624752.750.003578.270.001174.48
Chander, Dustin,118958149.040.003374.990.004774.05
Allen, Logan,1581281.250.000.000.0081.25
Sharma, Misty,257081253.070.00699.100.00553.97
Patel, Ruben, I,197654132.240.003578.27553.970.00
Prasad, George, C,157674379.090.000.002049.102329.99
Miller, Edward,113685106.240.003374.990.001731.25
Smith, Tina, K,197936056.610.003578.270.002478.34
Raman, Cindy,161574391.410.000.002071.422319.99
Smith, Adriana,187025333.250.003578.271754.980.00
Raman, Candace, M,117668280.480.003399.992419.462461.03
Suri, Cassandra, B,1871787.210.000.000.0087.21
Navarro, Jonathon,187225333.250.003578.271754.980.00
Lopez, Jay, A,199656056.610.003578.270.002478.34
Suarez, Orlando,1112158.160.000.000.0058.16
Moreno, Latasha, R,187356021.620.003578.272443.350.00
Hu, Kristen, C,197886056.610.003578.270.002478.34
Fernandez, Tammy, A,258254.990.000.000.004.99
Arthur, Regina, A,190896093.200.003578.270.002514.93
Zheng, Jeffery, W,150303786.390.000.002071.421714.97
Zimmerman, Krystal,1722877.270.000.000.0077.27
Luo, Louis,114658158.040.003399.990.004758.05
Zhou, Autumn, L,252292155.920.000.001000.441155.48
Rivera, Steven, T,190836021.620.003578.270.002443.35
Goel, Tara, I,143472900.390.000.002071.42828.97
Sai, Francisco, W,187664752.750.003578.270.001174.48
Goel, Brad, M,29085777.340.000.000.00777.34
Lin, Laura, L,114628116.330.003374.992322.282419.06
Alonso, Ricky, S,140705618.930.000.002049.103569.83
Luo, Mario, L,257111274.080.00699.100.00574.98
Munoz, Diane, R,15795132.440.000.000.00132.44
Parker, Evan, R,187295333.250.003578.271754.980.00
Munoz, Jacquelyn,291152407.040.000.000.002407.04
Ma, Lacey, K,187235279.260.003578.271700.990.00
Simmons, Gabrielle,291832393.060.000.000.002393.06
Garcia, Dalton, M,187685314.250.003578.270.001735.98
Lin, Rafael,14099200.260.000.0027.28172.98
Madan, Brenda,13043175.930.000.000.00175.93
Kumar, Kurt, L,2736069.990.000.000.0069.99
Suarez, Randall, M,28211539.990.000.000.00539.99
Ramirez, Olivia, D,197856076.610.003578.270.002498.34
Raman, Mayra, P,209904196.220.003578.270.00617.95
Kapoor, Veronica, G,202536035.600.003578.270.002457.33
Perez, Ross, E,14307196.260.000.00159.0037.26
Malhotra, Darren, L,202456085.590.003578.270.002507.32
Shan, Keith, T,209964149.990.003578.270.00571.72
Blanco, Rodney, A,201584153.250.003578.27574.980.00
Kumar, Kenneth,114728165.820.003399.990.004765.83
Andersen, Warren,119198171.520.003374.990.004796.53
Malhotra, Brett, E,187316054.060.003578.272475.790.00
Ms., Robinson, Dorothy, B.,119528169.000.003374.992395.962398.05
Sara, Tabitha, W,257151274.080.00699.100.00574.98
Zhang, Brittney, W,199756056.610.003578.270.002478.34
Raman, Raymond, R,195886056.610.003578.270.002478.34
Gonzalez, George, L,119424792.290.003399.99614.96777.34
Liu, Alejandro, R,195556110.600.003578.270.002532.33
Kumar, Tasha, M,202495333.250.003578.270.001754.98
Ye, Claudia, J,191026029.570.003578.270.002451.30
Jimenez, Tanya, D,199706099.100.003578.270.002520.83
Ortega, Gloria, R,195586029.570.003578.270.002451.30
Romero, Sabrina, L,28534603.490.000.000.00603.49
Chander, Clarence, E,1398259.980.000.0034.9924.99
Shan, Brad, H,196055314.250.003578.270.001735.98
Hu, Amy,14320261.950.000.000.00261.95
Perez, Marie,1399666.260.000.000.0066.26
West, Colleen, C,131286817.140.000.002049.104768.04
Hu, Dennis, J,206006056.610.003578.270.002478.34
Black, Michele,1399564.970.000.000.0064.97
Nara, Clayton,117688139.040.003399.992319.992419.06
Beck, April,143025140.730.000.002071.423069.31
Ye, Marshall, R,2655938.980.000.000.0038.98
Suarez, Kristi, D,230992983.340.000.002443.35539.99
Lal, Barbara, W,231012795.010.000.002181.56613.45
Gomez, Nelson, L,2905338.980.000.000.0038.98
Rodriguez, Monica, J,289519.990.000.000.009.99
Price, Vanessa, A,2356939.980.000.000.0039.98
Serrano, Alberto, L,158004399.080.000.002049.102349.98
Navarro, Monique, R,1524073.960.000.000.0073.96
Nath, Katie, A,234343882.550.000.002181.561700.99
Munoz, Sheila,274881322.980.000.00782.99539.99
Ramos, Eddie, T,13954128.460.000.000.00128.46
Muñoz, Jaime, C,245063563.840.000.002443.351120.49
Hall, Haley,274891383.450.000.00782.99600.46
Zeng, Barbara,231022730.540.000.002181.56548.98
Russell, Seth,251382120.930.000.001000.441120.49
Travers, Alexa, A,244663337.040.000.002181.561155.48
She, Bridget, M,195575358.240.003578.270.001779.97
Gao, Wesley,123466864.460.002071.420.004793.04
Shan, Thomas, N,274831382.460.000.00782.99599.47
Carlson, Frank,118968117.970.003374.990.004742.98
Sullivan, Carla, A,206116021.620.003578.270.002443.35
Zheng, Barbara,274931353.460.000.00782.99570.47
Hill, Alex, C,197876054.220.003578.270.002475.95
Suri, Jarrod, E,120048114.040.003374.990.004739.05
Ruiz, Marie, J,274981350.750.000.00782.99567.76
Moreno, Roy, J,199516021.620.003578.270.002443.35
Zhou, Jessie,206106021.620.003578.270.002443.35
Munoz, Natasha, M,246013882.550.000.002181.561700.99
Perez, Brenda,118998189.500.003374.992395.452419.06
Goel, Alicia, H,204234177.740.003578.270.00599.47
Kumar, Barbara, N,274991331.970.000.00782.99548.98
Ramos, Jessie, R,117648129.020.003399.990.004729.03
Deng, Barbara,204456078.710.003578.270.002500.44
He, Omar,158312646.360.000.002646.360.00
Sanders, Gabriella,119068151.000.003374.992391.942384.07
Carlson, Joy,13981124.210.000.000.00124.21
Yuan, Alicia,252252129.920.000.001000.441129.48
Henderson, Angela, T,118988179.030.003399.990.004779.04
Becker, Kathryn,2458813.980.000.000.0013.98
Vazquez, Anne,160273826.400.000.002071.421754.98
Fernandez, Geoffrey,199636054.220.003578.270.002475.95
Liang, Tiffany,11068113.360.000.000.00113.36
Lal, Gabriel,274731398.460.000.00782.99615.47
Martin, Naomi, A,15593116.260.000.0088.9827.28
Anand, Bradley,1962639.460.000.000.0039.46
Moore, Olivia, A,252312189.900.000.001000.441189.46
Allen, Hailey, C,26759123.980.000.000.00123.98
Rubio, Kathleen, A,208204143.740.003578.27565.470.00
Zhang, Kristen,274841322.980.000.00782.99539.99
Martinez, Emmanuel, V,2137039.980.000.000.0039.98
Kumar, Michele,231073896.530.000.002181.561714.97
Lin, Clayton, M,274921344.910.000.00782.99561.92
Nelson, Julia, L,11102102.910.000.000.00102.91
Suri, Kaitlin, C,291902447.050.000.000.002447.05
Navarro, Eddie, C,245043563.840.000.002443.351120.49
Anand, Kelli, A,204516054.220.003578.270.002475.95
Ma, Christy,1502040.260.000.000.0040.26
Liang, Amy,161642639.080.000.002049.10589.98
Rodriguez, Jarrod,136366831.760.000.002071.424760.34
Liang, Louis, M,127066851.410.000.002071.424779.99
Ramos, Roy, A,244823882.550.000.002181.561700.99
Jai, Carly,229862756.540.000.002181.56574.98
Rodriguez, Geoffrey,208174118.260.003578.27539.990.00
Gao, Susan,274711386.480.000.00782.99603.49
Vazquez, Jimmy, D,123486906.090.002049.100.004856.99
Alonso, Meredith, M,206216117.690.003578.270.002539.42
Tang, Nina,274851354.710.000.00782.99571.72
Li, Krystal, A,249122120.930.000.001000.441120.49
Lin, Kelvin, A,130756843.940.000.002071.424772.52
Xu, Kristen,157514446.400.000.002071.422374.98
Martin, Alyssa,1958721.490.000.000.0021.49
Sullivan, Kaitlin,1691970.950.000.000.0070.95
Ashe, Brad,252282120.930.000.001000.441120.49
Jiménez, Orlando, M,21283124.940.000.000.00124.94
Morcos, Hany,208214118.260.003578.270.00539.99
Gill, Mathew, M,274861371.950.000.00782.99588.96
Ramos, Diane, L,1830064.880.000.000.0064.88
Perez, Ronald,259441274.080.00699.100.00574.98
Flores, Connor,157554404.080.000.002049.102354.98
Moreno, Tabitha,199596056.610.003578.270.002478.34
Subram, Adriana,2342429.480.000.000.0029.48
Xu, Dawn,278731249.840.000.001249.840.00
She, Susan,199566060.500.003578.270.002482.23
Vance, Meredith, B,209834178.730.003578.270.00600.46
Wu, Alisha,2365459.980.000.000.0059.98
Garcia, Sarah,119078135.330.003399.992297.282438.06
Sara, Cassandra, D,209894148.740.003578.270.00570.47
Reed, Steven,2437327.770.000.000.0027.77
Garcia, George,201604237.220.003578.27658.950.00
Kumar, Misty, H,250101540.430.000.001000.44539.99
Zhou, Colleen,2312213.980.000.000.0013.98
Rana, Joe, D,119168178.510.003374.992405.472398.05
Shen, Shaun,126846893.080.002049.100.004843.98
Sanz, Diane, M,2015313.980.000.000.0013.98
Thomas, Christopher, M,202426068.450.003578.270.002490.18
Yuan, Rafael, J,206256029.570.003578.270.002451.30
Navarro, Teresa, E,258167.280.000.000.007.28
Mehta, Cesar, J,202415347.230.003578.270.001768.96
Lal, Mario, T,233454.990.000.000.004.99
Alexander, Gail, C,14682138.450.000.000.00138.45
Zhu, Ernest,201594167.230.003578.27588.960.00
Liu, Omar, L,122523938.950.003374.990.00563.96
Moreno, Dwayne, T,2310385.480.000.000.0085.48
Raji, Dawn, C,202446021.620.003578.270.002443.35
Ms., Simon, Britta,259461873.580.00699.100.001174.48
Ortega, Renee,1844721.490.000.000.0021.49
Zhang, Louis, K,202276054.220.003578.270.002475.95
Lopez, Darren,29081742.350.000.000.00742.35
Gill, Mallory, P,16698197.880.000.000.00197.88
Patterson, Antonio, G,119638068.030.003374.992294.992398.05
Shan, Dylan,1967758.980.000.000.0058.98
Sara, Ruben, A,19566164.910.000.000.00164.91
Ortega, Jill, A,202396093.200.003578.270.002514.93
Martinez, Troy, L,208234216.750.003578.270.00638.48
Sanchez, Ross,283104.990.000.000.004.99
Suarez, Ricky,29066539.990.000.000.00539.99
Madan, Geoffrey, M,1524151.910.000.000.0051.91
Jai, Lacey, C,1137174.980.000.000.0074.98
Coleman, Jocelyn,206066054.220.003578.270.002475.95
Guo, Randy, L,2295664.470.000.000.0064.47
Xu, Peter, K,282042419.060.000.002419.060.00
Andersen, Jenny,202596029.570.003578.270.002451.30
Munoz, Casey, W,125702654.060.002049.100.00604.96
Gill, Eddie, J,1271574.540.000.0064.979.57
Garcia, Carolyn,209992735.530.002181.560.00553.97
Moreno, Larry, W,282072461.550.000.002461.550.00
Alonso, Jerome, H,27977553.970.000.000.00553.97
Diaz, Dana, C,12361217.460.000.000.00217.46
Morgan, Nathaniel, E,1662671.570.000.0036.5934.98
Lu, Ramon, B,1673844.950.000.0013.9830.97
Alonso, Krista, P,20212100.740.000.000.00100.74
Raman, Pamela, C,2736978.980.000.000.0078.98
Sara, Ann, A,2357639.980.000.000.0039.98
Mehta, Ann, M,14518126.950.000.0063.9762.98
Bailey, Savannah, J,2342839.980.000.000.0039.98
Carlson, Theresa, L,19629109.440.000.000.00109.44
Kumar, Yolanda, J,1819485.960.000.000.0085.96
Raje, Tara, F,28483765.320.000.000.00765.32
Gutierrez, Joy, A,1846653.990.000.000.0053.99
Carlson, Jonathon, N,1707378.970.000.000.0078.97
Johnston, Tamara, H,18492218.260.000.000.00218.26
Hu, Barbara,19567104.960.000.000.00104.96
Prasad, Edgar, E,17306117.960.000.0034.9982.97
Pal, Gilbert,27744643.950.000.00643.950.00
Ward, Brooke,130075671.240.000.002071.423599.82
Alan, Meghan, I,28210564.480.000.000.00564.48
Kumar, Katie, P,123416840.620.002049.100.004791.52
Powell, Grace, B,291942419.060.000.000.002419.06
Huang, Crystal, L,260231917.460.00782.990.001134.47
Navarro, Marc,1634637.550.000.000.0037.55
Chow, Amy, E,126996798.130.002049.100.004749.03
Weber, Chelsea,291912393.060.000.000.002393.06
Gutierrez, Clinton,210013018.330.002443.350.00574.98
Yang, Shannon,120018113.010.003374.990.004738.02
Ruiz, Gloria,123435567.930.002049.100.003518.83
Blanco, Marc,249082155.920.000.001000.441155.48
Chander, Alisha,125722611.410.002071.420.00539.99
Chandra, Cesar, R,202365279.260.003578.270.001700.99
Torres, Diane, M,2521179.470.000.000.0079.47
Becker, Kelsey, G,119688079.050.003399.992294.992384.07
Gomez, Sheila, J,211654673.880.002181.560.002492.32
Goel, Jodi,204476035.600.003578.270.002457.33
Arun, Nancy, C,211694647.880.002181.560.002466.32
Mehta, Evelyn, S,204204132.240.003578.27553.970.00
Li, Jack, J,140715617.920.000.002049.103568.82
Sharma, Donna,119986962.100.003374.991249.842337.27

Generated 2024-11-10 03:10:46.686 UTC