[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 442 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ye, Krystal, M,26923 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Chander, Keith, A,24174 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Perez, Bryant, L,15042 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Romero, Frank, M,15209 | 2916.56 | 0.00 | 0.00 | 2049.10 | 867.46 |
| Kumar, Derek, M,15135 | 4381.39 | 0.00 | 0.00 | 2071.42 | 2309.97 |
| Andersen, Brendan,15121 | 5202.73 | 0.00 | 0.00 | 2071.42 | 3131.31 |
| Hernandez, Krista, J,26918 | 1399.94 | 0.00 | 0.00 | 782.99 | 616.95 |
| Srini, Manuel,24168 | 2790.52 | 0.00 | 0.00 | 2181.56 | 608.96 |
| Wu, Shannon, F,15268 | 2840.91 | 0.00 | 0.00 | 2071.42 | 769.49 |
| Suri, Patricia, E,15436 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Alvarez, Kristy,15588 | 4486.07 | 0.00 | 0.00 | 2049.10 | 2436.97 |
| Gill, Javier,15645 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 |
| Kapoor, Cesar, J,24302 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Prasad, Ebony,24368 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Gonzalez, Natalie,25215 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Martin, Ebony, F,15223 | 4366.41 | 0.00 | 0.00 | 2071.42 | 2294.99 |
| Suri, Shane, L,25126 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Malhotra, Harold,15227 | 4469.56 | 0.00 | 0.00 | 2049.10 | 2420.46 |
| Rodriguez, Arthur,15438 | 3788.68 | 0.00 | 0.00 | 2071.42 | 1717.26 |
| Suarez, Nelson,27355 | 1383.45 | 0.00 | 0.00 | 782.99 | 600.46 |
| Prasad, Henry, M,24364 | 3965.52 | 0.00 | 0.00 | 2181.56 | 1783.96 |
| Dominguez, Leslie,27346 | 1390.95 | 0.00 | 0.00 | 782.99 | 607.96 |
| Ramos, Kristine,17479 | 163.40 | 0.00 | 0.00 | 0.00 | 163.40 |
| Navarro, Mallory,24365 | 3331.03 | 0.00 | 0.00 | 2181.56 | 1149.47 |
| Ramos, Robyn, O,15828 | 172.25 | 0.00 | 0.00 | 0.00 | 172.25 |
| Gutierrez, Jay, C,13155 | 226.95 | 0.00 | 0.00 | 0.00 | 226.95 |
| Pal, Alvin, C,29319 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Gutierrez, Cheryl, O,25213 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Sun, Christy,25218 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Gonzalez, Savannah, F,15644 | 3803.68 | 0.00 | 0.00 | 2071.42 | 1732.26 |
| Alan, Bob, A,27366 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Kelly, Emma, A,15646 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Wood, Richard, W,24377 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Fernandez, Donald, C,24462 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Sanz, Kari, V,27341 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Zhu, Erica,25221 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Ward, Jessica,15587 | 4423.38 | 0.00 | 0.00 | 2071.42 | 2351.96 |
| Jimenez, Teresa, L,24372 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Suarez, Briana, A,15266 | 2935.37 | 0.00 | 0.00 | 2071.42 | 863.95 |
| Raji, Damien, K,24282 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Suri, Marie,24281 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| He, Gilbert,15589 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Zheng, Aimee, H,24283 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Jiménez, Brandi,24378 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Torres, Michele, A,16176 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Raman, Brandy,12247 | 77.27 | 0.00 | 0.00 | 49.99 | 27.28 |
| Foster, Luke,15137 | 161.94 | 0.00 | 0.00 | 0.00 | 161.94 |
| Becker, Jenny,17290 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Xu, Kara, E,22212 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Serrano, Hector, K,28308 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Zheng, Erica, K,23643 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vance, George, R,12038 | 66.76 | 0.00 | 0.00 | 0.00 | 66.76 |
| Brooks, Jared,24476 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Guo, Cedric, R,27487 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Munoz, Sheila,27488 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Mr., Schmidt, Steve,15789 | 4486.07 | 0.00 | 0.00 | 2049.10 | 2436.97 |
| Travers, Alexa, A,24466 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Shan, Thomas, N,27483 | 1382.46 | 0.00 | 0.00 | 782.99 | 599.47 |
| Zheng, Barbara,27493 | 1353.46 | 0.00 | 0.00 | 782.99 | 570.47 |
| Price, Deb,24502 | 3623.32 | 0.00 | 0.00 | 2443.35 | 1179.97 |
| Liu, Kelli, A,24480 | 4175.61 | 0.00 | 0.00 | 2443.35 | 1732.26 |
| Hernandez, Erika,16160 | 2644.07 | 0.00 | 0.00 | 2049.10 | 594.97 |
| Torres, Monique,25235 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Martinez, Jay,24592 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Beck, Cedric, L,22403 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Perez, Dominique,12344 | 68.70 | 0.00 | 0.00 | 0.00 | 68.70 |
| Carlson, Joy,13981 | 124.21 | 0.00 | 0.00 | 0.00 | 124.21 |
| Blanco, Jimmy, V,14013 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Taylor, Christopher, E,21171 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Ashe, Misty, R,23129 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jai, Maurice,22932 | 4169.33 | 0.00 | 0.00 | 4169.33 | 0.00 |
| Hughes, Lucas, E,26657 | 1357.97 | 0.00 | 0.00 | 1357.97 | 0.00 |
| Sai, Terrance,19106 | 64.95 | 0.00 | 0.00 | 0.00 | 64.95 |
| Carter, Sophia, D,25230 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Sanz, Rodney,16926 | 44.95 | 0.00 | 0.00 | 0.00 | 44.95 |
| Liu, Glenn,18899 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Jimenez, Kathleen,26654 | 1346.76 | 0.00 | 0.00 | 1346.76 | 0.00 |
| Nara, Priscilla,18907 | 4167.23 | 0.00 | 3578.27 | 588.96 | 0.00 |
| Yang, Jon, V,11000 | 8248.99 | 3399.99 | 0.00 | 2341.97 | 2507.03 |
| Johnson, Logan, K,22931 | 3882.55 | 0.00 | 0.00 | 3882.55 | 0.00 |
| Lal, Katie, E,18210 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Fernandez, Kristopher, O,19271 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Xie, Cristina, C,17050 | 4496.23 | 0.00 | 3578.27 | 0.00 | 917.96 |
| Black, Michele,13995 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Black, Shaun, M,17355 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Gomez, Nelson, L,29053 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Hall, Amanda,26656 | 1345.95 | 0.00 | 0.00 | 1345.95 | 0.00 |
| Gonzalez, Phillip, N,18207 | 6089.59 | 0.00 | 3578.27 | 2511.32 | 0.00 |
| Ruiz, Julio,11005 | 8121.33 | 3374.99 | 0.00 | 2362.27 | 2384.07 |
| Raje, Raul, L,26785 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Gutierrez, Armando,29310 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Chow, Amy, E,12699 | 6798.13 | 0.00 | 0.00 | 2049.10 | 4749.03 |
| Gutierrez, Gary, C,12701 | 6868.44 | 0.00 | 0.00 | 2071.42 | 4797.02 |
| Vazquez, Hector, E,19772 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 2294.99 | 2438.06 |
| Ye, Leah,11077 | 8169.03 | 0.00 | 3374.99 | 2374.98 | 2419.06 |
| Mehta, Brett,11450 | 8173.26 | 0.00 | 3374.99 | 2370.22 | 2428.05 |
| Navarro, Carolyn,11069 | 8104.05 | 0.00 | 3399.99 | 2319.99 | 2384.07 |
| Andersen, Carl, J,11057 | 8088.04 | 0.00 | 3374.99 | 2319.99 | 2393.06 |
| Kumar, Chad,11095 | 8158.01 | 0.00 | 3374.99 | 2363.96 | 2419.06 |
| Xu, Julie,18301 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Lin, Wesley,21407 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Sanz, Arthur,27688 | 166.28 | 0.00 | 0.00 | 166.28 | 0.00 |
| Gomez, Gary,15640 | 34.57 | 0.00 | 0.00 | 2.29 | 32.28 |
| Suarez, Pedro, A,24611 | 2219.42 | 0.00 | 1000.44 | 1218.98 | 0.00 |
| Sanz, Mathew, L,14557 | 63.97 | 0.00 | 0.00 | 63.97 | 0.00 |
| Ma, Jorge, O,14052 | 86.26 | 0.00 | 0.00 | 27.28 | 58.98 |
| Johnson, Emma, M,15136 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Prasad, Cesar,23411 | 3577.82 | 0.00 | 0.00 | 3577.82 | 0.00 |
| Lin, Suzanne,29287 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Ward, Shelby,26132 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Griffin, Blake, S,18699 | 5308.24 | 0.00 | 3578.27 | 1729.97 | 0.00 |
| Blanco, Rodney, A,20158 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Blanco, Micheal, A,11113 | 109.88 | 0.00 | 0.00 | 49.97 | 59.91 |
| Hu, Alejandro,13125 | 138.54 | 0.00 | 0.00 | 0.00 | 138.54 |
| Raji, Grant, R,16185 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Alonso, Krista, P,20212 | 100.74 | 0.00 | 0.00 | 0.00 | 100.74 |
| Serrano, Leslie, T,14014 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Gutierrez, Natasha,17048 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Gutierrez, Ricky,19773 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Shan, Yolanda,12702 | 6911.10 | 0.00 | 0.00 | 2049.10 | 4862.00 |
| Chow, Christy, M,12681 | 6784.13 | 0.00 | 0.00 | 2049.10 | 4735.03 |
| Ye, Tamara, A,20243 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Lal, Shaun, H,17056 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
Generated 2025-12-23 14:09:22.556 UTC