[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 2500 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzalez, Heidi, Z,13157 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Rai, Rafael, H,18715 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Jai, Alison,23657 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nelson, Kaitlyn, J,24276 | 23.97 | 0.00 | 0.00 | 23.97 | 0.00 |
| Goel, Katie, D,27708 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Romero, Clinton, F,28132 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Gao, Eugene,29464 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Lewis, Kayla,12013 | 3949.97 | 0.00 | 3399.99 | 549.98 | 0.00 |
| Liu, Candice,28720 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Suri, Rachael, J,18279 | 162.02 | 0.00 | 0.00 | 0.00 | 162.02 |
| Chander, Tonya,15794 | 113.97 | 0.00 | 0.00 | 88.98 | 24.99 |
| Coleman, Brittany,15579 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Sun, Clayton,28533 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Zhang, Cara,12351 | 117.97 | 0.00 | 0.00 | 0.00 | 117.97 |
| Suri, Evelyn, A,21223 | 56.98 | 0.00 | 0.00 | 56.98 | 0.00 |
| Prasad, Arthur,14275 | 5158.37 | 0.00 | 0.00 | 2800.44 | 2357.93 |
| Yang, Kevin, F,20605 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Alvarez, Pedro, E,28120 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Zhu, Jake, G,24603 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Coleman, Luis, L,14230 | 5661.90 | 0.00 | 0.00 | 2049.10 | 3612.80 |
| Martin, Byron, E,25217 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wu, Arturo, A,28321 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Zhang, James,14684 | 38.55 | 0.00 | 0.00 | 0.00 | 38.55 |
| Yang, Alan, L,15605 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Vazquez, Randall, Z,21186 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Shen, Bonnie,21405 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Subram, Ross, L,23085 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Yang, Wesley, K,15127 | 5182.73 | 0.00 | 0.00 | 2071.42 | 3111.31 |
| Simmons, Isabel, H,26432 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Rubio, Walter, R,25912 | 63.47 | 0.00 | 0.00 | 0.00 | 63.47 |
| Guo, Jorge, L,26590 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Patterson, Jennifer, M,15129 | 5177.73 | 0.00 | 0.00 | 2071.42 | 3106.31 |
| Blanco, Kari,19627 | 41.75 | 0.00 | 0.00 | 27.77 | 13.98 |
| Becker, Grant,21390 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Xu, Lindsey,15583 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Zeng, Dawn, D,29455 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Mehta, Carolyn,28205 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Chande, Louis, A,16681 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Zhang, Jon,28111 | 865.31 | 0.00 | 0.00 | 0.00 | 865.31 |
| Romero, Frank, M,15209 | 2916.56 | 0.00 | 0.00 | 2049.10 | 867.46 |
| Zhu, Jenny, J,17078 | 186.94 | 0.00 | 0.00 | 186.94 | 0.00 |
| Smith, Thomas,17068 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Wu, Margaret,28928 | 2473.05 | 0.00 | 0.00 | 0.00 | 2473.05 |
| Jai, Carl,27597 | 564.21 | 0.00 | 0.00 | 0.00 | 564.21 |
| Liang, Steve,14317 | 81.26 | 0.00 | 0.00 | 49.99 | 31.27 |
| Garcia, Stefanie, E,27743 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Moyer, Meghan,21220 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Long, Megan, J,15791 | 42.26 | 0.00 | 0.00 | 24.99 | 17.27 |
| Gutierrez, Carrie, C,28139 | 127.28 | 0.00 | 0.00 | 0.00 | 127.28 |
| Liu, Brittney, M,15804 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Mehta, Patricia, K,29179 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Lopez, Francisco, L,18714 | 24.27 | 0.00 | 0.00 | 21.98 | 2.29 |
| Lopez, Isaac,27692 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Lu, Alan,19761 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Yang, Leah, J,15186 | 59.48 | 0.00 | 0.00 | 0.00 | 59.48 |
| Chande, Latoya, M,23309 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Alonso, Lance, I,14057 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Subram, Ronald, P,27733 | 157.29 | 0.00 | 0.00 | 0.00 | 157.29 |
| Rivera, Devin, J,25109 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ms., Robinson, Dorothy, B.,11952 | 8169.00 | 0.00 | 3374.99 | 2395.96 | 2398.05 |
| Huang, Tamara, E,14053 | 86.26 | 0.00 | 0.00 | 86.26 | 0.00 |
| Ramos, Sabrina, L,29082 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
Generated 2025-11-04 07:47:28.494 UTC