[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 750 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzalez, Brandy,27368 | 132.97 | 0.00 | 0.00 | 132.97 | 0.00 |
| 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 |
| Andersen, Tracy,20815 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Ross, Adam,11099 | 8215.99 | 0.00 | 3399.99 | 2363.96 | 2452.04 |
| Kumar, Tommy,17297 | 100.25 | 0.00 | 0.00 | 37.27 | 62.98 |
| Shen, Bridget,17237 | 62.98 | 0.00 | 0.00 | 62.98 | 0.00 |
| Garcia, Sarah,11907 | 8135.33 | 0.00 | 3399.99 | 2297.28 | 2438.06 |
| Yang, Roger, A,28108 | 751.34 | 0.00 | 0.00 | 751.34 | 0.00 |
| Kumar, Alison,21200 | 3932.54 | 0.00 | 2181.56 | 0.00 | 1750.98 |
| Coleman, Nicole, A,21558 | 4919.30 | 0.00 | 2443.35 | 0.00 | 2475.95 |
| Nara, Tara,21194 | 3911.53 | 0.00 | 2181.56 | 0.00 | 1729.97 |
| Jimenez, Neil,22151 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Flores, Brianna,27706 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Gutierrez, Erika,17227 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Romero, Deanna, K,23570 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Suri, Stanley, J,27496 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Chande, Ashlee, N,23096 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Carlson, Clinton, E,11116 | 148.70 | 0.00 | 0.00 | 27.28 | 121.42 |
| Gonzalez, Donald,11079 | 32.96 | 0.00 | 0.00 | 9.99 | 22.97 |
| Rodriguez, Geoffrey,20817 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Johnson, Sydney,19571 | 90.95 | 0.00 | 0.00 | 33.98 | 56.97 |
| Madan, Jarrod, C,21555 | 4715.49 | 0.00 | 2181.56 | 0.00 | 2533.93 |
| Romero, Desiree, J,17239 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Raman, Deanna, H,17053 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Gonzalez, Jan, A,15262 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Torres, Sebastian, V,25831 | 1882.57 | 0.00 | 699.10 | 0.00 | 1183.47 |
| Suri, Phillip,17914 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Serrano, Gloria, G,21556 | 4930.68 | 0.00 | 2443.35 | 0.00 | 2487.33 |
| Sanz, Gerald, J,17060 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Xie, Alvin, M,16617 | 160.55 | 0.00 | 0.00 | 69.97 | 90.58 |
| Ross, Connor, J,20816 | 4228.72 | 0.00 | 3578.27 | 650.45 | 0.00 |
| Nara, Edwin, R,11097 | 8099.03 | 0.00 | 3374.99 | 2304.98 | 2419.06 |
| Watson, Adrian, K,13641 | 144.74 | 0.00 | 0.00 | 117.46 | 27.28 |
| Ross, Arianna, E,26774 | 1331.97 | 0.00 | 0.00 | 1331.97 | 0.00 |
| Sanders, Gabriella,11906 | 8151.00 | 0.00 | 3374.99 | 2391.94 | 2384.07 |
| Phillips, Jeremy, E,18495 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Nara, Jon,22006 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Moreno, Tanya,11139 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Sai, Tina, L,15425 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Fernandez, Shane, A,13127 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Raman, Ruth, L,21199 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Luo, Lacey,24175 | 2743.04 | 0.00 | 0.00 | 2181.56 | 561.48 |
| Alvarez, Jessie,14324 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
| Chandra, Troy,21406 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Serrano, Linda,11071 | 110.23 | 0.00 | 0.00 | 42.26 | 67.97 |
| Lin, Claudia, A,14312 | 191.27 | 0.00 | 0.00 | 166.28 | 24.99 |
| Johnsen, Eddie,28935 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Rodriguez, Joel, C,16488 | 119.95 | 0.00 | 0.00 | 119.95 | 0.00 |
| Goel, Lacey, N,18704 | 33.26 | 0.00 | 0.00 | 30.97 | 2.29 |
| Zhu, Jenny, J,17078 | 186.94 | 0.00 | 0.00 | 186.94 | 0.00 |
| Zeng, Heather, E,18287 | 72.16 | 0.00 | 0.00 | 72.16 | 0.00 |
| Yuan, Jaclyn,24904 | 2199.90 | 0.00 | 0.00 | 2199.90 | 0.00 |
| Zheng, Laura,16701 | 4426.74 | 3578.27 | 0.00 | 848.47 | 0.00 |
| Sai, Lydia, L,13968 | 5181.70 | 0.00 | 0.00 | 2862.74 | 2318.96 |
| Li, Jaclyn,18281 | 6081.10 | 0.00 | 3578.27 | 0.00 | 2502.83 |
| Vance, Toni, L,23438 | 123.48 | 0.00 | 0.00 | 0.00 | 123.48 |
| Johnson, Brianna, J,17319 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Moreno, Janet, L,15592 | 59.98 | 0.00 | 0.00 | 24.99 | 34.99 |
| She, Mindy, J,13009 | 168.67 | 0.00 | 0.00 | 0.00 | 168.67 |
| Malhotra, Douglas, L,22960 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Mehta, Erick, E,14123 | 61.58 | 0.00 | 0.00 | 28.98 | 32.60 |
Generated 2025-11-07 01:36:00.016 UTC