[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 30 > < TAKE 112 >
112 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gao, Jake, A,19955 | 173.45 | 0.00 | 0.00 | 0.00 | 173.45 |
| Sanz, Sabrina, A,19650 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Jai, Drew, M,21562 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Rana, Johnathan, R,27497 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Alexander, Gabriel, C,14073 | 156.84 | 0.00 | 0.00 | 0.00 | 156.84 |
| Nara, Tony, L,16713 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Prasad, Denise,18294 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Ramos, Theresa, G,11031 | 6478.60 | 3399.99 | 0.00 | 0.00 | 3078.61 |
| Torres, Danielle, G,22947 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Sanz, Linda, P,22945 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Ramirez, Isaiah,11905 | 8155.98 | 0.00 | 3374.99 | 0.00 | 4780.99 |
| Alvarez, Carrie, W,23410 | 4016.53 | 0.00 | 0.00 | 2181.56 | 1834.97 |
| Ramos, Michele, J,19574 | 96.74 | 0.00 | 0.00 | 0.00 | 96.74 |
| Diaz, Ruben, A,25136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raji, Jaime, L,15037 | 3856.38 | 0.00 | 0.00 | 2071.42 | 1784.96 |
| Chander, Brad, K,21382 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Goel, Karl,18705 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Garcia, Ivan, L,17354 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Morris, Eduardo,19619 | 112.75 | 0.00 | 0.00 | 0.00 | 112.75 |
| Sara, Marco, L,15641 | 96.75 | 0.00 | 0.00 | 0.00 | 96.75 |
| Wang, Laura, L,26146 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Garcia, Edgar, A,17729 | 110.46 | 0.00 | 0.00 | 0.00 | 110.46 |
| Rodriguez, Carolyn,21002 | 2992.33 | 0.00 | 2443.35 | 0.00 | 548.98 |
| Zheng, Darryl,18706 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Price, Vanessa, A,23569 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alvarez, Kendra, R,15267 | 2853.58 | 0.00 | 0.00 | 2049.10 | 804.48 |
| Moore, Natalie, W,18273 | 6104.21 | 0.00 | 3578.27 | 0.00 | 2525.94 |
| Hu, Alejandro,13125 | 138.54 | 0.00 | 0.00 | 0.00 | 138.54 |
| Anand, Calvin, E,28717 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Patel, Douglas,17927 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Torres, Marc,11765 | 8143.03 | 0.00 | 3374.99 | 0.00 | 4768.04 |
| Suarez, Gina,20248 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Gill, Gerald, A,28487 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Nelson, Mary, L,13107 | 5650.90 | 0.00 | 0.00 | 2049.10 | 3601.80 |
| Townsend, Larry, D,11134 | 4911.83 | 0.00 | 3399.99 | 0.00 | 1511.84 |
| She, Roger, L,15724 | 4359.07 | 0.00 | 0.00 | 2049.10 | 2309.97 |
| Martinez, Troy, L,20823 | 4216.75 | 0.00 | 3578.27 | 0.00 | 638.48 |
| Shen, Tony,29099 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Shen, Wayne, P,23647 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Shen, Tamara, G,22935 | 3951.52 | 0.00 | 0.00 | 2181.56 | 1769.96 |
| Chandra, Gerald,25131 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yang, Warren, F,17908 | 35.72 | 0.00 | 0.00 | 0.00 | 35.72 |
| Wang, Rosa, I,11993 | 8131.32 | 0.00 | 3374.99 | 0.00 | 4756.33 |
| Malhotra, Heidi, A,26426 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Baker, Luke, J,22952 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martin, Tabitha,25269 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| Kapoor, Ruben, D,11109 | 8245.01 | 0.00 | 3374.99 | 2476.96 | 2393.06 |
| Torres, Michele, A,16176 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Sai, Ivan, E,17300 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Kumar, Alejandro,14055 | 5177.40 | 0.00 | 0.00 | 2049.10 | 3128.30 |
| Gutierrez, Jill, N,26024 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Raje, April, R,18744 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Srini, Veronica,11996 | 7058.70 | 0.00 | 3374.99 | 1291.77 | 2391.94 |
| Chavez, Jodi, A,18909 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Johnsen, Eddie,28935 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Subram, Rebekah,26030 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Carlson, Theresa, L,19629 | 109.44 | 0.00 | 0.00 | 0.00 | 109.44 |
| Clark, Sydney,16610 | 67.58 | 0.00 | 0.00 | 0.00 | 67.58 |
| Dominguez, Neil, K,23663 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Mr., Rovira Diez, Pablo,21190 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Gomez, Danny, V,16636 | 5932.74 | 3578.27 | 0.00 | 0.00 | 2354.47 |
| Guo, Sandra,23664 | 3941.53 | 0.00 | 0.00 | 2181.56 | 1759.97 |
| Ramos, Joy,13129 | 6823.15 | 0.00 | 0.00 | 2049.10 | 4774.05 |
| Pal, Alvin, C,29319 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Blanco, Orlando,22575 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Li, Glenn, A,29295 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Black, Tracy, B,24903 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Arthur, Raymond, S,20228 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Zeng, Erica,26924 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Raji, Sheena, J,18213 | 6070.59 | 0.00 | 3578.27 | 2492.32 | 0.00 |
| Goel, Alicia, H,20423 | 4177.74 | 0.00 | 3578.27 | 0.00 | 599.47 |
| Zheng, Jenny, R,11947 | 4747.30 | 0.00 | 3374.99 | 629.96 | 742.35 |
| Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Chander, Roger,25214 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Xu, Calvin, E,27583 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Evans, Adam, H,25820 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Guo, Jamie,20151 | 4152.73 | 0.00 | 3578.27 | 0.00 | 574.46 |
| Xu, Grant, M,19266 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Yuan, Bethany, G,11030 | 6471.32 | 3399.99 | 0.00 | 0.00 | 3071.33 |
| Alvarez, Stacy,11901 | 8248.01 | 0.00 | 3399.99 | 0.00 | 4848.02 |
| Gonzalez, Ebony,11034 | 6491.32 | 3399.99 | 0.00 | 0.00 | 3091.33 |
| Lal, Kate,21557 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Ye, Christy,14219 | 5744.22 | 0.00 | 0.00 | 2071.42 | 3672.80 |
| Patel, Summer, G,26753 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Huang, Arturo,28952 | 2473.04 | 0.00 | 0.00 | 0.00 | 2473.04 |
| Martin, Ricky, C,16608 | 101.57 | 0.00 | 0.00 | 0.00 | 101.57 |
| Arun, Candace, J,21393 | 4925.17 | 0.00 | 2443.35 | 0.00 | 2481.82 |
| Alvarez, Pedro, E,28120 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Luo, Colleen, E,15208 | 2951.56 | 0.00 | 0.00 | 2049.10 | 902.46 |
| Suarez, Pedro, A,24611 | 2219.42 | 0.00 | 1000.44 | 1218.98 | 0.00 |
| Vance, Henry,27986 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Yuan, Lacey, W,12349 | 6772.14 | 0.00 | 2049.10 | 0.00 | 4723.04 |
| Wilson, Sam,25947 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Chen, Willie, C,28322 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Perez, Carmen, C,13139 | 6854.45 | 0.00 | 0.00 | 2071.42 | 4783.03 |
| Gill, Billy, L,16700 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Fernandez, Donald, C,24462 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Subram, Virginia,13036 | 2677.07 | 0.00 | 0.00 | 2049.10 | 627.97 |
| Raji, Brendan,13103 | 6842.60 | 0.00 | 0.00 | 2049.10 | 4793.50 |
| Jai, Dylan, J,23128 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| He, Susan, A,24467 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Garcia, Donald,18929 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Shan, Bethany, L,13973 | 5185.68 | 0.00 | 0.00 | 2071.42 | 3114.26 |
| Chandra, Arthur, L,14032 | 6859.43 | 0.00 | 0.00 | 2071.42 | 4788.01 |
| Ruiz, Danny,24456 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Mehta, Ann, M,14518 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Sun, Jorge,16025 | 3831.89 | 0.00 | 0.00 | 2071.42 | 1760.47 |
| Ortega, Joanna,17909 | 4761.74 | 0.00 | 3578.27 | 0.00 | 1183.47 |
| Carlson, Byron,11900 | 8257.01 | 0.00 | 3399.99 | 0.00 | 4857.02 |
| Becker, Kelli, E,16633 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Garcia, Rebekah, M,14007 | 3772.41 | 0.00 | 0.00 | 3772.41 | 0.00 |
Generated 2025-12-23 05:02:20.803 UTC