[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rubio, Bruce, E,23343 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Xu, Sharon, A,23344 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Gonzalez, Tina,19653 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Dominguez, Gina, L,20213 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Chander, Drew, J,25111 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Madan, Candace,22409 | 2746.04 | 0.00 | 0.00 | 2181.56 | 564.48 |
| Anand, Leonard,14316 | 3797.37 | 0.00 | 0.00 | 2049.10 | 1748.27 |
| Shan, Clarence,22408 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Chande, Cassie,11103 | 8182.50 | 0.00 | 3374.99 | 2388.45 | 2419.06 |
| Watson, Adrian, K,13641 | 144.74 | 0.00 | 0.00 | 117.46 | 27.28 |
| Ma, Amy, E,17309 | 6030.61 | 3578.27 | 0.00 | 0.00 | 2452.34 |
| Raje, Gilbert,11055 | 8168.01 | 3374.99 | 0.00 | 2394.97 | 2398.05 |
| Wang, Autumn,13049 | 5647.22 | 0.00 | 0.00 | 2071.42 | 3575.80 |
| Andersen, Brendan,15121 | 5202.73 | 0.00 | 0.00 | 2071.42 | 3131.31 |
| Liu, Brittney, M,15804 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Zhang, Dawn, A,14222 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Raje, Ashlee, E,16658 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Raman, Abby, T,15122 | 5193.72 | 0.00 | 0.00 | 2071.42 | 3122.30 |
| Ramos, Roy, A,24482 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Ramos, Roberto, M,13159 | 208.18 | 0.00 | 0.00 | 0.00 | 208.18 |
| Sanz, Sabrina, A,19650 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Rai, Shaun,26431 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Raje, Donna, A,20607 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Tang, Shawn,25832 | 1850.86 | 0.00 | 699.10 | 0.00 | 1151.76 |
| Suarez, Joy, B,12665 | 74.54 | 0.00 | 0.00 | 0.00 | 74.54 |
| Barnes, Isabella, J,25239 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Shen, Jaclyn, A,12575 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| Romero, Frank, M,15209 | 2916.56 | 0.00 | 0.00 | 2049.10 | 867.46 |
| Zhu, Colleen,17252 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Zhang, Ramon, D,12352 | 274.24 | 0.00 | 0.00 | 0.00 | 274.24 |
| Navarro, Jacquelyn,15465 | 40.23 | 0.00 | 0.00 | 29.99 | 10.24 |
| Madan, Ronald,25828 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Jai, Carl,27597 | 564.21 | 0.00 | 0.00 | 0.00 | 564.21 |
| Martin, Joe,14668 | 5216.69 | 0.00 | 0.00 | 2071.42 | 3145.27 |
| Sanz, Craig, M,21993 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Nelson, Kaitlyn, J,24276 | 23.97 | 0.00 | 0.00 | 23.97 | 0.00 |
| Black, Tracy, B,24903 | 2164.91 | 0.00 | 0.00 | 2164.91 | 0.00 |
| Lopez, Terrance, T,14217 | 139.45 | 0.00 | 0.00 | 89.46 | 49.99 |
| Perez, Whitney,16619 | 97.58 | 0.00 | 0.00 | 67.59 | 29.99 |
| Young, Marcus, A,18494 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Sun, Micah,24887 | 2218.90 | 0.00 | 1000.44 | 1218.46 | 0.00 |
| Patel, Pamela, G,27875 | 1268.84 | 0.00 | 0.00 | 1268.84 | 0.00 |
| Hernandez, Jill, L,13003 | 230.25 | 0.00 | 0.00 | 6.28 | 223.97 |
| Sun, Krystal,18908 | 6090.59 | 0.00 | 3578.27 | 2512.32 | 0.00 |
| Ramos, Audrey,11976 | 8087.31 | 0.00 | 3374.99 | 2319.26 | 2393.06 |
| Martinez, Brett,23532 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Gomez, Alfredo, C,18200 | 4150.53 | 0.00 | 3578.27 | 0.00 | 572.26 |
| Rana, Whitney, A,13006 | 6762.15 | 0.00 | 0.00 | 2049.10 | 4713.05 |
| Johnsen, Willie,15218 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Nath, Grant, A,28947 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Brown, Kaitlyn,29120 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Raji, Brendan,13103 | 6842.60 | 0.00 | 0.00 | 2049.10 | 4793.50 |
| Weber, Deanna, L,14855 | 3759.08 | 0.00 | 0.00 | 2049.10 | 1709.98 |
| Rodriguez, Douglas, W,19652 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Yuan, Marshall, P,19978 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Lee, Dalton, J,16931 | 4767.73 | 3578.27 | 0.00 | 0.00 | 1189.46 |
| Lewis, Hannah,26561 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| He, Eugene, L,13645 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Lopez, Ross,18443 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Muñoz, Alberto, J,13008 | 125.51 | 0.00 | 0.00 | 0.00 | 125.51 |
| Gonzalez, Virginia,11929 | 4965.78 | 0.00 | 3374.99 | 0.00 | 1590.79 |
| Rodriguez, Kristi,14345 | 3639.92 | 0.00 | 0.00 | 2049.10 | 1590.82 |
Generated 2025-11-02 05:50:02.232 UTC