[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gray, Faith,22914 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Andersen, Willie, M,27970 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Ramos, Joe,12353 | 6765.46 | 0.00 | 2071.42 | 0.00 | 4694.04 |
| Liu, Autumn, J,20985 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Serrano, Julio,20992 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Pal, Casey,16522 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Ruiz, Bruce, W,16171 | 103.86 | 0.00 | 0.00 | 0.00 | 103.86 |
| Fernandez, Brenda, L,16493 | 4197.25 | 3578.27 | 0.00 | 0.00 | 618.98 |
| Liang, Martha,16525 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Suarez, Jacquelyn, C,11010 | 8088.04 | 3399.99 | 0.00 | 2294.99 | 2393.06 |
| Holt, Krystal,16518 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Prasad, Darren,12372 | 99.03 | 0.00 | 0.00 | 89.46 | 9.57 |
| Ms., Schultz, Barbara, R.,15811 | 71.16 | 0.00 | 0.00 | 0.00 | 71.16 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 0.00 | 1179.97 |
| Sai, Troy,16515 | 4733.75 | 3578.27 | 0.00 | 1155.48 | 0.00 |
| Jimenez, Latasha, E,13121 | 121.25 | 0.00 | 0.00 | 0.00 | 121.25 |
| Serrano, Derrick,16707 | 4377.75 | 3578.27 | 0.00 | 0.00 | 799.48 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Ramos, Francis,16345 | 4173.24 | 3578.27 | 0.00 | 0.00 | 594.97 |
| Xu, Barbara,29195 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Cai, Cedric,19559 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Thompson, Fernando,16350 | 5903.19 | 3578.27 | 0.00 | 0.00 | 2324.92 |
| Simmons, Jordyn,16494 | 5961.20 | 3578.27 | 0.00 | 0.00 | 2382.93 |
| Sharma, Raul, E,16347 | 5918.50 | 3578.27 | 0.00 | 0.00 | 2340.23 |
| Gutierrez, Desiree,15216 | 101.74 | 0.00 | 0.00 | 27.28 | 74.46 |
| Sai, Molly,14683 | 98.95 | 0.00 | 0.00 | 18.97 | 79.98 |
| Jackson, Eduardo, C,11749 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| Bailey, Melissa, C,19572 | 82.25 | 0.00 | 0.00 | 0.00 | 82.25 |
| Gao, Stacey,16662 | 4355.71 | 3578.27 | 0.00 | 777.44 | 0.00 |
| Li, Elijah,16740 | 6099.10 | 3578.27 | 0.00 | 2520.83 | 0.00 |
| Jones, Emily,16659 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Arthur, Kristi, W,16675 | 4385.03 | 3578.27 | 0.00 | 806.76 | 0.00 |
| Romero, Renee, E,16639 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Dominguez, Wendy,11035 | 6451.31 | 3374.99 | 0.00 | 0.00 | 3076.32 |
| Perez, Joel,16684 | 4158.24 | 3578.27 | 0.00 | 0.00 | 579.97 |
| Sanchez, Denise,16703 | 6090.59 | 3578.27 | 0.00 | 2512.32 | 0.00 |
| Shan, Mario,25271 | 1854.58 | 699.10 | 0.00 | 0.00 | 1155.48 |
| Scott, Savannah, E,16929 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Nath, Jaime,11033 | 6495.29 | 3374.99 | 0.00 | 0.00 | 3120.30 |
| Stewart, Bryan, M,16928 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Lee, Dalton, J,16931 | 4767.73 | 3578.27 | 0.00 | 0.00 | 1189.46 |
| Sai, Preston, D,17046 | 4467.74 | 3578.27 | 0.00 | 0.00 | 889.47 |
| Pal, Mitchell, R,16742 | 6044.59 | 3578.27 | 0.00 | 2466.32 | 0.00 |
| Gomez, Tabitha, L,16688 | 6081.10 | 3578.27 | 0.00 | 2502.83 | 0.00 |
| Lu, Krystal,17049 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Luo, Ashlee,23534 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Ma, Franklin,24485 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Munoz, Cheryl, C,13632 | 6838.46 | 0.00 | 0.00 | 2071.42 | 4767.04 |
| Munoz, Theresa, M,13953 | 6840.75 | 0.00 | 0.00 | 2071.42 | 4769.33 |
| Watson, Maria,17229 | 4471.74 | 3578.27 | 0.00 | 0.00 | 893.47 |
| Sanders, Arianna, E,22859 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perez, Evelyn,14346 | 3583.26 | 0.00 | 0.00 | 2071.42 | 1511.84 |
| Lopez, Adriana, A,12002 | 8145.33 | 0.00 | 3374.99 | 0.00 | 4770.34 |
| Gomez, Anne,13045 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Liang, Margaret,17254 | 147.48 | 0.00 | 0.00 | 93.49 | 53.99 |
| Alvarez, Tanya,17279 | 6021.62 | 3578.27 | 0.00 | 0.00 | 2443.35 |
| Huang, Jake,19589 | 95.26 | 0.00 | 0.00 | 0.00 | 95.26 |
| Raman, Mayra, P,20990 | 4196.22 | 0.00 | 3578.27 | 0.00 | 617.95 |
| Rivera, Steven, T,19083 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Gao, Rafael, R,18733 | 24.27 | 0.00 | 0.00 | 2.29 | 21.98 |
Generated 2025-11-03 06:48:36.340 UTC