[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 125 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Arthur, Rebekah,22939 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Gutierrez, Jay, C,13155 | 226.95 | 0.00 | 0.00 | 217.96 | 8.99 |
| Li, Krystal, A,24912 | 2120.93 | 0.00 | 0.00 | 2120.93 | 0.00 |
| Thompson, Justin,22954 | 4179.33 | 0.00 | 0.00 | 4179.33 | 0.00 |
| Kovar, Mayra, J,17312 | 4471.74 | 3578.27 | 0.00 | 0.00 | 893.47 |
| Raji, Grant, R,16185 | 28.98 | 0.00 | 0.00 | 3.99 | 24.99 |
| Rai, Michele, M,26567 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| She, Kristin, L,19961 | 97.97 | 0.00 | 0.00 | 8.99 | 88.98 |
| Yuan, Christine,11046 | 6616.81 | 3374.99 | 0.00 | 0.00 | 3241.82 |
| Cai, Amy,24920 | 2155.92 | 0.00 | 0.00 | 2155.92 | 0.00 |
| Ortega, Jessie, J,17051 | 6060.50 | 3578.27 | 0.00 | 2482.23 | 0.00 |
| Davis, Ryan, C,27870 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Schmidt, Joe, M,22905 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Goldstein, Dustin,12337 | 8137.01 | 0.00 | 3399.99 | 2343.96 | 2393.06 |
| Andersen, Jodi,26766 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Sun, Lacey, L,15131 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Ruiz, Francis, D,21381 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Diaz, Jill, F,22936 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Cooper, Katherine, R,14314 | 122.95 | 0.00 | 0.00 | 0.00 | 122.95 |
| Fernandez, Brandy, B,22958 | 4208.31 | 0.00 | 0.00 | 2443.35 | 1764.96 |
| Schmidt, Danny, M,28926 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lewis, Hannah,26561 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Sai, Preston, D,17046 | 4467.74 | 3578.27 | 0.00 | 889.47 | 0.00 |
| Ramos, Robyn, O,15828 | 172.25 | 0.00 | 0.00 | 49.96 | 122.29 |
| Moreno, Jessie, C,22906 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Serrano, Rebekah,14130 | 3814.06 | 0.00 | 0.00 | 3814.06 | 0.00 |
| Shen, Tamara, G,22935 | 3951.52 | 0.00 | 0.00 | 2181.56 | 1769.96 |
| Kovar, Nancy, F,26568 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Natsuhara, Tony,23097 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Ye, Claudia, J,19102 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Madan, Patricia, L,22988 | 4194.33 | 0.00 | 0.00 | 2443.35 | 1750.98 |
| Li, Lacey,17515 | 4143.26 | 3578.27 | 0.00 | 564.99 | 0.00 |
| Peterson, Lucas,17298 | 174.45 | 0.00 | 0.00 | 0.00 | 174.45 |
| Morgan, Sara,13134 | 5648.92 | 0.00 | 0.00 | 2049.10 | 3599.82 |
| Ortega, Lance, C,12354 | 6797.13 | 0.00 | 2049.10 | 2309.97 | 2438.06 |
| Ramos, Theresa, G,11031 | 6478.60 | 3399.99 | 0.00 | 0.00 | 3078.61 |
| Kumar, Tonya, A,22934 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Raman, Arthur,24001 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Serrano, Francis, R,23547 | 3598.83 | 0.00 | 0.00 | 3598.83 | 0.00 |
| Pal, Kara,24916 | 2169.90 | 0.00 | 0.00 | 2169.90 | 0.00 |
| Romero, Deanna, K,23570 | 21.98 | 0.00 | 0.00 | 21.98 | 0.00 |
| Suri, Stanley, J,27496 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Blanco, Hector, J,22938 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Xu, Willie, C,13160 | 6839.46 | 0.00 | 0.00 | 2071.42 | 4768.04 |
| Martin, Deanna,13091 | 6864.95 | 0.00 | 0.00 | 2071.42 | 4793.53 |
| Chapman, Jodi, L,22966 | 3917.54 | 0.00 | 0.00 | 3917.54 | 0.00 |
| Zhou, Heather, M,24914 | 2149.91 | 0.00 | 0.00 | 2149.91 | 0.00 |
| Gutierrez, Micheal, S,27299 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Raje, Christy,23100 | 3007.12 | 0.00 | 0.00 | 2443.35 | 563.77 |
| Wu, Ernest, L,11147 | 8195.50 | 0.00 | 3374.99 | 2376.96 | 2443.55 |
| Gonzalez, Tabitha, A,26136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Pal, Donna, S,23572 | 3617.83 | 0.00 | 0.00 | 3617.83 | 0.00 |
| Kumar, Michele,23107 | 3896.53 | 0.00 | 0.00 | 3896.53 | 0.00 |
| Suarez, Kristi, D,23099 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| 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 |
| Butler, Hannah, R,13111 | 5707.20 | 0.00 | 0.00 | 2071.42 | 3635.78 |
| Andersen, Deborah,19610 | 118.94 | 0.00 | 0.00 | 68.97 | 49.97 |
| Moreno, Kristi,23415 | 3588.83 | 0.00 | 0.00 | 3588.83 | 0.00 |
| Lu, Micah,22174 | 3007.83 | 0.00 | 2443.35 | 564.48 | 0.00 |
| Xu, Sharon, A,23344 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Perez, Ivan, S,23408 | 4218.82 | 0.00 | 0.00 | 2443.35 | 1775.47 |
| Browning, Javier,23120 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Lal, Clarence, L,24470 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Raji, Andres, E,13955 | 6888.44 | 0.00 | 0.00 | 2071.42 | 4817.02 |
| Patel, Veronica,13963 | 74.48 | 0.00 | 0.00 | 74.48 | 0.00 |
| Lewis, Jasmine,13964 | 6806.45 | 0.00 | 0.00 | 2071.42 | 4735.03 |
| Diaz, Felicia, J,15026 | 29.98 | 0.00 | 0.00 | 24.99 | 4.99 |
| Anderson, Richard, G,24924 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Morgan, Jared, A,28213 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Blanco, Billy,23316 | 2835.02 | 0.00 | 0.00 | 2181.56 | 653.46 |
| Ma, Dawn, A,13956 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Jimenez, Naomi,24922 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Rubio, Desiree, D,21189 | 4208.31 | 0.00 | 2443.35 | 0.00 | 1764.96 |
| Navarro, Stacy, C,12688 | 6867.44 | 0.00 | 2071.42 | 2376.96 | 2419.06 |
| Dominguez, Darren, M,13966 | 6842.12 | 0.00 | 0.00 | 2049.10 | 4793.02 |
| Ramirez, Cole, E,13616 | 6872.06 | 0.00 | 0.00 | 2049.10 | 4822.96 |
| Chander, Kelvin, E,27879 | 1313.34 | 0.00 | 0.00 | 0.00 | 1313.34 |
| Vazquez, Marc, H,24362 | 3600.77 | 0.00 | 0.00 | 3600.77 | 0.00 |
| Kumar, Misty, H,25010 | 1540.43 | 0.00 | 0.00 | 1000.44 | 539.99 |
| Gomez, Kendra, J,23320 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Yuan, Karla, W,13629 | 6889.11 | 0.00 | 0.00 | 2049.10 | 4840.01 |
| Pal, Nichole, J,26741 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chen, Tiffany, A,23348 | 4167.31 | 0.00 | 0.00 | 2443.35 | 1723.96 |
| Yuan, Terry, R,13646 | 6843.60 | 0.00 | 0.00 | 2049.10 | 4794.50 |
| Nara, Karl,15142 | 138.46 | 0.00 | 0.00 | 0.00 | 138.46 |
| Sara, Candace,21380 | 2735.53 | 0.00 | 2181.56 | 553.97 | 0.00 |
| Sharma, Kelvin, D,26655 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Alvarez, Carrie, W,23410 | 4016.53 | 0.00 | 0.00 | 2181.56 | 1834.97 |
| Zhu, Dawn,26661 | 1912.47 | 0.00 | 0.00 | 782.99 | 1129.48 |
| Zeng, Stacey, J,17317 | 128.95 | 0.00 | 0.00 | 0.00 | 128.95 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 8.99 | 64.97 |
| Ramos, Juan,13633 | 6803.14 | 0.00 | 0.00 | 2049.10 | 4754.04 |
| Zhou, Warren,19791 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Sara, Barry, R,13965 | 6872.39 | 0.00 | 0.00 | 2071.42 | 4800.97 |
| Tang, Jenny, E,14210 | 5621.24 | 0.00 | 0.00 | 3286.27 | 2334.97 |
| Hernandez, Kristine,14286 | 5234.40 | 0.00 | 0.00 | 2859.42 | 2374.98 |
| Zhao, Gilbert,23119 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Xu, Karl,23321 | 3060.82 | 0.00 | 0.00 | 2443.35 | 617.47 |
| Rubio, Bruce, E,23343 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Becker, Jenny,17290 | 92.97 | 0.00 | 0.00 | 29.99 | 62.98 |
| Liu, Lacey, L,23545 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Hall, Mary, R,20277 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Sun, Rafael,26749 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Lin, Mandy, C,25035 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Anand, Johnny,14058 | 5652.52 | 0.00 | 0.00 | 3355.24 | 2297.28 |
| Yang, Jon, V,11000 | 8248.99 | 3399.99 | 0.00 | 4849.00 | 0.00 |
| Yang, Ronnie,23524 | 3598.83 | 0.00 | 0.00 | 3598.83 | 0.00 |
| Hernandez, Alberto, D,25029 | 2272.20 | 0.00 | 0.00 | 1000.44 | 1271.76 |
| Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Ashe, Barbara,18734 | 24.27 | 0.00 | 0.00 | 21.98 | 2.29 |
| Ramos, Tanya, R,14045 | 6804.13 | 0.00 | 0.00 | 2049.10 | 4755.03 |
| Zheng, Erica, K,23643 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| Garcia, Rebekah, M,14007 | 3772.41 | 0.00 | 0.00 | 3772.41 | 0.00 |
| Li, Jack, J,14071 | 5617.92 | 0.00 | 0.00 | 3297.93 | 2319.99 |
| Kapoor, Kristina,11997 | 7029.78 | 0.00 | 3399.99 | 1249.84 | 2379.95 |
| Chande, Derek,26743 | 1371.95 | 0.00 | 0.00 | 1371.95 | 0.00 |
| Ruiz, Naomi,23649 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Cai, Candice,26747 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Ye, Christy,14219 | 5744.22 | 0.00 | 0.00 | 2071.42 | 3672.80 |
| Kumar, Jenny, C,23429 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Chen, Rosa,23435 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Romero, Jessie,25030 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Evans, Carlos, J,23538 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
Generated 2024-09-20 00:08:41.443 UTC