[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 875 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Martin, Anne, V,25034 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Rubio, Jessie, J,27868 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Nath, Omar, F,14672 | 5237.72 | 0.00 | 0.00 | 2071.42 | 3166.30 |
| Xu, Barbara,14074 | 59.88 | 0.00 | 0.00 | 0.00 | 59.88 |
| Andersen, Drew, K,22412 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Sanchez, Henry,26968 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Chander, Karla,23648 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Shen, Roger, G,14011 | 3831.89 | 0.00 | 0.00 | 3831.89 | 0.00 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Raje, Casey, A,14686 | 203.46 | 0.00 | 0.00 | 0.00 | 203.46 |
| Chavez, Clayton,21949 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Zheng, Jeffery, W,15030 | 3786.39 | 0.00 | 0.00 | 2071.42 | 1714.97 |
| Li, Colin, J,18445 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Madan, Henry, E,17283 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Mr., Rovira Diez, Pablo,21190 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Rodriguez, Heidi, L,25120 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Zhu, Vincent, E,24899 | 105.45 | 0.00 | 0.00 | 105.45 | 0.00 |
| Saunders, Micheal,17513 | 4260.24 | 0.00 | 3578.27 | 681.97 | 0.00 |
| Zhou, Trisha, B,12686 | 6864.46 | 0.00 | 2071.42 | 0.00 | 4793.04 |
| Kapoor, Patricia, R,21883 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Liang, Colin,13639 | 188.96 | 0.00 | 0.00 | 3.99 | 184.97 |
| Madan, Kristopher, A,25238 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Tang, Julie,26589 | 1966.46 | 0.00 | 0.00 | 782.99 | 1183.47 |
| Li, Glenn, A,29295 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Sai, Martin, L,21221 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Rodriguez, Ebony,14517 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Gutierrez, Armando,29310 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Gill, Meredith, E,24268 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Gill, Alberto, P,17733 | 4758.24 | 0.00 | 3578.27 | 0.00 | 1179.97 |
| Moreno, Larry, W,28207 | 2461.55 | 0.00 | 0.00 | 2461.55 | 0.00 |
| Flores, Adam, L,11044 | 6515.30 | 3374.99 | 0.00 | 0.00 | 3140.31 |
| Ortega, Alfredo, W,25958 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| Garcia, Jermaine,21566 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Johnston, Joanna, L,17296 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Rivera, Nathaniel, M,14051 | 5606.91 | 0.00 | 0.00 | 3286.92 | 2319.99 |
| Green, Kyle,28328 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ms., Roy, Lisa, K.,21403 | 4895.69 | 0.00 | 2443.35 | 0.00 | 2452.34 |
| Gonzalez, George, L,11942 | 4792.29 | 0.00 | 3399.99 | 614.96 | 777.34 |
| Arthur, Tammy, L,21363 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nara, Devon, C,21964 | 103.49 | 0.00 | 0.00 | 0.00 | 103.49 |
| Malhotra, Douglas, L,22960 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Stone, Christine, D,25948 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Dominguez, Kellie, E,17244 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Cooper, Katherine, R,14314 | 122.95 | 0.00 | 0.00 | 0.00 | 122.95 |
| Rai, Bradley,19100 | 79.26 | 0.00 | 0.00 | 0.00 | 79.26 |
| Mehta, Deanna, P,17280 | 6089.59 | 3578.27 | 0.00 | 0.00 | 2511.32 |
| Zimmerman, Jenny,18197 | 30.97 | 0.00 | 0.00 | 8.99 | 21.98 |
| Blanco, Larry, E,21216 | 4935.67 | 0.00 | 2443.35 | 0.00 | 2492.32 |
| Lopez, Kristina, L,20247 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Chander, Kelvin, E,27879 | 1313.34 | 0.00 | 0.00 | 0.00 | 1313.34 |
| Moore, Devin, J,16167 | 102.57 | 0.00 | 0.00 | 0.00 | 102.57 |
| Gutierrez, Francis,25245 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Stone, Keith,17331 | 40.96 | 0.00 | 0.00 | 0.00 | 40.96 |
| Shen, Tamara, G,22935 | 3951.52 | 0.00 | 0.00 | 2181.56 | 1769.96 |
| Yuan, Jon,25937 | 1299.56 | 0.00 | 699.10 | 0.00 | 600.46 |
| Goel, Brad, M,29085 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Carter, Amber, E,16679 | 106.56 | 0.00 | 0.00 | 71.58 | 34.98 |
| Lal, Kelsey, T,24913 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Vazquez, Ruben, B,14301 | 5142.75 | 0.00 | 0.00 | 2071.42 | 3071.33 |
| Evans, Jackson,14321 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Lopez, Luis, P,17334 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Chavez, Colin,16032 | 90.95 | 0.00 | 0.00 | 21.98 | 68.97 |
| Weber, Levi, A,13120 | 205.39 | 0.00 | 0.00 | 49.48 | 155.91 |
| Gonzalez, Francisco, L,12245 | 3967.26 | 0.00 | 3399.99 | 0.00 | 567.27 |
| Wu, Bianca, F,28485 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Washington, Marcus,28329 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Sanz, Reginald, K,17522 | 74.95 | 0.00 | 0.00 | 0.00 | 74.95 |
| Walker, Seth, E,27689 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| King, Evan,16637 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Luo, Devon, D,22850 | 4657.51 | 0.00 | 0.00 | 2181.56 | 2475.95 |
| Shen, Grant, B,26763 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Martin, Diane,13958 | 6838.64 | 0.00 | 0.00 | 2049.10 | 4789.54 |
| Moreno, Pedro, A,18248 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Wright, Miguel,25811 | 86.45 | 0.00 | 0.00 | 86.45 | 0.00 |
| Dominguez, Robyn, P,23305 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Nelson, Natalie, C,22928 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Wang, Valerie,20217 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Evans, Carlos, J,23538 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Simmons, Isabel, H,26432 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Andersen, Jenny,20259 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Wu, Clarence, L,13115 | 6779.42 | 0.00 | 0.00 | 2049.10 | 4730.32 |
| Serrano, Tyrone,11360 | 5025.80 | 0.00 | 3399.99 | 0.00 | 1625.81 |
| Navarro, Monique, R,15240 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Alvarez, Desiree,13005 | 223.97 | 0.00 | 0.00 | 0.00 | 223.97 |
| Ramos, Mary, B,15019 | 72.96 | 0.00 | 0.00 | 8.99 | 63.97 |
| Perez, Stefanie,27518 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Black, Shaun, M,17355 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Martinez, Sarah, S,12670 | 6785.13 | 0.00 | 2049.10 | 0.00 | 4736.03 |
| Lopez, Summer,12036 | 69.55 | 0.00 | 0.00 | 2.29 | 67.26 |
| Suarez, Jerome, L,20622 | 6139.59 | 0.00 | 3578.27 | 0.00 | 2561.32 |
| Srini, Deanna,15182 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Perez, Henry,26752 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Hernandez, Brandi, C,21893 | 4663.79 | 0.00 | 2181.56 | 0.00 | 2482.23 |
| Ross, Julian,11363 | 5035.81 | 0.00 | 3399.99 | 0.00 | 1635.82 |
| Diaz, Devin, D,15829 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Zheng, Roger,29321 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Pal, Alison,13042 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Hernandez, Diana, F,11038 | 6437.33 | 3374.99 | 0.00 | 0.00 | 3062.34 |
| Rai, Michele, M,26567 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Navarro, Theresa,20627 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Patel, Jay,22213 | 59.27 | 0.00 | 0.00 | 59.27 | 0.00 |
| Raman, Pamela, C,27369 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Martin, Joan, R,25556 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Rodriguez, Kristi,14345 | 3639.92 | 0.00 | 0.00 | 2049.10 | 1590.82 |
| Ferrier, Jaime, P,23528 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Garcia, Brandy,26028 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Prasad, Brandy, P,14009 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Zeng, Micah, A,25561 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Fernandez, Lydia, M,14523 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Goldberg, Mindy,16159 | 4411.65 | 0.00 | 0.00 | 2071.42 | 2340.23 |
| Moreno, Dwayne, T,23103 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Cai, Jeffery, A,15582 | 2907.56 | 0.00 | 0.00 | 2049.10 | 858.46 |
| Zhou, Kelvin,20231 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Navarro, Mathew, A,19673 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Gomez, Jerome, J,25057 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Kumar, Kate,17321 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Dominguez, Sabrina, M,28116 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Sara, Ann, A,23576 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Pal, Terrence, M,13037 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Zhu, Suzanne, E,25112 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Lopez, Manuel, M,14050 | 5650.24 | 0.00 | 0.00 | 3295.26 | 2354.98 |
| Wang, Laura, L,26146 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Fernandez, Brandy, B,22958 | 4208.31 | 0.00 | 0.00 | 2443.35 | 1764.96 |
| Ward, Katelyn,20258 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Guo, Cedric, R,27487 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
Generated 2024-11-10 06:59:04.603 UTC