[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 875 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rai, Melvin, J,24604 | 3681.80 | 0.00 | 0.00 | 3681.80 | 0.00 |
| Garcia, Preston, M,24602 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Gomez, Tabitha, L,16688 | 6081.10 | 3578.27 | 0.00 | 2502.83 | 0.00 |
| Foster, Lucas,13519 | 4492.45 | 0.00 | 0.00 | 4492.45 | 0.00 |
| King, Maria, E,28202 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Liu, Jessie,11106 | 8079.05 | 0.00 | 3399.99 | 2294.99 | 2384.07 |
| Ramos, Marc,18212 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Verhoff, Rob,11008 | 8106.31 | 3374.99 | 0.00 | 4731.32 | 0.00 |
| Fernandez, Rachael, M,23993 | 3072.32 | 0.00 | 0.00 | 2443.35 | 628.97 |
| 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 |
| Garcia, Ruben,19613 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Chande, Carl,18932 | 59.26 | 0.00 | 0.00 | 2.29 | 56.97 |
| Black, Michele,13995 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Suarez, Renee, L,12703 | 6891.12 | 0.00 | 0.00 | 2049.10 | 4842.02 |
| Nara, Cristina, R,19792 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Roberts, Jennifer,11447 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Wood, Sydney,23310 | 3333.32 | 0.00 | 0.00 | 3333.32 | 0.00 |
| Munoz, Deanna,11054 | 8223.02 | 3399.99 | 0.00 | 2403.97 | 2419.06 |
| Mehta, Cassandra,23014 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| 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 |
| Yang, Connor,17735 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Goldstein, Dustin,12337 | 8137.01 | 0.00 | 3399.99 | 0.00 | 4737.02 |
| 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 |
| Alvarez, Marc, B,18221 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Smith, Christian, L,14313 | 222.44 | 0.00 | 0.00 | 0.00 | 222.44 |
| Chande, Michele, C,13078 | 6850.46 | 0.00 | 0.00 | 2071.42 | 4779.04 |
| Chow, Amy, E,12699 | 6798.13 | 0.00 | 2049.10 | 0.00 | 4749.03 |
| Gutierrez, Gary, C,12701 | 6868.44 | 0.00 | 0.00 | 2071.42 | 4797.02 |
| Goel, Barbara,12988 | 6915.44 | 0.00 | 0.00 | 2049.10 | 4866.34 |
| Chandra, Ann,18209 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Chander, Damien,11080 | 8204.02 | 0.00 | 3374.99 | 2359.98 | 2469.05 |
| Yuan, Tamara, E,21166 | 4909.67 | 0.00 | 2443.35 | 0.00 | 2466.32 |
| Li, Ramon,21248 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Ruiz, Hector,27592 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzalez, Tabitha, A,26136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Serrano, Neil, L,17076 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Zhou, Jaclyn, C,21179 | 4935.67 | 0.00 | 2443.35 | 0.00 | 2492.32 |
| Lal, Cristina, M,14671 | 2934.37 | 0.00 | 0.00 | 2071.42 | 862.95 |
| Shan, Tony, M,16175 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Alvarez, Erik, M,14311 | 138.45 | 0.00 | 0.00 | 74.48 | 63.97 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Sharma, Tony,18241 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Yang, Jon, V,11000 | 8248.99 | 3399.99 | 0.00 | 2341.97 | 2507.03 |
| Gomez, Felicia, J,18219 | 6038.56 | 0.00 | 3578.27 | 2460.29 | 0.00 |
| Martinez, Tyler, T,28201 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Peterson, Juan, H,13082 | 6906.39 | 0.00 | 0.00 | 2071.42 | 4834.97 |
| Raji, Grant, R,16185 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Raman, Pamela, C,27369 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Perez, Brett, M,28313 | 647.94 | 0.00 | 0.00 | 0.00 | 647.94 |
| Moreno, Kristine, K,28481 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Ray, Bobby,23575 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Sanz, Hector,27344 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Andersen, Carl, J,11057 | 8088.04 | 3374.99 | 0.00 | 2319.99 | 2393.06 |
| Navarro, Rodney, L,29309 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Shen, Shaun,12684 | 6893.08 | 0.00 | 2049.10 | 0.00 | 4843.98 |
| Sara, Edgar, A,11104 | 8173.03 | 0.00 | 3399.99 | 2334.98 | 2438.06 |
| Ye, Tamara, A,20243 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Sun, Louis, E,16182 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
Generated 2025-11-04 09:03:28.512 UTC