[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Jimenez, Gary, E,16609 | 344.04 | 0.00 | 0.00 | 344.04 | 0.00 |
| Andersen, Tonya, N,13527 | 4529.04 | 0.00 | 0.00 | 2049.10 | 2479.94 |
| Sharma, Terrence, N,17351 | 6117.69 | 3578.27 | 0.00 | 0.00 | 2539.42 |
| Yang, Todd, J,19094 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 0.00 | 2049.10 | 4768.04 |
| Munoz, Theresa, M,13953 | 6840.75 | 0.00 | 0.00 | 2071.42 | 4769.33 |
| Sanchez, Terrance,19584 | 116.74 | 0.00 | 0.00 | 116.74 | 0.00 |
| Wu, Kelvin,24595 | 61.96 | 0.00 | 0.00 | 61.96 | 0.00 |
| Gray, Faith,22914 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Madan, Toni,26668 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| Rodriguez, Monica, J,28951 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Ramos, Briana, J,14303 | 3636.91 | 0.00 | 0.00 | 2894.56 | 742.35 |
| Ramos, Joe,12353 | 6765.46 | 0.00 | 2071.42 | 2309.97 | 2384.07 |
| Patel, Monica, J,25234 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Diaz, Briana,13131 | 6737.15 | 0.00 | 0.00 | 2049.10 | 4688.05 |
| Chapman, Kathryn,11988 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Zhu, Christy,11003 | 8139.29 | 3399.99 | 0.00 | 4739.30 | 0.00 |
| Raji, Michele,15183 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Henderson, Xavier, K,12993 | 96.25 | 0.00 | 0.00 | 39.98 | 56.27 |
| Liu, Autumn, J,20985 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Zheng, Aimee, H,24283 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Raji, Misty,16520 | 4727.74 | 3578.27 | 0.00 | 1149.47 | 0.00 |
| Gonzales, Logan,16607 | 5897.53 | 3578.27 | 0.00 | 0.00 | 2319.26 |
| Nelson, Julia, L,11102 | 102.91 | 0.00 | 0.00 | 0.00 | 102.91 |
| Zheng, Jeffery, W,15030 | 3786.39 | 0.00 | 0.00 | 2071.42 | 1714.97 |
| Pal, Casey,16522 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 4714.05 | 0.00 |
| Arun, Cory, O,16527 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Clark, Sydney,16610 | 67.58 | 0.00 | 0.00 | 67.58 | 0.00 |
| Fernandez, Manuel, A,16514 | 4761.74 | 3578.27 | 0.00 | 1183.47 | 0.00 |
| Li, Crystal, L,14325 | 5152.70 | 0.00 | 0.00 | 2049.10 | 3103.60 |
| Liang, Kelvin, L,16616 | 5915.54 | 3578.27 | 0.00 | 0.00 | 2337.27 |
| Ruiz, Bruce, W,16171 | 103.86 | 0.00 | 0.00 | 103.86 | 0.00 |
| Wang, Shannon,11017 | 6434.31 | 3374.99 | 0.00 | 2316.97 | 742.35 |
| Lal, Karla,25219 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Liang, Louis, M,12706 | 6851.41 | 0.00 | 2071.42 | 0.00 | 4779.99 |
| Huang, Damien,16524 | 4733.75 | 3578.27 | 0.00 | 1155.48 | 0.00 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Hu, Krystal, D,13012 | 7017.44 | 0.00 | 2071.42 | 2493.98 | 2452.04 |
| Coleman, Melanie, H,15639 | 34.57 | 0.00 | 0.00 | 2.29 | 32.28 |
| Zhang, Warren, L,25252 | 1893.05 | 699.10 | 0.00 | 0.00 | 1193.95 |
| Jimenez, Jacquelyn,14304 | 3595.93 | 0.00 | 0.00 | 2818.59 | 777.34 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 2408.97 | 756.33 |
| Ramos, Francis,16345 | 4173.24 | 3578.27 | 0.00 | 0.00 | 594.97 |
| She, Tonya, L,16521 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Cai, Cedric,19559 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Zeng, Ernest, M,12992 | 158.51 | 0.00 | 0.00 | 36.27 | 122.24 |
| Yuan, Cassie, J,24453 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Sai, Harold,11026 | 6575.79 | 3399.99 | 0.00 | 2399.47 | 776.33 |
| Martinez, Manuel, J,15832 | 2611.41 | 0.00 | 0.00 | 2611.41 | 0.00 |
| Ward, Jessica,15587 | 4423.38 | 0.00 | 0.00 | 2071.42 | 2351.96 |
| Chander, Yolanda,16519 | 4752.75 | 3578.27 | 0.00 | 1174.48 | 0.00 |
| Ma, Cedric, W,11094 | 157.93 | 0.00 | 0.00 | 29.98 | 127.95 |
| Sutton, Jaime, L,16630 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Stewart, Ariana,16743 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Gao, Stacey,16662 | 4355.71 | 3578.27 | 0.00 | 777.44 | 0.00 |
| Suarez, Ricky,29066 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Shen, Shaun,12684 | 6893.08 | 0.00 | 2049.10 | 0.00 | 4843.98 |
| Gonzalez, Ebony,11034 | 6491.32 | 3399.99 | 0.00 | 0.00 | 3091.33 |
| Shen, Nichole,12999 | 6840.46 | 0.00 | 2071.42 | 0.00 | 4769.04 |
| Hu, Amy,14320 | 261.95 | 0.00 | 0.00 | 0.00 | 261.95 |
| Romero, Lawrence, C,16687 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Cai, Susan,19101 | 104.42 | 0.00 | 0.00 | 0.00 | 104.42 |
| Lu, Suzanne, K,16712 | 4417.75 | 3578.27 | 0.00 | 839.48 | 0.00 |
| Zeng, Claudia, M,16696 | 4506.76 | 3578.27 | 0.00 | 928.49 | 0.00 |
| Romero, Renee, E,16639 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Hernandez, Diana, F,11038 | 6437.33 | 3374.99 | 0.00 | 0.00 | 3062.34 |
| Perez, Joel,16684 | 4158.24 | 3578.27 | 0.00 | 0.00 | 579.97 |
| Beck, April,14302 | 5140.73 | 0.00 | 0.00 | 2071.42 | 3069.31 |
| Lal, Barbara, W,23101 | 2795.01 | 0.00 | 0.00 | 2181.56 | 613.45 |
| Sanchez, Denise,16703 | 6090.59 | 3578.27 | 0.00 | 2512.32 | 0.00 |
| Jackson, Eduardo, C,11749 | 39.97 | 0.00 | 0.00 | 39.97 | 0.00 |
| Zheng, Laura,16701 | 4426.74 | 3578.27 | 0.00 | 848.47 | 0.00 |
| Xu, Clarence,21877 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Jackson, Joshua,17235 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Morris, Eduardo,19619 | 112.75 | 0.00 | 0.00 | 88.97 | 23.78 |
| Gill, Roy,29465 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 1283.82 | 2339.97 |
| Chow, Amy, E,12699 | 6798.13 | 0.00 | 2049.10 | 0.00 | 4749.03 |
| Andersen, Carl, J,11057 | 8088.04 | 3374.99 | 0.00 | 2319.99 | 2393.06 |
| Coleman, Jocelyn,20606 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Lu, Krystal,17049 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Dominguez, Kristi, M,13644 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Lopez, Adriana, A,12002 | 8145.33 | 0.00 | 3374.99 | 2357.28 | 2413.06 |
| Chande, Dale, K,17242 | 4387.23 | 3578.27 | 0.00 | 0.00 | 808.96 |
| Diaz, Marc,11058 | 8248.02 | 3399.99 | 0.00 | 2374.98 | 2473.05 |
| Moore, Michael,17247 | 4432.72 | 3578.27 | 0.00 | 0.00 | 854.45 |
| Sanz, Reginald, K,17522 | 74.95 | 0.00 | 0.00 | 0.00 | 74.95 |
| Gao, Cara, B,15642 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Chapman, Patricia,12037 | 7107.10 | 0.00 | 3374.99 | 1249.84 | 2482.27 |
| Rana, Darren, M,17257 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Sanz, Larry,14067 | 114.96 | 0.00 | 0.00 | 49.99 | 64.97 |
| Huang, Jake,19589 | 95.26 | 0.00 | 0.00 | 62.98 | 32.28 |
| Raman, Mayra, P,20990 | 4196.22 | 0.00 | 3578.27 | 617.95 | 0.00 |
| Luo, Dustin,17240 | 4385.03 | 3578.27 | 0.00 | 0.00 | 806.76 |
| Jai, Clayton,12339 | 6865.46 | 0.00 | 2071.42 | 2374.98 | 2419.06 |
| Rubio, Randall, M,17286 | 6029.57 | 3578.27 | 0.00 | 0.00 | 2451.30 |
| Sanchez, Troy, H,25559 | 1253.07 | 699.10 | 0.00 | 0.00 | 553.97 |
| Flores, Noah,17256 | 4362.74 | 3578.27 | 0.00 | 0.00 | 784.47 |
| Ortega, Lawrence,14685 | 146.74 | 0.00 | 0.00 | 0.00 | 146.74 |
| Torres, Dwayne, R,17288 | 4426.24 | 3578.27 | 0.00 | 0.00 | 847.97 |
| Moreno, Deanna,28941 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Malhotra, Darren, L,20245 | 6085.59 | 0.00 | 3578.27 | 0.00 | 2507.32 |
| Luo, Casey,11072 | 8194.00 | 3399.99 | 0.00 | 2395.96 | 2398.05 |
| Shan, Keith, T,20996 | 4149.99 | 0.00 | 3578.27 | 571.72 | 0.00 |
| Xu, Arturo,13619 | 6808.10 | 0.00 | 0.00 | 2049.10 | 4759.00 |
| Butler, Jason,17510 | 4369.74 | 3578.27 | 0.00 | 0.00 | 791.47 |
| Jimenez, Victor,11461 | 8089.04 | 0.00 | 3374.99 | 2294.99 | 2419.06 |
| Arun, Troy, P,15221 | 4447.87 | 0.00 | 0.00 | 2071.42 | 2376.45 |
| Zhou, Cedric,17514 | 4142.23 | 3578.27 | 0.00 | 563.96 | 0.00 |
| Chander, Damien,11080 | 8204.02 | 3374.99 | 0.00 | 2359.98 | 2469.05 |
| Alonso, Ricky, S,14070 | 5618.93 | 0.00 | 0.00 | 3298.94 | 2319.99 |
| Ruiz, Danny,24456 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Munoz, Diane, R,15795 | 132.44 | 0.00 | 0.00 | 132.44 | 0.00 |
| Raje, Casey, A,14686 | 203.46 | 0.00 | 0.00 | 59.98 | 143.48 |
| Zhu, Jamie, J,13140 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Navarro, Latasha, L,11100 | 8172.51 | 3374.99 | 0.00 | 2399.47 | 2398.05 |
| Smith, Allen,14072 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Henderson, Marcus, D,15212 | 68.96 | 0.00 | 0.00 | 4.99 | 63.97 |
| Ma, Christy,15020 | 40.26 | 0.00 | 0.00 | 0.00 | 40.26 |
| He, Jorge,20268 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Hernandez, Bruce,17919 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Goel, Drew,17352 | 6021.62 | 3578.27 | 0.00 | 0.00 | 2443.35 |
| Williams, Anna, R,17504 | 4362.74 | 3578.27 | 0.00 | 0.00 | 784.47 |
Generated 2024-09-19 21:54:36.207 UTC