[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1126 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Kapoor, Cesar, J,24302 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Liu, Bianca, K,11458 | 31.92 | 0.00 | 0.00 | 0.00 | 31.92 |
| Nelson, Fernando, G,25564 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Navarro, Kristine, B,25566 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Simmons, Gabrielle,29183 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Shan, Bethany, L,13973 | 5185.68 | 0.00 | 0.00 | 2071.42 | 3114.26 |
| Sai, Ronald, B,13643 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Martin, Alyssa,19587 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Andersen, Shawna, C,19556 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Suri, Ronald,18214 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Sanchez, Carla,18274 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Rai, Nina,14018 | 63.87 | 0.00 | 0.00 | 0.00 | 63.87 |
| Kapoor, Veronica, G,20253 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Gomez, Naomi, E,24300 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Sara, Tina,24307 | 4158.32 | 0.00 | 0.00 | 2443.35 | 1714.97 |
| She, Bridget, M,19557 | 5358.24 | 0.00 | 3578.27 | 0.00 | 1779.97 |
| Perez, Patricia,25022 | 1564.92 | 0.00 | 0.00 | 1000.44 | 564.48 |
| Alan, Meghan, I,28210 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Martinez, Heidi, L,22922 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Raman, Frederick, F,28942 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Black, Peter, E,21213 | 64.26 | 0.00 | 0.00 | 0.00 | 64.26 |
| She, Rosa,18931 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Huang, Alan, A,12671 | 6802.13 | 0.00 | 0.00 | 2049.10 | 4753.03 |
| Raji, Andres, E,13955 | 6888.44 | 0.00 | 0.00 | 2071.42 | 4817.02 |
| Yang, Rosa,18713 | 237.26 | 0.00 | 0.00 | 0.00 | 237.26 |
| Xu, Tonya,17324 | 80.94 | 0.00 | 0.00 | 0.00 | 80.94 |
| Li, Wesley,23322 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Chandra, Carmen, R,23315 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Vazquez, Joanna, J,11990 | 8164.01 | 0.00 | 3374.99 | 0.00 | 4789.02 |
| Moreno, Kathleen, C,15234 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Srini, Deanna,15182 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Sullivan, Kaitlin,16919 | 70.95 | 0.00 | 0.00 | 0.00 | 70.95 |
| Butler, Gavin, D,22949 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Subram, Adriana,23424 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Kovár, Barry, A,21570 | 4705.48 | 0.00 | 0.00 | 2181.56 | 2523.92 |
| Foster, Hunter, A,20269 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chander, Lindsay, R,19972 | 49.70 | 0.00 | 0.00 | 0.00 | 49.70 |
| Deng, Sheena,19099 | 6038.56 | 0.00 | 3578.27 | 0.00 | 2460.29 |
| Zhou, Colleen,23122 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Powell, Elizabeth, K,28306 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cooper, Allison, J,29294 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Munoz, Shannon, S,29122 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Ashe, Brad,25228 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Hernandez, Alberto, D,25029 | 2272.20 | 0.00 | 0.00 | 1000.44 | 1271.76 |
| Gutierrez, Kristine, G,25133 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Lu, Susan, C,12357 | 93.45 | 0.00 | 0.00 | 0.00 | 93.45 |
| Sanchez, Bryant, C,13113 | 6832.41 | 0.00 | 0.00 | 2071.42 | 4760.99 |
| Shen, Willie, S,18450 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Ortega, Gloria, R,19558 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Raje, Lacey, T,12358 | 6787.76 | 0.00 | 2071.42 | 0.00 | 4716.34 |
| Xu, Glenn,18743 | 67.21 | 0.00 | 0.00 | 0.00 | 67.21 |
| Ye, Edwin,18334 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Andersen, Lacey,19600 | 94.46 | 0.00 | 0.00 | 0.00 | 94.46 |
| Zheng, Kristen, J,24463 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Sara, Carmen, W,12582 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Madan, Martin, M,24911 | 102.96 | 0.00 | 0.00 | 0.00 | 102.96 |
| He, Dawn,15647 | 3764.07 | 0.00 | 0.00 | 2049.10 | 1714.97 |
| Raje, Bonnie,20629 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Ye, Ramon,11357 | 4943.80 | 0.00 | 3374.99 | 0.00 | 1568.81 |
| Campbell, Jason, J,13625 | 6962.14 | 0.00 | 0.00 | 2049.10 | 4913.04 |
| Hu, Alejandro,13125 | 138.54 | 0.00 | 0.00 | 0.00 | 138.54 |
| Serrano, Dwayne,16695 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
Generated 2025-12-22 02:09:54.222 UTC