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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Garcia, Edgar, A,17729110.460.000.00110.460.00
Xu, Glenn,1874367.210.000.0056.9710.24
Adams, Sydney,2736769.990.000.000.0069.99
Goel, Roger, A,236523907.540.000.002181.561725.98
Goldstein, Dustin,123378137.010.003399.992343.962393.06
Sun, Lacey, L,1513181.260.000.000.0081.26
Cooper, Katherine, R,14314122.950.000.000.00122.95
Peterson, Lucas,17298174.450.000.000.00174.45
Raman, Arthur,240012983.340.000.002443.35539.99
Lal, Shawna,179244733.753578.270.000.001155.48
Vazquez, Daisy, L,255601288.06699.100.000.00588.96
Garcia, Andre, H,127056854.110.002049.100.004805.01
Zhu, Dawn,266611912.470.000.00782.991129.48
Rodriguez, Arthur,154383788.680.000.002071.421717.26
Kumar, Misty, H,250101540.430.000.001000.44539.99
Alexander, Olivia, L,146675295.410.000.002049.103246.31
Li, Marshall,126876805.470.002071.422349.982384.07
Zhu, Gilbert,1192163.240.000.000.0063.24
Ward, Brooke,130075671.240.002071.420.003599.82
Hall, Jesse,261331938.470.00782.990.001155.48
Goel, Christine, A,212313936.540.002181.560.001754.98
Rubio, Jay,151794444.890.000.002071.422373.47
She, Cedric, R,125802589.090.002049.100.00539.99
Ma, Dawn, A,1395682.260.000.000.0082.26
Kapoor, Kaitlin, M,17072123.960.000.000.00123.96
Hernandez, Kristine,142865234.400.000.002859.422374.98
Becker, Jenny,1729092.970.000.0029.9962.98
Hall, Mary, R,202774.990.000.004.990.00
Yang, Jon, V,110008248.993399.990.004849.000.00
Ashe, Barbara,1873424.270.000.0021.982.29
Zheng, Erica, K,236434.990.000.004.990.00
Torres, Meghan, I,212563917.540.002181.560.001735.98
Perez, Kevin, M,255651239.090.00699.100.00539.99
Rai, Brendan, A,215694960.160.002443.350.002516.81
Raji, Terry,155974391.410.000.002071.422319.99
Martin, Ethan, M,13998245.250.000.0097.97147.28
Zhao, Rosa, A,1967274.980.000.000.0074.98
Rai, Colleen,2893329.480.000.000.0029.48
Hu, Jenny, A,16634106.560.000.000.00106.56
Wood, Jacqueline,1670597.960.000.000.0097.96
Gonzalez, Tabitha, A,2613639.980.000.000.0039.98
Hill, Noah,261921903.480.00782.990.001120.49
Miller, Edward,113685106.240.003374.990.001731.25
Allen, Alexandra, B,172934417.753578.270.000.00839.48
Alexander, David,1578398.960.000.000.0098.96
Pal, Clayton,27721166.280.000.000.00166.28
Garcia, Brandy,260281938.470.00782.990.001155.48
Chander, Latoya, C,261381957.470.00782.990.001174.48
Zeng, Micah, A,255611288.06699.100.000.00588.96
Ramos, Jerome, L,29187588.960.000.000.00588.96
Shan, Shawna, K,278692462.550.000.000.002462.55
Navarro, Tyrone, K,255571262.87699.100.000.00563.77
Rai, Clarence, D,110186533.283399.990.002341.97791.32
Rai, Nina,1401863.870.000.000.0063.87
Alvarez, Kristy,155884486.070.000.002049.102436.97
Ashe, Orlando, I,118978203.020.003399.992329.982473.05
Gill, Sheila, B,1737524.490.000.0024.490.00
Gray, Morgan,28307561.480.000.00561.480.00
Perez, Stefanie,27518123.980.000.00123.980.00
Zhang, Clarence, M,130016799.430.002049.102332.282418.05
Morgan, Jared, A,2821339.980.000.000.0039.98
Rubio, Desiree, D,211894208.310.002443.350.001764.96
Chander, Kelvin, E,278791313.340.000.000.001313.34
Pal, Nichole, J,2674169.990.000.000.0069.99
Nara, Karl,15142138.460.000.000.00138.46
Zeng, Stacey, J,17317128.950.000.000.00128.95
Raji, Omar,156433807.400.000.002071.421735.98
Beck, Alejandro,110256576.803374.990.002405.47796.34
Anand, Leonard,143163797.370.000.002049.101748.27
Hernandez, Monique, J,15138123.450.000.0034.9988.46
Black, Peter, E,2121364.260.000.000.0064.26
Goel, Tonya,2912323.970.000.000.0023.97
Sharma, Bonnie, R,255621239.09699.100.000.00539.99
Martin, Joe,146685216.690.000.002071.423145.27
Kumar, Kenneth,114728165.820.003399.992322.282443.55
Yang, Rosa,18713237.260.000.000.00237.26
Zhu, Christy,110038139.293399.990.004739.300.00
Raji, Misty,165204727.743578.270.001149.470.00
Gonzales, Logan,166075897.533578.270.000.002319.26
Pal, Casey,165224698.763578.270.001120.490.00
Torres, Ruben,110028114.043399.990.004714.050.00
Arun, Cory, O,165274752.753578.270.000.001174.48
Fernandez, Manuel, A,165144761.743578.270.001183.470.00
Liang, Kelvin, L,166165915.543578.270.000.002337.27
Wang, Shannon,110176434.313374.990.002316.97742.35
Huang, Damien,165244733.753578.270.001155.480.00
Zhao, Jessie, R,110276591.573399.990.000.003191.58
Zhang, Warren, L,252521893.05699.100.000.001193.95
Lal, Dustin, A,164844175.533578.270.000.00597.26
Moreno, Jimmy, L,110296565.293399.990.002408.97756.33
Ramos, Francis,163454173.243578.270.000.00594.97
She, Tonya, L,165214698.763578.270.001120.490.00
Sai, Harold,110266575.793399.990.002399.47776.33
Chander, Yolanda,165194752.753578.270.001174.480.00
Sutton, Jaime, L,166305973.243578.270.000.002394.97
Stewart, Ariana,167436070.593578.270.002492.320.00
Gao, Stacey,166624355.713578.270.00777.440.00
Gonzalez, Ebony,110346491.323399.990.000.003091.33
Romero, Lawrence, C,166876070.593578.270.002492.320.00
Lu, Suzanne, K,167124417.753578.270.00839.480.00
Zeng, Claudia, M,166964506.763578.270.00928.490.00
Romero, Renee, E,166395908.253578.270.000.002329.98
Hernandez, Diana, F,110386437.333374.990.000.003062.34
Perez, Joel,166844158.243578.270.000.00579.97
Sanchez, Denise,167036090.593578.270.002512.320.00
Zheng, Laura,167014426.743578.270.00848.470.00
Andersen, Carl, J,110578088.043374.990.002319.992393.06
Lu, Krystal,170494347.763578.270.000.00769.49
Chande, Dale, K,172424387.233578.270.000.00808.96
Diaz, Marc,110588248.023399.990.002374.982473.05
Moore, Michael,172474432.723578.270.000.00854.45
Rana, Darren, M,172574480.733578.270.000.00902.46
Sharma, Terrence, N,173516117.693578.270.000.002539.42
Luo, Dustin,172404385.033578.270.000.00806.76
Rubio, Randall, M,172866029.573578.270.000.002451.30
Sanchez, Troy, H,255591253.07699.100.000.00553.97
Flores, Noah,172564362.743578.270.000.00784.47
Torres, Dwayne, R,172884426.243578.270.000.00847.97
Luo, Casey,110728194.003399.990.002395.962398.05
Butler, Jason,175104369.743578.270.000.00791.47
Zhou, Cedric,175144142.233578.270.00563.960.00
Chander, Damien,110808204.023374.990.002359.982469.05
Navarro, Latasha, L,111008172.513374.990.002399.472398.05
Hernandez, Bruce,179194733.753578.270.000.001155.48
Goel, Drew,173526021.623578.270.000.002443.35
Williams, Anna, R,175044362.743578.270.000.00784.47
Patel, Douglas,179274726.043578.270.000.001147.77
Martin, Renee, L,174784758.243578.270.000.001179.97
Zeng, Suzanne,179184733.753578.270.000.001155.48
Raji, Willie, T,110708165.553399.990.002345.222420.34
Jimenez, Felicia, L,110758068.033374.990.002294.992398.05
Xu, Lacey, S,179134733.753578.270.000.001155.48
Griffin, Caroline,177264721.733578.270.000.001143.46
Townsend, Larry, D,111344911.833399.990.000.001511.84
Jordan, Ross, F,111248129.023399.990.002309.972419.06
Gomez, Alfredo, C,182004150.533578.270.000.00572.26
Raji, Lindsey,182056056.613578.270.002478.340.00
Kumar, Louis, A,182034172.253578.270.000.00593.98
Fernandez, Candace,111058095.990.003399.992294.992401.01
Xie, Karla,182014157.730.003578.270.00579.46
Goel, Misty, M,182456021.620.003578.270.002443.35
Chapman, Preston, O,182686102.190.003578.270.002523.92
Gonzalez, Phillip, N,182076089.590.003578.272511.320.00
Xu, Cedric,181984143.250.003578.270.00564.98
Chande, Lindsay,182446021.620.003578.272443.350.00
Martin, Larry,182546021.620.003578.272443.350.00
Gomez, Felicia, J,182196038.560.003578.272460.290.00
Moreno, Pedro, A,182486037.890.003578.272459.620.00
Moore, Natalie, W,182736104.210.003578.272525.940.00
Sanz, Ricky,182516035.600.003578.272457.330.00
Diaz, Aaron, C,186956029.570.003578.272451.300.00
Diaz, Ricky, E,183356035.600.003578.270.002457.33
Kim, Kari, S,114458098.030.003399.992304.982393.06
Griffin, Grace,114438235.000.003374.992440.952419.06
Black, Mindy, W,186966149.570.003578.272571.300.00
Prasad, Jarrod,113594960.070.003374.990.001585.08
Gonzalez, Michele, D,184916056.610.003578.272478.340.00
Patterson, Kyle,114488132.010.003374.992318.962438.06
Ye, Ramon,113574943.800.003374.990.001568.81
Nara, Sharon,184826030.610.003578.272452.340.00
Sharma, Misty,257081253.070.00699.100.00553.97
Alvarez, Gloria, B,182976119.590.003578.272541.320.00
Xie, Wayne, S,183026029.570.003578.272451.300.00
Jimenez, Gary, E,16609344.040.000.00344.040.00
Yang, Todd, J,190946021.620.003578.272443.350.00
Sanchez, Terrance,19584116.740.000.00116.740.00
Wu, Kelvin,2459561.960.000.0061.960.00
Gray, Faith,2291459.980.000.0059.980.00
Madan, Toni,26668119.980.000.00119.980.00
Ramos, Briana, J,143033636.910.000.002894.56742.35
Ramos, Joe,123536765.460.002071.422309.972384.07
Chapman, Kathryn,119888078.020.003374.992309.972393.06
Young, Marcus, A,184946037.890.003578.272459.620.00
Zheng, Claudia,186916070.590.003578.272492.320.00
Andersen, Tonya, N,135274529.040.000.002049.102479.94
Sanz, Ross,114558142.030.003374.992319.992447.05
Alvarez, Reginald, A,187466135.090.003578.272556.820.00
Chavez, Jodi, A,189096035.600.003578.272457.330.00
West, Colleen, C,131286817.140.000.002049.104768.04
Munoz, Theresa, M,139536840.750.000.002071.424769.33
Anand, Katrina, L,187265314.250.003578.271735.980.00
Rubio, Erika, A,114528183.040.003374.992414.992393.06
Ashe, Tara, J,190936035.600.003578.272457.330.00
Torres, Mathew, L,189004132.240.003578.27553.970.00
Gomez, Andy,187215333.250.003578.271754.980.00
Rodriguez, Monica, J,289519.990.000.000.009.99
Lin, Laura, L,114628116.330.003374.992322.282419.06
Zeng, Louis,189034143.740.003578.27565.470.00
She, Rosa,189316060.500.003578.272482.230.00
Patel, Monica, J,252342174.920.000.001000.441174.48
Diaz, Briana,131316737.150.000.002049.104688.05
Ma, Lacey, K,187235279.260.003578.271700.990.00
Garcia, Dalton, M,187685314.250.003578.271735.980.00
Sara, Tabitha, W,257151274.080.00699.100.00574.98
Gao, Edwin,257161302.590.00699.100.00603.49
He, Brent, R,257121262.060.00699.100.00562.96
Jimenez, Victor,114618089.040.003374.992294.992419.06
Garcia, Ruben,196136093.200.003578.270.002514.93
Saunders, Patricia, J,195655308.240.003578.270.001729.97
Martin, Randall, B,195606117.690.003578.272539.420.00
Powell, Kaitlyn,195985310.530.003578.270.001732.26
Ortega, Gloria, R,195586029.570.003578.272451.300.00
Cai, Cedric,195596056.610.003578.272478.340.00
Gutierrez, Lawrence, M,195645293.240.003578.270.001714.97
Gao, Krystal,258211879.070.00699.100.001179.97
Rana, Carla, K,195935306.540.003578.270.001728.27
She, Bridget, M,195575358.240.003578.271779.970.00
Lu, Roger, F,197634153.250.003578.27574.980.00
Torres, Sebastian, V,258311882.570.00699.100.001183.47
Martinez, Holly, B,196286035.600.003578.272457.330.00
Nath, Louis, C,258301833.570.00699.100.001134.47
Patel, Toni, E,258291894.070.00699.100.001194.97
Gonzalez, Tina,196535314.250.003578.270.001735.98
She, Nichole, M,119098105.310.003374.992297.282433.04
Mr., Spencer, Phil,199606120.110.003578.270.002541.84
Lopez, Jay, A,199656056.610.003578.270.002478.34
Carlson, Byron,119008257.010.003399.992374.982482.04
Raji, Kate, L,119038108.040.003374.992294.992438.06
Carlson, Robin,197866021.620.003578.272443.350.00
Hu, Kristen, C,197886056.610.003578.270.002478.34
Sanchez, Abby, J,199666021.620.003578.270.002443.35
Ramirez, Olivia, D,197856076.610.003578.270.002498.34
Garcia, George,201604237.220.003578.27658.950.00
Malhotra, Darren, L,202456085.590.003578.270.002507.32
Blanco, Rodney, A,201584153.250.003578.27574.980.00
Carlson, Philip, P,119158143.000.003374.992369.962398.05
Andersen, Warren,119198171.520.003374.990.004796.53
Chande, Katrina, L,199686021.620.003578.270.002443.35
Reed, Riley, A,201574118.260.003578.27539.990.00
She, Valerie, C,202266067.200.003578.270.002488.93
Mr., Rodgers, Scott, M.,202115333.250.003578.270.001754.98
Raji, Dawn, C,202446021.620.003578.270.002443.35
Yuan, Marshall, P,199786060.500.003578.270.002482.23
Harrison, Colleen, L,202196044.590.003578.270.002466.32
Sanders, Kaylee, C,202216035.600.003578.270.002457.33
Rana, Meagan, M,119148165.960.003374.992329.982460.99
Rodriguez, Rachael, M,119444776.270.003374.99609.96791.32
Xu, Randy, S,119698173.020.003399.992319.992453.04
Shan, Colin,259211253.070.00699.100.00553.97
Gill, Kristine,199776044.590.003578.270.002466.32
Carlson, Wendy,202206060.500.003578.270.002482.23
Sai, Rachael,119128095.320.003374.990.004720.33
Sullivan, Carla, A,206116021.620.003578.270.002443.35
Mehta, Evelyn, S,204204132.240.003578.27553.970.00
Perez, Johnathan, D,204264139.750.003578.27561.480.00
Suri, Jarrod, E,120048114.040.003374.992319.992419.06
Coleman, Jocelyn,206066054.220.003578.270.002475.95
Shan, Johnny,119997043.270.003399.991308.312334.97
Wang, Rosa, I,119938131.320.003374.990.004756.33
Yang, Shannon,120018113.010.003374.992318.962419.06

Generated 2024-09-19 21:47:23.043 UTC