[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 500 < SKIP 1125 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Yang, Lacey,13150 | 89.24 | 0.00 | 0.00 | 0.00 | 89.24 |
| Young, Morgan, L,12342 | 6838.12 | 0.00 | 2049.10 | 0.00 | 4789.02 |
| Torres, Jacqueline,21976 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Rowe, Jacquelyn, I,13615 | 146.91 | 0.00 | 0.00 | 7.95 | 138.96 |
| Wang, Crystal, C,11112 | 8295.02 | 0.00 | 3374.99 | 0.00 | 4920.03 |
| Liang, Glenn,21983 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Cai, Roger, A,13002 | 294.94 | 0.00 | 0.00 | 0.00 | 294.94 |
| Rai, Clayton, K,20446 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Malhotra, Toni,26162 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Peterson, Allison, A,26421 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Torres, Carolyn,15261 | 70.74 | 0.00 | 0.00 | 0.00 | 70.74 |
| Subram, Virginia,13036 | 2677.07 | 0.00 | 0.00 | 2049.10 | 627.97 |
| Garcia, Brandy,26028 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Hu, Dennis, J,20600 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Chapman, Kristi, l,21986 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Ramos, Randall,21572 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Schmidt, Pamela, I,24375 | 31.73 | 0.00 | 0.00 | 0.00 | 31.73 |
| Hernandez, Frank, G,22198 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Simmons, Gabrielle,29183 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Goel, Carl, S,17249 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Lu, Micah,22174 | 3007.83 | 0.00 | 0.00 | 2443.35 | 564.48 |
| Kumar, Kurt, L,27360 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Beck, April,14302 | 5140.73 | 0.00 | 0.00 | 2071.42 | 3069.31 |
| Cai, Jorge,22031 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Lal, Barbara, W,23101 | 2795.01 | 0.00 | 0.00 | 2181.56 | 613.45 |
| Sai, Ross, A,21966 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Nath, Ricardo, C,12039 | 8213.00 | 0.00 | 3374.99 | 0.00 | 4838.01 |
| Mr., Schmidt, Irving, W,12669 | 6791.10 | 0.00 | 0.00 | 2049.10 | 4742.00 |
| Gutierrez, Gary, C,12701 | 6868.44 | 0.00 | 0.00 | 2071.42 | 4797.02 |
| Blanco, Alberto, R,27867 | 2443.55 | 0.00 | 0.00 | 0.00 | 2443.55 |
| Lal, Shaun, H,17056 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Serrano, Jésus, B,12991 | 5641.90 | 0.00 | 0.00 | 2049.10 | 3592.80 |
| Chander, Russell, E,29067 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Luo, Dustin,17240 | 4385.03 | 0.00 | 3578.27 | 0.00 | 806.76 |
| Diaz, Kendra,13021 | 2668.38 | 0.00 | 0.00 | 2071.42 | 596.96 |
| Wood, Jacqueline,16705 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| She, Clarence, L,24901 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Serrano, Neil, L,17076 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Malhotra, Geoffrey, W,18298 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Munoz, Craig, V,13076 | 6862.14 | 0.00 | 0.00 | 2049.10 | 4813.04 |
| Kumar, Shawna, L,19085 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Prasad, Dominic, D,19962 | 46.75 | 0.00 | 0.00 | 0.00 | 46.75 |
| Barnes, Julia, R,21999 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Zhou, Jaclyn, C,21179 | 4935.67 | 0.00 | 2443.35 | 0.00 | 2492.32 |
| Zhang, Clarence, M,13001 | 6799.43 | 0.00 | 0.00 | 2049.10 | 4750.33 |
| Suarez, Jerome, L,20622 | 6139.59 | 0.00 | 3578.27 | 0.00 | 2561.32 |
| Bhat, Edwin,13079 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Alvarez, Erik, M,14311 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Sara, Geoffrey,26188 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Perry, Gavin, M,12578 | 2668.08 | 0.00 | 0.00 | 2049.10 | 618.98 |
| Deng, Latoya, H,21969 | 4759.47 | 0.00 | 0.00 | 2181.56 | 2577.91 |
| Raje, Rafael, M,13000 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Dominguez, Theodore, F,21987 | 4638.89 | 0.00 | 0.00 | 2181.56 | 2457.33 |
| Shan, Shawna, K,27869 | 2462.55 | 0.00 | 0.00 | 0.00 | 2462.55 |
| Martinez, Anna, J,12994 | 6855.44 | 0.00 | 0.00 | 2071.42 | 4784.02 |
| Moreno, Diana, J,29298 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Ye, Erica, E,13010 | 5716.52 | 0.00 | 0.00 | 2071.42 | 3645.10 |
| Rai, Nina,14018 | 63.87 | 0.00 | 0.00 | 0.00 | 63.87 |
| Garcia, Toni,22193 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Suarez, Neil,15242 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Wang, Jon, A,26191 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Pal, Nichole, J,26741 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Andersen, Drew, K,22412 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Nara, Karl,15142 | 138.46 | 0.00 | 0.00 | 0.00 | 138.46 |
| Martin, Ruben,22400 | 2737.82 | 0.00 | 0.00 | 2181.56 | 556.26 |
| Goel, Dawn,23535 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Powell, Grace, B,29194 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Navarro, Byron,16622 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Raman, Frederick, F,28942 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Stone, Christine, D,25948 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Weber, Chelsea,29191 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Nara, Tommy,16729 | 38.92 | 0.00 | 0.00 | 0.00 | 38.92 |
| Vazquez, Byron,11122 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| He, Louis, E,21211 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Xu, Tony, L,22576 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Cai, Shannon,26156 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Huang, Barbara,26442 | 1919.75 | 0.00 | 0.00 | 782.99 | 1136.76 |
| Dominguez, Roy, C,29189 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Arthur, Cassandra, M,22410 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Torres, Kellie,19569 | 112.24 | 0.00 | 0.00 | 0.00 | 112.24 |
| Sanchez, Nancy, L,22207 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Prasad, Marco, C,15606 | 115.93 | 0.00 | 0.00 | 0.00 | 115.93 |
| Shan, Clarence,22408 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Edwards, Kaylee, M,22851 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Sanz, Lance,22573 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Luo, Devon, D,22850 | 4657.51 | 0.00 | 0.00 | 2181.56 | 2475.95 |
| Zhu, Tiffany,26437 | 1953.47 | 0.00 | 0.00 | 782.99 | 1170.48 |
| Ortega, Reginald, K,26429 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Sai, Bryant, S,22577 | 2743.04 | 0.00 | 0.00 | 2181.56 | 561.48 |
| Xu, Alejandro, R,26585 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Kapoor, Brett, L,22147 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sai, Clifford,25128 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Lin, Darryl, J,15031 | 41.27 | 0.00 | 0.00 | 0.00 | 41.27 |
| Xu, Tonya,17324 | 80.94 | 0.00 | 0.00 | 0.00 | 80.94 |
| Zheng, Curtis, S,23645 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Torres, Monique,25235 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Goel, Tommy,22909 | 3980.52 | 0.00 | 0.00 | 2181.56 | 1798.96 |
| She, Brittney, M,22942 | 3971.53 | 0.00 | 0.00 | 2181.56 | 1789.97 |
| Rai, Michele, M,26567 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Vazquez, Casey, S,13132 | 6880.62 | 0.00 | 0.00 | 2049.10 | 4831.52 |
| Torres, Dwayne, R,17288 | 4426.24 | 0.00 | 3578.27 | 0.00 | 847.97 |
| Mr., Shakespear, Paul, J.,17326 | 4467.76 | 0.00 | 3578.27 | 0.00 | 889.49 |
| Jones, Nathan,15024 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Mehta, Nancy,18189 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Rodriguez, Pedro, L,17911 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Rodriguez, Donald, L,28351 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Carlson, Joy,13981 | 124.21 | 0.00 | 0.00 | 0.00 | 124.21 |
| Kumar, Wayne,17502 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Chande, Cassie,11103 | 8182.50 | 0.00 | 3374.99 | 2388.45 | 2419.06 |
| Serrano, Natasha,25563 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Mehta, Cesar, J,20241 | 5347.23 | 0.00 | 3578.27 | 0.00 | 1768.96 |
| Navarro, Carolyn,11069 | 8104.05 | 0.00 | 3399.99 | 2319.99 | 2384.07 |
| Nath, Rafael,23533 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Yuan, Julie,22959 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Suri, Cesar,17512 | 4170.54 | 0.00 | 3578.27 | 592.27 | 0.00 |
| Ortega, Eddie,22908 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Williams, Anna, R,17504 | 4362.74 | 0.00 | 3578.27 | 0.00 | 784.47 |
| Shen, Lindsey,26560 | 1396.44 | 0.00 | 0.00 | 782.99 | 613.45 |
| Martin, Renee, L,17478 | 4758.24 | 0.00 | 3578.27 | 0.00 | 1179.97 |
| Wilson, Edward, L,26562 | 1925.41 | 0.00 | 0.00 | 782.99 | 1142.42 |
| Suri, Phillip,17914 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Pal, Lacey, K,26571 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
Generated 2025-12-24 07:50:01.609 UTC