[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 1000 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Luo, Casey,11072 | 8194.00 | 3399.99 | 0.00 | 2395.96 | 2398.05 |
| Gao, Rosa,26034 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| She, Kathryn, I,26443 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| She, Glenn, L,29117 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Blanco, Lee, M,16660 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Clark, Joshua, A,26137 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Diaz, Kellie, A,18330 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Ye, Lacey,29090 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Goel, Shawna, L,29332 | 165.28 | 0.00 | 0.00 | 165.28 | 0.00 |
| Lu, Candice, I,21204 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Gill, Theodore,11149 | 41.26 | 0.00 | 0.00 | 0.00 | 41.26 |
| Rai, Alejandro, R,21990 | 99.47 | 0.00 | 0.00 | 99.47 | 0.00 |
| Evans, Xavier,19098 | 122.24 | 0.00 | 0.00 | 0.00 | 122.24 |
| Peterson, Lucas,17298 | 174.45 | 0.00 | 0.00 | 0.00 | 174.45 |
| Ortega, Jessie, J,17051 | 6060.50 | 3578.27 | 0.00 | 2482.23 | 0.00 |
| Chander, Maurice, L,14086 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Anand, Lacey, J,27150 | 201.28 | 0.00 | 0.00 | 0.00 | 201.28 |
| Alvarez, Pedro, E,28120 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Hall, Jesse,26133 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Shan, Bethany, L,13973 | 5185.68 | 0.00 | 0.00 | 2835.70 | 2349.98 |
| Ortega, Briana, L,29346 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Hill, Aaron,25818 | 35.96 | 0.00 | 0.00 | 35.96 | 0.00 |
| Vazquez, Rebekah, A,15784 | 4379.09 | 0.00 | 0.00 | 2049.10 | 2329.99 |
| Lal, Terry,18277 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Moreno, Pedro, A,18248 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Munoz, Marvin,14680 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Sara, Ann, A,23576 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jenkins, Anna, M,17234 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Xu, Jaclyn, L,12685 | 6904.11 | 0.00 | 2049.10 | 2416.95 | 2438.06 |
| Johnson, Morgan, E,12011 | 4735.81 | 0.00 | 3374.99 | 618.47 | 742.35 |
| Andersen, Tara, L,24465 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Carter, Amber, E,16679 | 106.56 | 0.00 | 0.00 | 106.56 | 0.00 |
| Torres, Mathew, L,18900 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Andersen, Deborah,19610 | 118.94 | 0.00 | 0.00 | 68.97 | 49.97 |
| Raman, Meagan, J,15134 | 5151.71 | 0.00 | 0.00 | 2071.42 | 3080.29 |
| Guo, Lisa, S,17314 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Subram, Douglas,27352 | 1357.97 | 0.00 | 0.00 | 782.99 | 574.98 |
| Lal, Darrell,19953 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Dominguez, Roy, C,29189 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Raji, Derek, D,19591 | 63.42 | 0.00 | 0.00 | 41.93 | 21.49 |
| Xie, Chad, A,26155 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Carlson, Joy,13981 | 124.21 | 0.00 | 0.00 | 88.98 | 35.23 |
| Martin, Byron, E,25217 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Ms., Robinson, Rebecca, A.,11913 | 41.26 | 0.00 | 0.00 | 0.00 | 41.26 |
| She, Colleen, E,29312 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Vance, Toni, L,23438 | 123.48 | 0.00 | 0.00 | 0.00 | 123.48 |
| Kumar, Katie, P,12341 | 6840.62 | 0.00 | 2049.10 | 2294.99 | 2496.53 |
| Hernandez, Ebony, S,23574 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Raji, Omar,15643 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Sai, Cesar,18243 | 6058.21 | 3578.27 | 0.00 | 2479.94 | 0.00 |
| Gao, Jamie,26022 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Munoz, Cheryl, C,13632 | 6838.46 | 0.00 | 0.00 | 2071.42 | 4767.04 |
| Luo, Mario, L,25711 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Young, Marcus, A,18494 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Davis, Nicole,22957 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Munoz, Natasha, M,24601 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Alonso, Jerome, H,27977 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Shen, Kelsey, R,22921 | 4647.88 | 0.00 | 0.00 | 2181.56 | 2466.32 |
| Chander, Melvin, L,24266 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Lu, Alan,19761 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Foster, Luke,15137 | 161.94 | 0.00 | 0.00 | 161.94 | 0.00 |
| Zheng, Laura,16701 | 4426.74 | 3578.27 | 0.00 | 848.47 | 0.00 |
| Raji, Donna,24906 | 61.96 | 0.00 | 0.00 | 61.96 | 0.00 |
| Deng, April,11117 | 8184.99 | 3399.99 | 0.00 | 2365.94 | 2419.06 |
| Gill, Sheila, B,17375 | 24.49 | 0.00 | 0.00 | 24.49 | 0.00 |
| Nath, Dale, B,27343 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Ye, Willie,22963 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Serrano, Javier, R,20256 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Cai, Bianca, D,22173 | 2735.53 | 0.00 | 2181.56 | 553.97 | 0.00 |
| Chavez, Jodi, A,18909 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Harrison, Colleen, L,20219 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Jai, Brendan,26755 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Martinez, Sarah, S,12670 | 6785.13 | 0.00 | 2049.10 | 2351.96 | 2384.07 |
| Srini, Beth, A,25913 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Martinez, Troy, L,20823 | 4216.75 | 0.00 | 3578.27 | 638.48 | 0.00 |
| Alexander, Elizabeth,13089 | 6800.45 | 0.00 | 0.00 | 2071.42 | 4729.03 |
| Chandra, Ann,18209 | 6056.61 | 3578.27 | 0.00 | 2478.34 | 0.00 |
| Kumar, Bridget,15802 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Nara, Dawn, M,21891 | 4921.69 | 0.00 | 2443.35 | 0.00 | 2478.34 |
| Huang, Valerie, J,26745 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Becker, Latoya, W,17330 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Ruiz, Carolyn, M,27863 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Powell, Amanda,28113 | 901.35 | 0.00 | 0.00 | 901.35 | 0.00 |
| Raje, Jenny,20233 | 69.97 | 0.00 | 0.00 | 69.97 | 0.00 |
| Hill, Adam,18740 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Huang, Omar, C,14232 | 77.27 | 0.00 | 0.00 | 49.99 | 27.28 |
| Kumar, Cristina, N,15426 | 115.92 | 0.00 | 0.00 | 106.93 | 8.99 |
| Zheng, Dawn, F,19579 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Martinez, Cynthia,22170 | 2745.33 | 0.00 | 2181.56 | 563.77 | 0.00 |
| Martinez, Clifford,23087 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Blanco, Philip, M,15603 | 39.97 | 0.00 | 0.00 | 24.99 | 14.98 |
| Raje, Misty, A,23544 | 3971.01 | 0.00 | 0.00 | 2181.56 | 1789.45 |
| She, Jessie, A,13650 | 6768.14 | 0.00 | 0.00 | 2049.10 | 4719.04 |
| Ms., Sandidge, Mary, R.,14016 | 121.06 | 0.00 | 0.00 | 0.00 | 121.06 |
| Suri, Troy, M,12251 | 3924.97 | 0.00 | 3374.99 | 0.00 | 549.98 |
| Flores, Antonio, D,14259 | 3630.93 | 0.00 | 0.00 | 2888.58 | 742.35 |
| Pal, Roger, D,27705 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Prasad, Brett, A,20262 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Lal, Sheena,23312 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Rana, Raymond,25115 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Ramos, Byron,14306 | 3653.23 | 0.00 | 0.00 | 2910.88 | 742.35 |
| Ortega, Monique, C,12355 | 6818.11 | 0.00 | 2049.10 | 2350.96 | 2418.05 |
| Chavez, Karla, K,16704 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Luo, Nina,27495 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Browning, Janet,19979 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Suri, Stanley, J,27496 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Blanco, Erik, J,29093 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Malhotra, Meredith,29314 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| White, Ashley, D,21887 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Zhao, Jamie,16179 | 72.16 | 0.00 | 0.00 | 0.00 | 72.16 |
| Chandra, Jarrod,24171 | 3006.31 | 0.00 | 0.00 | 2443.35 | 562.96 |
| Goel, Yolanda, M,26435 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Perez, Rachael, D,26762 | 133.49 | 0.00 | 0.00 | 133.49 | 0.00 |
| Zhu, Roger, J,28098 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| She, Jenny,27586 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Gonzalez, Ruth,12693 | 6820.47 | 0.00 | 2071.42 | 0.00 | 4749.05 |
| Yuan, Melvin,29331 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Ye, Tamara, A,20243 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Shen, Priscilla, A,28215 | 589.96 | 0.00 | 0.00 | 589.96 | 0.00 |
| Malhotra, Janelle,26425 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Rai, Brad, S,18490 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Stewart, Ariana,16743 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Torres, Meghan, I,21256 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
| Shen, Bridget,17237 | 62.98 | 0.00 | 0.00 | 62.98 | 0.00 |
Generated 2024-09-20 03:42:20.733 UTC