[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 15 < SKIP 750 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Johnson, Chloe, L,20617 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Kapoor, Patricia, R,21883 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Gutierrez, Dana,20254 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Black, Tonya, M,21254 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Zhu, Colin,19973 | 83.44 | 0.00 | 0.00 | 0.00 | 83.44 |
| Pal, Jenny,15132 | 151.94 | 0.00 | 0.00 | 0.00 | 151.94 |
| Lopez, Darren,29081 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Goel, Katie, D,27708 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Zhang, Louis, K,20227 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Kumar, Bethany,29299 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Vance, Marco,13124 | 87.93 | 0.00 | 0.00 | 0.00 | 87.93 |
| Gill, Stacy,12679 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Suarez, Erika,15120 | 5217.70 | 0.00 | 0.00 | 2049.10 | 3168.60 |
| She, Lindsay,29456 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Carlson, Audrey, A,25263 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Gutierrez, Clinton,21001 | 3018.33 | 0.00 | 2443.35 | 0.00 | 574.98 |
| Martin, Pedro, B,28103 | 1214.85 | 0.00 | 0.00 | 0.00 | 1214.85 |
| Alvarez, Janet, G,11006 | 8119.03 | 3399.99 | 0.00 | 2334.97 | 2384.07 |
| Gonzalez, Heidi, Z,13157 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Fernandez, Jay,20155 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Ramos, Jaime,15720 | 70.22 | 0.00 | 0.00 | 0.00 | 70.22 |
| Gill, Sheila, B,17375 | 24.49 | 0.00 | 0.00 | 0.00 | 24.49 |
| Weber, Cory,16739 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Raman, Brandy,12247 | 77.27 | 0.00 | 0.00 | 49.99 | 27.28 |
| Yuan, Keith, N,22926 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Rubio, Nelson,26433 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Alvarez, Marc, B,18221 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Alonso, Kathleen,21196 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Rodriguez, Dylan, E,16611 | 75.53 | 0.00 | 0.00 | 0.00 | 75.53 |
| Lal, Cristina, M,14671 | 2934.37 | 0.00 | 0.00 | 2071.42 | 862.95 |
| Yang, Louis, J,23013 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Hernandez, Wendy, A,15124 | 122.44 | 0.00 | 0.00 | 0.00 | 122.44 |
| Moreno, Diana, J,29298 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Dominguez, Leslie,27346 | 1390.95 | 0.00 | 0.00 | 782.99 | 607.96 |
| Foster, Madison,14038 | 6819.12 | 0.00 | 0.00 | 2049.10 | 4770.02 |
| Kovar, Mayra, J,17312 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 |
| Alonso, Danny, S,18217 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Martinez, Edgar, B,18741 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Chande, Alvin, W,24893 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Raje, Ashlee, E,16658 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Nath, Katie, A,23434 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Johnston, Joanna, L,17296 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Martinez, Tina, J,18461 | 4748.24 | 0.00 | 3578.27 | 0.00 | 1169.97 |
| Diaz, Megan, A,24303 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Sanz, Diane, M,20153 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ramos, Kristine,17479 | 163.40 | 0.00 | 0.00 | 0.00 | 163.40 |
| Raman, Roy,16348 | 5918.24 | 3578.27 | 0.00 | 0.00 | 2339.97 |
| Romero, Jacquelyn,25815 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ruiz, Leslie, J,26032 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lin, Darryl, J,15031 | 41.27 | 0.00 | 0.00 | 0.00 | 41.27 |
| Sanz, Larry,14067 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Li, Crystal, L,14325 | 5152.70 | 0.00 | 0.00 | 2049.10 | 3103.60 |
| Foster, Lucas,13519 | 4492.45 | 0.00 | 0.00 | 4492.45 | 0.00 |
| Zhang, Edwin,15785 | 4454.35 | 0.00 | 0.00 | 2071.42 | 2382.93 |
| Andersen, Nina,18338 | 6124.58 | 0.00 | 3578.27 | 0.00 | 2546.31 |
| Patel, Arthur, B,26671 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Townsend, Larry, D,11134 | 4911.83 | 0.00 | 3399.99 | 0.00 | 1511.84 |
| Fernandez, Kristi,19585 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Ms., Sherwood, Irma, J.,24598 | 4228.31 | 0.00 | 0.00 | 2443.35 | 1784.96 |
| Beck, Barbara,26547 | 1407.96 | 0.00 | 0.00 | 782.99 | 624.97 |
| Suri, Mayra, M,15729 | 4393.70 | 0.00 | 0.00 | 2071.42 | 2322.28 |
| Clark, Madison, A,14062 | 5647.92 | 0.00 | 0.00 | 2049.10 | 3598.82 |
| Chander, Julie, E,18763 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Diaz, Randall, T,29345 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Serrano, Kristi,20616 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Raje, Dale, H,27746 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Ross, Adam,11099 | 8215.99 | 0.00 | 3399.99 | 0.00 | 4816.00 |
| Chen, Steve, R,18902 | 4186.23 | 0.00 | 3578.27 | 607.96 | 0.00 |
| Hernandez, Mathew, A,15184 | 4441.38 | 0.00 | 0.00 | 2071.42 | 2369.96 |
| Chandra, Virginia, M,27588 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Hernandez, Alberto, D,25029 | 2272.20 | 0.00 | 0.00 | 1000.44 | 1271.76 |
| Zhao, Kristen,16930 | 7.95 | 0.00 | 0.00 | 0.00 | 7.95 |
| Rivera, Mariah,20261 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Zheng, Erica, K,23643 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martinez, Monica, A,14129 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Bryant, Madison, J,16481 | 194.91 | 0.00 | 0.00 | 0.00 | 194.91 |
| Madan, Summer, D,12347 | 6839.12 | 0.00 | 2049.10 | 0.00 | 4790.02 |
| Jordan, Ross, F,11124 | 8129.02 | 0.00 | 3399.99 | 2309.97 | 2419.06 |
| Martinez, Sarah, S,12670 | 6785.13 | 0.00 | 0.00 | 2049.10 | 4736.03 |
| Sullivan, Henry, L,20603 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Liu, Dennis,29062 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Hernandez, Beth, L,29084 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Perez, Janelle,16172 | 186.04 | 0.00 | 0.00 | 0.00 | 186.04 |
| Sanchez, George, M,12680 | 6880.10 | 0.00 | 0.00 | 2049.10 | 4831.00 |
| Luo, Dustin,17240 | 4385.03 | 0.00 | 3578.27 | 0.00 | 806.76 |
| Raman, Cassandra,28718 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Alvarez, Kari, C,11108 | 8124.04 | 0.00 | 3374.99 | 2329.99 | 2419.06 |
| Russell, Jonathan,18896 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Navarro, Jonathon,18722 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Ye, Ramon,11357 | 4943.80 | 0.00 | 3374.99 | 0.00 | 1568.81 |
| Zheng, Curtis, S,23645 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Wu, Clarence, L,13115 | 6779.42 | 0.00 | 0.00 | 2049.10 | 4730.32 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Vazquez, Marie,21899 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| He, Amy,22411 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Lu, Warren, H,28925 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Vazquez, Victor, R,29453 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Gonzalez, Brandy,27368 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Van, Brenda, J,24890 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lin, Rafael,14099 | 200.26 | 0.00 | 0.00 | 0.00 | 200.26 |
| Jai, Brendan,26755 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Luo, Shawn,12246 | 3947.25 | 0.00 | 3374.99 | 0.00 | 572.26 |
| Schmidt, Pamela, I,24375 | 31.73 | 0.00 | 0.00 | 0.00 | 31.73 |
| Lu, Ramon, B,16738 | 44.95 | 0.00 | 0.00 | 0.00 | 44.95 |
| Alonso, Renee,24166 | 2789.52 | 0.00 | 0.00 | 2181.56 | 607.96 |
| Torres, Gina,17904 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Blanco, Lee, M,16660 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Raman, Rachael,25216 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Sara, Jarrod,20626 | 6038.56 | 0.00 | 3578.27 | 0.00 | 2460.29 |
| Thompson, Cameron, M,16620 | 5895.24 | 3578.27 | 0.00 | 0.00 | 2316.97 |
| Chapman, Alicia, A,21418 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Xie, Chad, A,26155 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Gill, Byron, J,18483 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Martin, Hector,27860 | 615.47 | 0.00 | 0.00 | 0.00 | 615.47 |
| Kumar, Alejandro,14055 | 5177.40 | 0.00 | 0.00 | 2049.10 | 3128.30 |
| Coleman, Nicole, A,21558 | 4919.30 | 0.00 | 0.00 | 2443.35 | 2475.95 |
| Blanco, Micheal, A,11113 | 109.88 | 0.00 | 0.00 | 49.97 | 59.91 |
| Sun, Jorge,16025 | 3831.89 | 0.00 | 0.00 | 2071.42 | 1760.47 |
| Mehta, Heidi,14226 | 5656.24 | 0.00 | 0.00 | 2071.42 | 3584.82 |
| Liu, Glenn,18899 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Zhou, Stacey, L,21374 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ma, Colin,26428 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Pal, Arturo, P,29303 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Cai, Steve, M,22155 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Rubio, Natasha, K,13627 | 214.25 | 0.00 | 0.00 | 0.00 | 214.25 |
Generated 2025-12-24 07:04:53.461 UTC