[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Chander, Cassie, M,18258 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Patel, Gerald,23095 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bailey, Melissa, C,19572 | 82.25 | 0.00 | 0.00 | 23.78 | 58.47 |
| Martin, Lance,25236 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nara, Karla, C,25827 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Young, Morgan, L,12342 | 6838.12 | 0.00 | 2049.10 | 2369.96 | 2419.06 |
| Raman, Johnathan,19103 | 63.91 | 0.00 | 0.00 | 41.93 | 21.98 |
| Martin, Naomi, A,15593 | 116.26 | 0.00 | 0.00 | 88.98 | 27.28 |
| Powell, Alexis, M,23531 | 3337.28 | 0.00 | 0.00 | 3337.28 | 0.00 |
| Harris, Ian, W,14128 | 3836.38 | 0.00 | 0.00 | 3836.38 | 0.00 |
| He, Omar,15831 | 2646.36 | 0.00 | 0.00 | 2646.36 | 0.00 |
| Sai, Terrance,19106 | 64.95 | 0.00 | 0.00 | 21.98 | 42.97 |
| Raji, Tammy, K,17071 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Simmons, Jacqueline, W,13137 | 177.94 | 0.00 | 0.00 | 112.97 | 64.97 |
| Brown, Cameron, D,13041 | 153.95 | 0.00 | 0.00 | 88.98 | 64.97 |
| Li, Jenny, B,22169 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Nara, Rafael, J,17052 | 96.92 | 0.00 | 0.00 | 42.93 | 53.99 |
| Yang, Clarence, D,25121 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Martin, Anne, V,25034 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Sandberg, Kristine,12241 | 3989.46 | 0.00 | 3399.99 | 0.00 | 589.47 |
| Andersen, Tracy,20815 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Zeng, Colleen, L,28304 | 91.97 | 0.00 | 0.00 | 91.97 | 0.00 |
| Zhao, Glenn, C,14221 | 82.26 | 0.00 | 0.00 | 49.99 | 32.27 |
| Vazquez, Ross,11148 | 126.24 | 0.00 | 0.00 | 53.99 | 72.25 |
| She, Kathryn, I,26443 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Xu, Crystal, E,15754 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Carlson, Billy, C,19667 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Diaz, Tyrone,13116 | 230.25 | 0.00 | 0.00 | 32.27 | 197.98 |
| Shan, Damien, M,11362 | 77.27 | 0.00 | 0.00 | 27.28 | 49.99 |
| Zheng, Omar, C,14522 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Zhou, Louis, C,17912 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Madan, Summer, D,12347 | 6839.12 | 0.00 | 2049.10 | 2370.96 | 2419.06 |
| Xie, Chad, A,26155 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Goel, Carl, S,17249 | 4426.74 | 3578.27 | 0.00 | 0.00 | 848.47 |
| Huang, Crystal, L,26023 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Moyer, Mario,23420 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Garcia, Dominique,16528 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Lin, Bianca,11107 | 8171.01 | 3374.99 | 0.00 | 2376.96 | 2419.06 |
| Martinez, Virginia,13136 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Navarro, Meredith,27703 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Prasad, Candace, S,22148 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Nath, Tommy, B,28937 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Moreno, Roy, J,19951 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Browning, Janet,19979 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Sanz, Craig, M,21993 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Chandra, Monica, H,18898 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Martinez, Abby,29333 | 54.98 | 0.00 | 0.00 | 54.98 | 0.00 |
| Black, Tracy, B,24903 | 2164.91 | 0.00 | 1000.44 | 1164.47 | 0.00 |
| Lopez, Terrance, T,14217 | 139.45 | 0.00 | 0.00 | 89.46 | 49.99 |
| Romero, Jimmy,27704 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Prasad, Arthur,14275 | 5158.37 | 0.00 | 0.00 | 2800.44 | 2357.93 |
| Suarez, Joy, B,12665 | 74.54 | 0.00 | 0.00 | 0.00 | 74.54 |
| Yang, Alan, L,15605 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Yang, Wesley, K,15127 | 5182.73 | 0.00 | 0.00 | 2071.42 | 3111.31 |
| Patterson, Jennifer, M,15129 | 5177.73 | 0.00 | 0.00 | 2071.42 | 3106.31 |
| She, Christine,16184 | 78.20 | 0.00 | 0.00 | 0.00 | 78.20 |
| Zhu, Colleen,17252 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Xu, Tracy, L,17916 | 4787.74 | 3578.27 | 0.00 | 0.00 | 1209.47 |
| Sun, Micah,24887 | 2218.90 | 0.00 | 1000.44 | 1218.46 | 0.00 |
| Zhao, Randy, J,27874 | 1288.31 | 0.00 | 0.00 | 1288.31 | 0.00 |
| Lopez, Francisco, L,18714 | 24.27 | 0.00 | 0.00 | 21.98 | 2.29 |
| Rogers, Seth, R,14318 | 138.45 | 0.00 | 0.00 | 63.97 | 74.48 |
| Chande, Latoya, M,23309 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Sun, Krystal,18908 | 6090.59 | 0.00 | 3578.27 | 2512.32 | 0.00 |
| Madan, Meagan,11767 | 8319.51 | 0.00 | 3399.99 | 2475.97 | 2443.55 |
| Ramos, Audrey,11976 | 8087.31 | 0.00 | 3374.99 | 2319.26 | 2393.06 |
| Gill, Eddie, J,12715 | 74.54 | 0.00 | 0.00 | 64.97 | 9.57 |
| Chen, Cedric, R,17065 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Zhang, Cara,12351 | 117.97 | 0.00 | 0.00 | 0.00 | 117.97 |
| Moreno, Tabitha,19959 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Yuan, Jaclyn,24904 | 2199.90 | 0.00 | 1000.44 | 1199.46 | 0.00 |
| Raji, Grant, R,16185 | 28.98 | 0.00 | 0.00 | 3.99 | 24.99 |
| Becker, Julie,13614 | 114.21 | 0.00 | 0.00 | 86.93 | 27.28 |
| Moreno, Marc,13024 | 2665.06 | 0.00 | 2049.10 | 0.00 | 615.96 |
| She, Kristin, L,19961 | 97.97 | 0.00 | 0.00 | 8.99 | 88.98 |
| Pal, Derek,24591 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Zeng, Dennis, S,13050 | 5651.25 | 0.00 | 2071.42 | 0.00 | 3579.83 |
| Ortega, Jessie, J,17051 | 6060.50 | 3578.27 | 0.00 | 2482.23 | 0.00 |
| Kumar, Bethany,29299 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Flores, Katherine,21180 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Ms., Simon, Britta,25946 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Chander, Julie, E,18763 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Jai, Lacey, C,11371 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Gill, Jaime, M,26152 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Ramirez, Cole, E,13616 | 6872.06 | 0.00 | 0.00 | 2049.10 | 4822.96 |
| Gutierrez, Rodney, J,20628 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Bradley, Emma,14211 | 5662.90 | 0.00 | 0.00 | 2049.10 | 3613.80 |
| Sai, Preston, D,17046 | 4467.74 | 3578.27 | 0.00 | 889.47 | 0.00 |
| Zhang, Clarence, M,13001 | 6799.43 | 0.00 | 2049.10 | 2332.28 | 2418.05 |
| Serrano, Rebekah,14130 | 3814.06 | 0.00 | 0.00 | 3814.06 | 0.00 |
| Sai, Bruce,22194 | 4633.90 | 0.00 | 2181.56 | 0.00 | 2452.34 |
| Hill, Noah,26192 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| Chen, Randy,13004 | 190.27 | 0.00 | 0.00 | 0.00 | 190.27 |
| Ye, Claudia, J,19102 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Zhao, Jaclyn, D,26167 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| Li, Lacey,17515 | 4143.26 | 3578.27 | 0.00 | 564.99 | 0.00 |
| Garcia, Toni,22193 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Ortega, Lance, C,12354 | 6797.13 | 0.00 | 2049.10 | 2309.97 | 2438.06 |
| Raje, Grant, S,24162 | 3004.83 | 0.00 | 0.00 | 2443.35 | 561.48 |
| Wang, Jon, A,26191 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Serrano, Francis, R,23547 | 3598.83 | 0.00 | 0.00 | 3598.83 | 0.00 |
| Huang, Barbara,26442 | 1919.75 | 0.00 | 782.99 | 0.00 | 1136.76 |
| Romero, Deanna, K,23570 | 21.98 | 0.00 | 0.00 | 21.98 | 0.00 |
| Arthur, Cassandra, M,22410 | 2983.34 | 0.00 | 2443.35 | 0.00 | 539.99 |
| Suri, Stanley, J,27496 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Mehta, Denise,13080 | 6844.41 | 0.00 | 2049.10 | 2362.27 | 2433.04 |
| Chen, Jake,22845 | 4633.90 | 0.00 | 2181.56 | 0.00 | 2452.34 |
| Xie, Clarence,22402 | 2721.55 | 0.00 | 2181.56 | 0.00 | 539.99 |
| Gutierrez, Micheal, S,27299 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Vazquez, Theresa, F,22581 | 2749.32 | 0.00 | 2181.56 | 0.00 | 567.76 |
| Mehta, Ebony, J,22854 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Wu, Ernest, L,11147 | 8195.50 | 0.00 | 3374.99 | 2376.96 | 2443.55 |
| Pal, Donna, S,23572 | 3617.83 | 0.00 | 0.00 | 3617.83 | 0.00 |
| Lal, Kara,22579 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Anand, Calvin, E,28717 | 29.48 | 0.00 | 0.00 | 29.48 | 0.00 |
| Perez, Rachael, D,26762 | 133.49 | 0.00 | 0.00 | 133.49 | 0.00 |
| Foster, Aidan,26445 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Gonzalez, Carolyn, H,22407 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Andersen, Deborah,19610 | 118.94 | 0.00 | 0.00 | 68.97 | 49.97 |
| Madan, Candace,22409 | 2746.04 | 0.00 | 0.00 | 2181.56 | 564.48 |
| Yuan, Chad, C,21173 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Gutierrez, Hector,26423 | 2001.97 | 0.00 | 0.00 | 782.99 | 1218.98 |
| Lu, Micah,22174 | 3007.83 | 0.00 | 2443.35 | 564.48 | 0.00 |
| Zhao, Bianca,13971 | 6772.13 | 0.00 | 0.00 | 2049.10 | 4723.03 |
| Kumar, Cedric, B,22860 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
Generated 2024-09-20 02:48:50.810 UTC