[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Shen, Corey,26739 | 61.97 | 0.00 | 0.00 | 61.97 | 0.00 |
| Torres, Sabrina, E,20425 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Rubio, Marie, V,20618 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Fernandez, Denise, A,18724 | 6056.51 | 0.00 | 3578.27 | 2478.24 | 0.00 |
| Munoz, Kendra, S,23529 | 3617.83 | 0.00 | 0.00 | 3617.83 | 0.00 |
| Martin, Adrienne,19952 | 39.46 | 0.00 | 0.00 | 25.48 | 13.98 |
| Andersen, Brendan,15121 | 5202.73 | 0.00 | 0.00 | 2071.42 | 3131.31 |
| Lal, Terrence,12369 | 94.23 | 0.00 | 0.00 | 0.00 | 94.23 |
| Jai, Brendan,26755 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Zhang, Dawn, A,14222 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Raman, Abby, T,15122 | 5193.72 | 0.00 | 0.00 | 2071.42 | 3122.30 |
| Torres, Melinda, J,14033 | 6809.96 | 0.00 | 0.00 | 2071.42 | 4738.54 |
| Ramos, Roy, A,24482 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Torres, Jacquelyn, P,27464 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Chandra, Jarrod,24171 | 3006.31 | 0.00 | 0.00 | 2443.35 | 562.96 |
| Navarro, Jaime, T,27690 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Vazquez, Rodney, M,13047 | 241.93 | 0.00 | 0.00 | 0.00 | 241.93 |
| Yang, Valerie, L,27361 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Dominguez, Walter,12576 | 2653.07 | 0.00 | 2049.10 | 0.00 | 603.97 |
| Mr., Schmidt, Irving, W,12669 | 6791.10 | 0.00 | 2049.10 | 2357.93 | 2384.07 |
| Jiménez, Darren, W,28931 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Liu, Dennis,29062 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Mehta, Brett,11450 | 8173.26 | 0.00 | 3374.99 | 2370.22 | 2428.05 |
| Hernandez, Melinda,16174 | 140.45 | 0.00 | 0.00 | 92.48 | 47.97 |
| Patel, Cynthia, M,15222 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Lu, Ronnie,19950 | 6098.54 | 0.00 | 3578.27 | 0.00 | 2520.27 |
| Liu, Krystal, D,13526 | 4549.76 | 0.00 | 0.00 | 2071.42 | 2478.34 |
| Alonso, Gloria, S,19964 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Alvarez, Erik, M,14311 | 138.45 | 0.00 | 0.00 | 74.48 | 63.97 |
| Flores, Antonio, D,14259 | 3630.93 | 0.00 | 0.00 | 2888.58 | 742.35 |
| Patterson, Antonio, G,11963 | 8068.03 | 0.00 | 3374.99 | 2294.99 | 2398.05 |
| Kumar, Tommy,17297 | 100.25 | 0.00 | 0.00 | 37.27 | 62.98 |
| Garcia, Sarah,11907 | 8135.33 | 0.00 | 3399.99 | 2297.28 | 2438.06 |
| Sharma, Keith,15728 | 63.97 | 0.00 | 0.00 | 28.98 | 34.99 |
| Collins, Logan, H,13983 | 180.41 | 0.00 | 0.00 | 145.42 | 34.99 |
| Guo, Cedric, R,27487 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Munoz, Sheila,27488 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Johnson, Morgan, E,12011 | 4735.81 | 0.00 | 3374.99 | 618.47 | 742.35 |
| Dominguez, Raquel, A,27470 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| He, Jake, M,24472 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Lopez, Ross,18443 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Lin, Dawn, N,15805 | 127.47 | 0.00 | 0.00 | 0.00 | 127.47 |
| Long, Nicole, C,13624 | 114.97 | 0.00 | 0.00 | 59.98 | 54.99 |
| Cook, Sydney, D,13118 | 5669.90 | 0.00 | 0.00 | 2049.10 | 3620.80 |
| Gill, Hector, M,26187 | 1932.46 | 0.00 | 782.99 | 0.00 | 1149.47 |
| Alvarez, Francis,21552 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Gomez, Carrie,22965 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Pal, Mindy,19097 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Nara, Devon, C,21964 | 103.49 | 0.00 | 0.00 | 0.00 | 103.49 |
| Lopez, Deanna, L,25119 | 2148.21 | 0.00 | 0.00 | 1000.44 | 1147.77 |
| Deng, Tasha,11459 | 8141.33 | 0.00 | 3399.99 | 2322.28 | 2419.06 |
| Ortega, Jill, A,20239 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Jimenez, Jimmy,27365 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Malhotra, Stanley, H,11453 | 8176.98 | 0.00 | 3374.99 | 2382.93 | 2419.06 |
| Guo, Lacey,16744 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Perez, Whitney,16619 | 97.58 | 0.00 | 0.00 | 67.59 | 29.99 |
| Lewis, Kayla,12013 | 3949.97 | 0.00 | 3399.99 | 549.98 | 0.00 |
| Lu, Christy,17062 | 91.26 | 0.00 | 0.00 | 91.26 | 0.00 |
| Moore, Devin, J,16167 | 102.57 | 0.00 | 0.00 | 0.00 | 102.57 |
| Carson, Mitchell,13623 | 99.20 | 0.00 | 0.00 | 0.00 | 99.20 |
| Black, Rafael,11966 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
Generated 2024-09-19 21:30:26.868 UTC