[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 24 > < TAKE 112 >
112 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rodriguez, Geoffrey,20817 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Gomez, Sheila, J,21165 | 4673.88 | 0.00 | 2181.56 | 0.00 | 2492.32 |
| Yang, Darryl, K,21571 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Chande, Katrina, L,19968 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Sullivan, Dominic, M,22840 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Gutierrez, Jaime, C,11457 | 8211.48 | 0.00 | 3374.99 | 0.00 | 4836.49 |
| Li, Alvin,26764 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Huang, Micah,25130 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Patel, Arthur, B,26671 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Nath, Bethany,16177 | 133.34 | 0.00 | 0.00 | 0.00 | 133.34 |
| Rodriguez, Arthur,15438 | 3788.68 | 0.00 | 0.00 | 2071.42 | 1717.26 |
| Rana, Carla, K,19593 | 5306.54 | 0.00 | 3578.27 | 0.00 | 1728.27 |
| Johnson, Emma, M,15136 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Cai, Karen,22572 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Patel, Summer, G,26753 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Ortega, Meghan, E,22004 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Coleman, Luis, L,14230 | 5661.90 | 0.00 | 0.00 | 2049.10 | 3612.80 |
| Alvarez, Arthur,24892 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Fernandez, Jay,20155 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Xu, Kelsey, W,28220 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Garcia, Donald,18929 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Kovar, Nancy, F,26568 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Ward, Brooke,13007 | 5671.24 | 0.00 | 0.00 | 2071.42 | 3599.82 |
| Chen, Alisha, J,14225 | 5603.92 | 0.00 | 0.00 | 2049.10 | 3554.82 |
| Xie, Kelli, J,20452 | 6156.70 | 0.00 | 3578.27 | 0.00 | 2578.43 |
| Ferrier, Edwin, J,15757 | 4366.41 | 0.00 | 0.00 | 2071.42 | 2294.99 |
| Chander, Gregory, J,22001 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Kapoor, Veronica, G,20253 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Suarez, Hector, L,15034 | 103.45 | 0.00 | 0.00 | 0.00 | 103.45 |
| Prasad, Cory,19748 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Liu, Brittney, M,15804 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| She, Lindsay,29456 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| West, James, M,15148 | 90.75 | 0.00 | 0.00 | 0.00 | 90.75 |
| Dominguez, Raquel, A,27470 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Suarez, Renee, L,12703 | 6891.12 | 0.00 | 0.00 | 2049.10 | 4842.02 |
| Jimenez, Joy,28312 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Munoz, Ebony,13106 | 5697.52 | 0.00 | 0.00 | 2071.42 | 3626.10 |
| Fernandez, Rachael, M,23993 | 3072.32 | 0.00 | 0.00 | 2443.35 | 628.97 |
| Zhou, Kelvin,20231 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Rivera, Nathaniel, M,14051 | 5606.91 | 0.00 | 0.00 | 3286.92 | 2319.99 |
| Arthur, Kristi, W,16675 | 4385.03 | 3578.27 | 0.00 | 0.00 | 806.76 |
| Fernandez, Nancy,14854 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Martin, Joe,14668 | 5216.69 | 0.00 | 0.00 | 2071.42 | 3145.27 |
| Srini, Kristopher, A,23997 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lin, Jeffery, J,27347 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Goel, Jodi,20447 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Hu, Leah,11994 | 8169.03 | 0.00 | 3374.99 | 0.00 | 4794.04 |
| Arthur, Johnathan,18730 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Russell, Ashley,12000 | 8183.00 | 0.00 | 3399.99 | 0.00 | 4783.01 |
| Jai, Alison,23657 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Munoz, Cheryl, C,13632 | 6838.46 | 0.00 | 0.00 | 2071.42 | 4767.04 |
| Lopez, Bruce,23540 | 3626.82 | 0.00 | 0.00 | 2443.35 | 1183.47 |
| Black, Tonya, M,21254 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Srini, Darren, P,15591 | 4346.38 | 0.00 | 0.00 | 2049.10 | 2297.28 |
| Alonso, Teresa,13138 | 83.97 | 0.00 | 0.00 | 3.99 | 79.98 |
| Gao, Eugene,29464 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Gao, Laura,22029 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Martin, Hector,27860 | 615.47 | 0.00 | 0.00 | 0.00 | 615.47 |
| Vazquez, Rodney, M,13047 | 241.93 | 0.00 | 0.00 | 0.00 | 241.93 |
| Lee, David, J,22199 | 4693.88 | 0.00 | 0.00 | 2181.56 | 2512.32 |
| Fernandez, Ivan,22032 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Zhao, Colin, D,24241 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Chandra, Troy,21406 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Romero, Philip, F,22195 | 4909.67 | 0.00 | 0.00 | 2443.35 | 2466.32 |
| Zhou, Clayton,27348 | 1382.46 | 0.00 | 0.00 | 782.99 | 599.47 |
| Diaz, Devin, D,15829 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Davis, Ryan, C,27870 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Peterson, Lucas,17298 | 174.45 | 0.00 | 0.00 | 0.00 | 174.45 |
| He, Brent, R,25712 | 1262.06 | 0.00 | 699.10 | 0.00 | 562.96 |
| Zimmerman, Tiffany, E,23325 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Henderson, Cassidy,21228 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Zhang, Lacey, L,14127 | 3809.57 | 0.00 | 0.00 | 2049.10 | 1760.47 |
| Raman, Deanna, H,17053 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Sullivan, Kaitlin,16919 | 70.95 | 0.00 | 0.00 | 0.00 | 70.95 |
| Carlson, Joanna,15594 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Zhu, Edwin,27148 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Srini, Roy,24888 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Ye, Dennis, M,16638 | 5974.23 | 0.00 | 3578.27 | 0.00 | 2395.96 |
| Yuan, Carl, P,24160 | 3046.84 | 0.00 | 0.00 | 2443.35 | 603.49 |
| Blanco, Brandi, L,20986 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Cai, Warren,24918 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Zhang, Suzanne, R,20316 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Dominguez, Micheal,26142 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Gutierrez, Dana,20254 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Stone, Keith,17331 | 40.96 | 0.00 | 0.00 | 0.00 | 40.96 |
| Moreno, Randall, F,21209 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Dominguez, Gina, L,20213 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Prasad, Ross,28963 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Sharma, Arturo,13648 | 6765.44 | 0.00 | 0.00 | 2049.10 | 4716.34 |
| Ramos, Leslie,15733 | 4443.55 | 0.00 | 0.00 | 2049.10 | 2394.45 |
| Ross, Connor, J,20816 | 4228.72 | 0.00 | 3578.27 | 0.00 | 650.45 |
| Muñoz, Pedro, A,23433 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Rodriguez, Jonathan, J,13046 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Shen, Karla, E,22925 | 134.93 | 0.00 | 0.00 | 0.00 | 134.93 |
| Prasad, Preston, C,20812 | 4127.25 | 0.00 | 3578.27 | 0.00 | 548.98 |
| Alexander, David,15783 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Zheng, Jamie, L,22156 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ortega, Joanna,17909 | 4761.74 | 0.00 | 3578.27 | 0.00 | 1183.47 |
| Li, Margaret,15753 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Ward, Nathaniel,25233 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Martin, Pedro, B,28103 | 1214.85 | 0.00 | 0.00 | 0.00 | 1214.85 |
| Lal, Barbara, W,23101 | 2795.01 | 0.00 | 0.00 | 2181.56 | 613.45 |
| Rogers, Anna,21201 | 4921.69 | 0.00 | 2443.35 | 0.00 | 2478.34 |
| Shan, Jenny, W,16706 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Sanchez, Levi, A,27745 | 617.47 | 0.00 | 0.00 | 617.47 | 0.00 |
| Romero, Ricky,21361 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Lal, Rafael, W,28945 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Wang, Micah, C,14676 | 5188.41 | 0.00 | 0.00 | 2049.10 | 3139.31 |
| Arthur, Regina, A,19089 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Rivera, Steven, T,19083 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Carson, Kelvin, A,11995 | 8249.01 | 0.00 | 3399.99 | 0.00 | 4849.02 |
| Malhotra, Darren, L,20245 | 6085.59 | 0.00 | 3578.27 | 0.00 | 2507.32 |
Generated 2025-12-22 02:07:41.048 UTC