[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 1500 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Vazquez, Eddie, T,14012 | 5249.92 | 0.00 | 0.00 | 2049.10 | 3200.82 |
| Nara, Johnny, R,18489 | 6081.10 | 0.00 | 3578.27 | 2502.83 | 0.00 |
| Griffin, Caroline,17726 | 4721.73 | 3578.27 | 0.00 | 0.00 | 1143.46 |
| Kumar, Rafael, L,19088 | 24.27 | 0.00 | 0.00 | 2.29 | 21.98 |
| Morgan, Natalie,15149 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Lal, Terry,18277 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Lal, Katie, E,18210 | 6044.59 | 3578.27 | 0.00 | 2466.32 | 0.00 |
| Luo, Nichole, A,29296 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Muñoz, Pedro, A,23433 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| McDonald, Kaitlin,18493 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Mr., Solanki, Ajay,18295 | 144.27 | 0.00 | 0.00 | 141.98 | 2.29 |
| Hayes, Alexis,13048 | 190.23 | 0.00 | 0.00 | 0.00 | 190.23 |
| Ruiz, Naomi,23649 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Serrano, Shannon, R,18303 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Dominguez, Kellie, E,17244 | 86.27 | 0.00 | 0.00 | 53.99 | 32.28 |
| Patel, Rachael, G,13640 | 71.25 | 0.00 | 0.00 | 32.27 | 38.98 |
| Mr., Sands, Patrick,14063 | 5676.25 | 0.00 | 0.00 | 3321.26 | 2354.99 |
| Murphy, Alexa,18276 | 6106.60 | 0.00 | 3578.27 | 0.00 | 2528.33 |
| Deng, Grant, C,16625 | 81.81 | 0.00 | 0.00 | 36.59 | 45.22 |
| Yuan, Jon,25937 | 1299.56 | 0.00 | 699.10 | 0.00 | 600.46 |
| Kumar, Jenny, C,23429 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Gill, Diana,25710 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Deng, Tracy, E,21978 | 37.29 | 0.00 | 0.00 | 37.29 | 0.00 |
| Kumar, Bethany,29299 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Alexander, Austin,26673 | 1505.76 | 0.00 | 0.00 | 1505.76 | 0.00 |
| Prasad, Levi,25705 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Richardson, Katelyn,18930 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Jai, Lacey, C,11371 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Gonzalez, Shane, Y,14125 | 3772.41 | 0.00 | 0.00 | 3772.41 | 0.00 |
| McDonald, Brent,14068 | 77.27 | 0.00 | 0.00 | 27.28 | 49.99 |
| Jai, Kathryn,23546 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Tang, Willie, A,25939 | 1264.57 | 0.00 | 699.10 | 0.00 | 565.47 |
| Chen, Rosa,23435 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Pal, Alvin, C,29319 | 2447.05 | 0.00 | 0.00 | 2447.05 | 0.00 |
| Hill, Aaron,25818 | 35.96 | 0.00 | 0.00 | 35.96 | 0.00 |
| Sanz, Jésus,29313 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Jimenez, Melody, S,14066 | 3612.19 | 0.00 | 0.00 | 2853.57 | 758.62 |
| Xu, Kara, E,22212 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Dominguez, Sabrina, M,28116 | 617.47 | 0.00 | 0.00 | 617.47 | 0.00 |
| Xie, Nina,12997 | 118.18 | 0.00 | 0.00 | 0.00 | 118.18 |
| Rubio, Derrick, P,23525 | 3302.05 | 0.00 | 0.00 | 3302.05 | 0.00 |
| Russell, Cassidy, N,26144 | 27.77 | 0.00 | 0.00 | 27.77 | 0.00 |
| Xie, Drew, A,20218 | 104.69 | 0.00 | 0.00 | 104.69 | 0.00 |
| Dominguez, Theodore, F,21987 | 4638.89 | 0.00 | 2181.56 | 0.00 | 2457.33 |
| Evans, Carlos, J,23538 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Beck, Cedric, L,22403 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Gomez, Mallory, R,24898 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Lopez, Rachael,23425 | 3951.52 | 0.00 | 0.00 | 2181.56 | 1769.96 |
| Li, Marshall,12687 | 6805.47 | 0.00 | 2071.42 | 2349.98 | 2384.07 |
| Anand, Alícia, J,29113 | 2453.04 | 0.00 | 0.00 | 2453.04 | 0.00 |
| Rai, Calvin,15229 | 2833.57 | 0.00 | 0.00 | 2049.10 | 784.47 |
| Sanz, Lawrence, M,14030 | 6905.47 | 0.00 | 0.00 | 2071.42 | 4834.05 |
| Ashe, Misty, R,23129 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| She, Candice,29178 | 2452.04 | 0.00 | 0.00 | 2452.04 | 0.00 |
| Guo, Autumn, A,14213 | 86.26 | 0.00 | 0.00 | 58.98 | 27.28 |
| Patel, Summer, G,26753 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Zhang, Clarence, M,13001 | 6799.43 | 0.00 | 2049.10 | 2332.28 | 2418.05 |
| Nath, Alvin, R,29301 | 134.98 | 0.00 | 0.00 | 134.98 | 0.00 |
| Xu, Terry,24228 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Chandra, Veronica,14681 | 5178.40 | 0.00 | 0.00 | 2049.10 | 3129.30 |
| Zheng, Claudia,18691 | 6070.59 | 0.00 | 3578.27 | 2492.32 | 0.00 |
| Suri, Douglas,19096 | 6090.59 | 0.00 | 3578.27 | 2512.32 | 0.00 |
| Martinez, Terrance,25718 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Romero, Gina,14234 | 5687.72 | 0.00 | 0.00 | 2071.42 | 3616.30 |
| Malhotra, Cynthia,11358 | 5034.78 | 0.00 | 3374.99 | 0.00 | 1659.79 |
| Vazquez, Randall, Z,21186 | 35.00 | 0.00 | 0.00 | 35.00 | 0.00 |
| Ramos, Leslie,15733 | 4443.55 | 0.00 | 0.00 | 2049.10 | 2394.45 |
| Chen, Alisha, J,14225 | 5603.92 | 0.00 | 0.00 | 2049.10 | 3554.82 |
| Murphy, Seth, A,25704 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Mehta, Carolyn,28205 | 603.49 | 0.00 | 0.00 | 603.49 | 0.00 |
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 2408.97 | 756.33 |
| Mehta, Heidi,14226 | 5656.24 | 0.00 | 0.00 | 2071.42 | 3584.82 |
| Gill, Latasha, M,25713 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Suarez, Carolyn, B,18222 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Martin, Marc, J,11039 | 6636.58 | 3399.99 | 0.00 | 0.00 | 3236.59 |
| Yang, Crystal, A,23665 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Kapoor, Denise, M,18725 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Nelson, Fernando, G,25564 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Hernandez, Diana, F,11038 | 6437.33 | 3374.99 | 0.00 | 0.00 | 3062.34 |
| Goel, Alisha, C,26767 | 1331.97 | 0.00 | 0.00 | 1331.97 | 0.00 |
| Luo, Tamara,18738 | 6089.59 | 0.00 | 3578.27 | 2511.32 | 0.00 |
| Navarro, Kristine, B,25566 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Guo, Lisa, S,17314 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Yang, Randy, E,24000 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Guo, Ernest,25717 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Chander, Alison,18249 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Srini, Candace,15437 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Tang, Colin,14323 | 5222.02 | 0.00 | 0.00 | 2071.42 | 3150.60 |
| Pal, Christy, R,18739 | 5371.74 | 0.00 | 3578.27 | 1793.47 | 0.00 |
| Smith, Arthur,18240 | 6098.58 | 0.00 | 3578.27 | 2520.31 | 0.00 |
| Sara, Ross,24367 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Ross, Arianna, E,26774 | 1331.97 | 0.00 | 0.00 | 1331.97 | 0.00 |
| Chande, Melvin, R,11460 | 8137.52 | 0.00 | 3399.99 | 2294.99 | 2442.54 |
| Pal, Christine, I,18242 | 6121.71 | 0.00 | 3578.27 | 2543.44 | 0.00 |
| Wang, Micah, C,14676 | 5188.41 | 0.00 | 0.00 | 2049.10 | 3139.31 |
| Serrano, Mallory, E,26751 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Ma, Lacey, K,18723 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Sun, Brittney,11365 | 5024.79 | 0.00 | 3374.99 | 0.00 | 1649.80 |
| Evans, Jackson,14321 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Wu, Arturo, A,28321 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Subram, Troy, R,19607 | 6054.22 | 0.00 | 3578.27 | 2475.95 | 0.00 |
| Serrano, Audrey,18337 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Srini, Beth, A,25913 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Zheng, Colleen,13026 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Becker, Leonard, C,22405 | 123.98 | 0.00 | 0.00 | 123.98 | 0.00 |
| Gill, Carolyn,23094 | 67.93 | 0.00 | 0.00 | 67.93 | 0.00 |
| Tang, Sharon, M,15823 | 67.96 | 0.00 | 0.00 | 0.00 | 67.96 |
| Shen, Bonnie,21405 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Hu, Lacey,19948 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Shen, Devon, G,27358 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Patel, Douglas,17927 | 4726.04 | 3578.27 | 0.00 | 0.00 | 1147.77 |
| Rubio, Walter, R,25912 | 63.47 | 0.00 | 0.00 | 0.00 | 63.47 |
| Martinez, Holly, B,19628 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Garcia, Harold, K,14087 | 341.97 | 0.00 | 0.00 | 292.49 | 49.48 |
| Chapman, Kristi, l,21986 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Deng, Willie, J,27876 | 1214.85 | 0.00 | 0.00 | 0.00 | 1214.85 |
| Zeng, Alisha, A,15727 | 134.46 | 0.00 | 0.00 | 99.47 | 34.99 |
| Suri, Jarrod, E,12004 | 8114.04 | 0.00 | 3374.99 | 2319.99 | 2419.06 |
| Zhao, Marshall, C,22033 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
| Rivera, Evan, Y,26757 | 1344.47 | 0.00 | 0.00 | 1344.47 | 0.00 |
| Carlson, Tanya,16183 | 31.27 | 0.00 | 0.00 | 6.28 | 24.99 |
| Gutierrez, Erika,17227 | 83.97 | 0.00 | 0.00 | 24.99 | 58.98 |
| Ruiz, Alberto, L,25212 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Arun, Ross, C,23658 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
Generated 2024-09-20 04:08:22.853 UTC