[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 20 < SKIP 500 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sun, Todd,22018 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Wilson, Edward, L,26562 | 1925.41 | 0.00 | 0.00 | 782.99 | 1142.42 |
| Wu, Alisha,23654 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Luo, Priscilla, R,17907 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Vazquez, Diane, D,11987 | 279.23 | 0.00 | 0.00 | 0.00 | 279.23 |
| Hernandez, Gina,14049 | 5290.68 | 0.00 | 0.00 | 2071.42 | 3219.26 |
| Zhao, Ernest, C,18700 | 5328.23 | 0.00 | 3578.27 | 1749.96 | 0.00 |
| Sanchez, Ross,28310 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raji, Jaime, L,15037 | 3856.38 | 0.00 | 0.00 | 2071.42 | 1784.96 |
| Nath, Ricardo, C,12039 | 8213.00 | 0.00 | 3374.99 | 0.00 | 4838.01 |
| Perez, Joel,16684 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Raje, Mario, S,20427 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Sullivan, Ruth,27723 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Suri, Ronald,18214 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Andersen, Jenny,20259 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Munoz, Shannon, S,29122 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Ramos, Marie, A,14308 | 5140.40 | 0.00 | 0.00 | 2049.10 | 3091.30 |
| Andersen, Maurice,15206 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Flores, Adam, L,11044 | 6515.30 | 0.00 | 3374.99 | 0.00 | 3140.31 |
| Xu, Kelsey, W,28220 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Jai, Kathryn,23546 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Zeng, Micah, A,25561 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Diaz, Gloria,25270 | 1854.58 | 699.10 | 0.00 | 0.00 | 1155.48 |
| Sanz, Paula,26430 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Tang, Rafael, A,11908 | 8079.05 | 0.00 | 3374.99 | 0.00 | 4704.06 |
| Gonzales, Alexis,23521 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Ramirez, Cole, E,13616 | 6872.06 | 0.00 | 0.00 | 2049.10 | 4822.96 |
| Hu, Omar, S,28954 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Guo, Jorge, L,26590 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Vazquez, Lawrence,19632 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Anderson, Victoria,15799 | 4423.38 | 0.00 | 0.00 | 2071.42 | 2351.96 |
| Zhu, Amy, W,26664 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Suri, Jarrod, E,12004 | 8114.04 | 0.00 | 3374.99 | 0.00 | 4739.05 |
| Ye, Marshall, R,26559 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Malhotra, Janelle,26425 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Luo, Roger, J,18728 | 56.71 | 0.00 | 0.00 | 0.00 | 56.71 |
| Schmidt, Pamela, I,24375 | 31.73 | 0.00 | 0.00 | 0.00 | 31.73 |
| Watson, Maria,17229 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 |
| Butler, Austin, W,18293 | 74.24 | 0.00 | 0.00 | 74.24 | 0.00 |
| Gill, Anne,27469 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Nath, Dale, B,27343 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Diaz, Megan, A,24303 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Sai, Martin, L,21221 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Raman, Patricia, T,16702 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Zheng, Dawn, F,19579 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Lal, Karla,25219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rodriguez, Dylan, E,16611 | 75.53 | 0.00 | 0.00 | 0.00 | 75.53 |
| Sanz, Linda, P,22945 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Zhao, Gilbert,23119 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Ye, Ramon,11357 | 4943.80 | 0.00 | 3374.99 | 0.00 | 1568.81 |
| Navarro, Teresa, E,25816 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Dominguez, Kristi, M,13644 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Goldstein, Brendan,13518 | 2638.36 | 0.00 | 0.00 | 2049.10 | 589.26 |
| Shen, Rafael, J,16689 | 290.46 | 0.00 | 0.00 | 0.00 | 290.46 |
| Nara, Grant,12995 | 6850.58 | 0.00 | 0.00 | 2049.10 | 4801.48 |
| Serrano, Javier, R,20256 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Alvarez, Randall,26750 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Shan, Sheena, J,21565 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Schmidt, Shane,17922 | 4821.72 | 0.00 | 3578.27 | 0.00 | 1243.45 |
| Sun, Jaclyn,18211 | 65.96 | 0.00 | 0.00 | 0.00 | 65.96 |
| Zhu, Vincent, E,24899 | 105.45 | 0.00 | 0.00 | 0.00 | 105.45 |
| Kumar, Michele,23107 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
Generated 2025-12-23 07:20:00.230 UTC