[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 125 >
125 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Chen, Randy,13004 | 190.27 | 0.00 | 0.00 | 0.00 | 190.27 |
Raje, Grant, S,24162 | 3004.83 | 0.00 | 0.00 | 2443.35 | 561.48 |
Raje, Raul, L,26785 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
Perez, Allen, B,14229 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
Lopez, Edgar, O,17346 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
Sara, Ruben, A,19566 | 164.91 | 0.00 | 0.00 | 0.00 | 164.91 |
Browning, Javier,23120 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
Pal, Kara,24916 | 2169.90 | 0.00 | 0.00 | 2169.90 | 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 |
Raje, Christy,23100 | 3007.12 | 0.00 | 0.00 | 2443.35 | 563.77 |
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 |
Butler, Hannah, R,13111 | 5707.20 | 0.00 | 0.00 | 2071.42 | 3635.78 |
Moreno, Kristi,23415 | 3588.83 | 0.00 | 0.00 | 3588.83 | 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 |
Raji, Andres, E,13955 | 6888.44 | 0.00 | 0.00 | 2071.42 | 4817.02 |
Lewis, Jasmine,13964 | 6806.45 | 0.00 | 0.00 | 2071.42 | 4735.03 |
Yuan, Chad, C,21173 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
Zhao, Bianca,13971 | 6772.13 | 0.00 | 0.00 | 2049.10 | 4723.03 |
Chander, Russell, E,29067 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
Anderson, Richard, G,24924 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
Blanco, Billy,23316 | 2835.02 | 0.00 | 0.00 | 2181.56 | 653.46 |
Jimenez, Naomi,24922 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
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 |
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 |
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 |
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 |
Ramos, Juan,13633 | 6803.14 | 0.00 | 0.00 | 2049.10 | 4754.04 |
Sara, Barry, R,13965 | 6872.39 | 0.00 | 0.00 | 2071.42 | 4800.97 |
Raji, Grant, R,16185 | 28.98 | 0.00 | 0.00 | 3.99 | 24.99 |
Xu, Colleen, C,18325 | 108.85 | 0.00 | 0.00 | 38.88 | 69.97 |
Gutierrez, Diana,19676 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
She, Willie,17055 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
Perez, Brett, M,28313 | 647.94 | 0.00 | 0.00 | 0.00 | 647.94 |
Gutierrez, Ricky,19773 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
Moreno, Kristine, K,28481 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
Sanz, Hector,27344 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
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 |
Liu, Lacey, L,23545 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
Serrano, Rebekah,14130 | 3814.06 | 0.00 | 0.00 | 3814.06 | 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, 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 |
Bradley, Emma,14211 | 5662.90 | 0.00 | 0.00 | 2049.10 | 3613.80 |
Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
Ramos, Tanya, R,14045 | 6804.13 | 0.00 | 0.00 | 2049.10 | 4755.03 |
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 |
Lal, Shaun, H,17056 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
Tang, Jenny, E,14210 | 5621.24 | 0.00 | 0.00 | 3286.27 | 2334.97 |
Li, Jack, J,14071 | 5617.92 | 0.00 | 0.00 | 3297.93 | 2319.99 |
Chande, Derek,26743 | 1371.95 | 0.00 | 0.00 | 1371.95 | 0.00 |
Zhou, Laura, D,12683 | 6801.45 | 0.00 | 2071.42 | 0.00 | 4730.03 |
Raje, Tara, F,28483 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
Adams, Sydney,27367 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
Goel, Roger, A,23652 | 3907.54 | 0.00 | 0.00 | 2181.56 | 1725.98 |
Goldstein, Dustin,12337 | 8137.01 | 0.00 | 3399.99 | 2343.96 | 2393.06 |
Sun, Lacey, L,15131 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
Cooper, Katherine, R,14314 | 122.95 | 0.00 | 0.00 | 0.00 | 122.95 |
Peterson, Lucas,17298 | 174.45 | 0.00 | 0.00 | 0.00 | 174.45 |
Raman, Arthur,24001 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
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 |
Serrano, Francis, R,23547 | 3598.83 | 0.00 | 0.00 | 3598.83 | 0.00 |
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 |
Pal, Donna, S,23572 | 3617.83 | 0.00 | 0.00 | 3617.83 | 0.00 |
Evans, Carlos, J,23538 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
Lopez, Donald, A,26740 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
Vazquez, Eddie, T,14012 | 5249.92 | 0.00 | 0.00 | 2049.10 | 3200.82 |
Li, Stacey,14064 | 5694.21 | 0.00 | 0.00 | 3375.25 | 2318.96 |
Ye, Jenny,25036 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
Anand, Leonard,14316 | 3797.37 | 0.00 | 0.00 | 2049.10 | 1748.27 |
Li, Alvin,26764 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
Kapoor, Pedro, H,24229 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Ruiz, Adrienne,13523 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
Hu, Barbara,19567 | 104.96 | 0.00 | 0.00 | 75.97 | 28.99 |
Wood, Jacqueline,16705 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
Pal, Arturo, P,29303 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
Gonzalez, Tabitha, A,26136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Sanz, Marvin,19612 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
Liu, Clarence,19797 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
Diaz, Felicia, J,15026 | 29.98 | 0.00 | 0.00 | 24.99 | 4.99 |
Vazquez, Ruben, B,14301 | 5142.75 | 0.00 | 0.00 | 2071.42 | 3071.33 |
Ramirez, Mason, K,25107 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
Murphy, Grace, J,23655 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
Alvarez, Jessie,14324 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
Martin, Joe,14668 | 5216.69 | 0.00 | 0.00 | 2071.42 | 3145.27 |
Suarez, Melody, H,14276 | 5259.36 | 0.00 | 0.00 | 2864.91 | 2394.45 |
Chandra, Jermaine, A,14299 | 5108.76 | 0.00 | 0.00 | 2071.42 | 3037.34 |
Tang, Christy, R,23660 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
Rai, Willie,14673 | 5117.75 | 0.00 | 0.00 | 2071.42 | 3046.33 |
Yang, Randy, E,24000 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
He, Colin, B,14300 | 5322.73 | 0.00 | 0.00 | 2071.42 | 3251.31 |
Ramos, Marie, A,14308 | 5140.40 | 0.00 | 0.00 | 2049.10 | 3091.30 |
Prasad, Tabitha, D,26761 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
Serrano, Diane, E,14857 | 87.97 | 0.00 | 0.00 | 78.98 | 8.99 |
Ruiz, Krista, C,13081 | 6772.15 | 0.00 | 0.00 | 2049.10 | 4723.05 |
Xu, Keith, J,25124 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
Sun, Tamara, L,19976 | 44.04 | 0.00 | 0.00 | 0.00 | 44.04 |
Rivera, Devin, J,25109 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Pal, Tasha,22853 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
Morgan, Jared, A,28213 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Ma, Dawn, A,13956 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
Rubio, Desiree, D,21189 | 4208.31 | 0.00 | 2443.35 | 0.00 | 1764.96 |
Chander, Kelvin, E,27879 | 1313.34 | 0.00 | 0.00 | 0.00 | 1313.34 |
Pal, Nichole, J,26741 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
Nara, Karl,15142 | 138.46 | 0.00 | 0.00 | 0.00 | 138.46 |
Generated 2024-09-19 16:28:27.411 UTC