[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 20 < SKIP 500 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanz, Theodore, M,16492 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gonzalez, Carla, J,18336 | 6145.07 | 0.00 | 3578.27 | 0.00 | 2566.80 |
| Xu, Keith, J,25124 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Raman, Johnathan,19103 | 63.91 | 0.00 | 0.00 | 0.00 | 63.91 |
| Sun, Dennis, K,24481 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Cai, Jeffery, A,15582 | 2907.56 | 0.00 | 0.00 | 2049.10 | 858.46 |
| Yang, Randy, E,24000 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Gill, Roy,29465 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Prasad, Carmen, L,18928 | 6095.08 | 0.00 | 3578.27 | 0.00 | 2516.81 |
| Suarez, Renee, L,12703 | 6891.12 | 0.00 | 0.00 | 2049.10 | 4842.02 |
| Mehta, Levi, M,13110 | 5583.94 | 0.00 | 0.00 | 2049.10 | 3534.84 |
| Guo, Jamie,20151 | 4152.73 | 0.00 | 3578.27 | 0.00 | 574.46 |
| Huang, Margaret, H,17070 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Martinez, Bruce, D,18452 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Li, Kristen, R,15153 | 113.97 | 0.00 | 0.00 | 0.00 | 113.97 |
| Chande, Franklin, L,20232 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Chandra, Rebekah,28486 | 776.33 | 0.00 | 0.00 | 0.00 | 776.33 |
| Mehta, Carla, L,21563 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Zhu, Tiffany,26437 | 1953.47 | 0.00 | 0.00 | 782.99 | 1170.48 |
| Navarro, Melinda,11454 | 8089.04 | 0.00 | 3374.99 | 2294.99 | 2419.06 |
| Mehta, Preston, G,18692 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Luo, Warren,23562 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Johnson, Emma, M,15136 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Becker, Kelsey, G,11968 | 8079.05 | 0.00 | 3399.99 | 0.00 | 4679.06 |
| Jiménez, Alberto, C,15215 | 4468.56 | 0.00 | 0.00 | 2049.10 | 2419.46 |
| Lopez, Manuel, M,14050 | 5650.24 | 0.00 | 0.00 | 3295.26 | 2354.98 |
| Serrano, Deanna, W,15144 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Gomez, Teresa, D,24164 | 2760.02 | 0.00 | 0.00 | 2181.56 | 578.46 |
| Raman, Deanna, H,17053 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Deng, Russell, J,20314 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Munoz, Monique,24008 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Carlson, Lance, E,22856 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raji, Lindsey,18205 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Dominguez, Stacy, S,19105 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| Alvarez, Max, M,11986 | 8245.23 | 0.00 | 3399.99 | 0.00 | 4845.24 |
| Garcia, Jermaine,21566 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Wang, Roger, P,24605 | 3627.81 | 0.00 | 0.00 | 3627.81 | 0.00 |
| Vazquez, Rodney, M,13047 | 241.93 | 0.00 | 0.00 | 0.00 | 241.93 |
| Vazquez, Marie,21899 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Navarro, Lori,21182 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Yuan, Colin,11758 | 58.05 | 0.00 | 0.00 | 0.00 | 58.05 |
| Gao, Randy,25113 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Alonso, Jerome, H,27977 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Shan, Bethany, L,13973 | 5185.68 | 0.00 | 0.00 | 2071.42 | 3114.26 |
| Jai, Dylan, J,23128 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Perez, Evelyn,14346 | 3583.26 | 0.00 | 0.00 | 2071.42 | 1511.84 |
| He, Karen, C,27861 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Blanco, Larry, E,21216 | 4935.67 | 0.00 | 2443.35 | 0.00 | 2492.32 |
| Sai, Monica, L,29055 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Chande, Cassie,11103 | 8182.50 | 0.00 | 3374.99 | 2388.45 | 2419.06 |
| Liu, Warren,15014 | 3860.87 | 0.00 | 0.00 | 2071.42 | 1789.45 |
| Ramos, Meredith, A,23307 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Adams, Savannah,23536 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Becker, Julie,13614 | 114.21 | 0.00 | 0.00 | 0.00 | 114.21 |
| Liu, Micah, J,15220 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Romero, Ricky,21361 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Cai, Amy,24920 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Powell, Jeremy,11048 | 6498.24 | 0.00 | 3374.99 | 0.00 | 3123.25 |
| Zhu, Alisha, G,18239 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Munoz, Marvin,14680 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Evans, Mason,15439 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Barnes, Alexia, D,15231 | 59.48 | 0.00 | 0.00 | 0.00 | 59.48 |
| Hernandez, Wendy, A,15124 | 122.44 | 0.00 | 0.00 | 0.00 | 122.44 |
| Hernandez, Joe,15154 | 84.98 | 0.00 | 0.00 | 0.00 | 84.98 |
| Alvarez, Diana,13638 | 6832.12 | 0.00 | 0.00 | 2049.10 | 4783.02 |
| Ray, Bobby,23575 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Lopez, Kristina, L,20247 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Sharma, Cedric, A,14060 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Sanchez, Terrance,19584 | 116.74 | 0.00 | 0.00 | 88.97 | 27.77 |
| Ruiz, Alberto, L,25212 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Anand, Jodi,26129 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Moreno, Latasha, R,18735 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Malhotra, Marco, L,29459 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Zimmerman, Tiffany, E,23325 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Garcia, Troy, M,29290 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rana, Molly,21554 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Ms., Seidel, Birgit,16621 | 73.86 | 0.00 | 0.00 | 0.00 | 73.86 |
| Mrs., Nara, Barbara,12704 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Raman, Summer, C,25949 | 1882.57 | 0.00 | 699.10 | 0.00 | 1183.47 |
| Wu, Shannon, F,15268 | 2840.91 | 0.00 | 0.00 | 2071.42 | 769.49 |
| Ruiz, Sabrina, A,22214 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Johnsen, Eddie,28935 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Gill, Joanna,26186 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Tang, Sharon, M,15823 | 67.96 | 0.00 | 0.00 | 0.00 | 67.96 |
| Jimenez, Gary, E,16609 | 344.04 | 0.00 | 0.00 | 84.95 | 259.09 |
| Navarro, Eddie, C,24504 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Munoz, Meredith,13957 | 5645.24 | 0.00 | 0.00 | 2071.42 | 3573.82 |
| Stewart, Margaret, C,29096 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Raje, Lacey, T,12358 | 6787.76 | 0.00 | 2071.42 | 0.00 | 4716.34 |
| Kelly, Emma, A,15646 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Prasad, Ross,28963 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Lal, Cristina, M,14671 | 2934.37 | 0.00 | 0.00 | 2071.42 | 862.95 |
| Gonzalez, Edgar, A,15648 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Ye, Gilbert,29344 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Chande, Latoya, M,23309 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Gill, Eddie, J,12715 | 74.54 | 0.00 | 0.00 | 0.00 | 74.54 |
| Patel, Abby,16029 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Sun, Lacey, L,15131 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Luo, Bethany,19582 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Kumar, Mindy, R,12700 | 6860.44 | 0.00 | 0.00 | 2071.42 | 4789.02 |
| Mehta, Tina, C,11444 | 8136.02 | 0.00 | 3374.99 | 2376.96 | 2384.07 |
| Taylor, Logan,13522 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Serrano, Francis, R,23547 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Hu, Susan,25242 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Raji, Donna,24906 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Edwards, Evan, L,21888 | 4925.58 | 0.00 | 0.00 | 2443.35 | 2482.23 |
| Ross, Brandon,14132 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Ruiz, Frank, M,14260 | 3716.23 | 0.00 | 0.00 | 2071.42 | 1644.81 |
| Ramos, Jerome, L,29187 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Wu, Margaret,28928 | 2473.05 | 0.00 | 0.00 | 0.00 | 2473.05 |
| Suri, Patricia, E,15436 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Gonzales, Alexis,23521 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Rai, Sharon,20225 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Gill, Billy, L,16700 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Lin, Dennis,16169 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Gao, Lisa, A,19753 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Jay,19597 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Ferrier, Edwin, J,15757 | 4366.41 | 0.00 | 0.00 | 2071.42 | 2294.99 |
| Diaz, Randall, T,29345 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Rowe, Jacquelyn, I,13615 | 146.91 | 0.00 | 0.00 | 7.95 | 138.96 |
| Prasad, Preston, C,20812 | 4127.25 | 0.00 | 3578.27 | 0.00 | 548.98 |
| Jimenez, Melody, S,14066 | 3612.19 | 0.00 | 0.00 | 2853.57 | 758.62 |
| Ye, Lacey,29090 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Lal, Alisha, C,21872 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
Generated 2025-12-23 05:06:56.062 UTC