[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 969 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Cox, Catherine, K,13122 | 6871.43 | 0.00 | 0.00 | 2071.42 | 4800.01 |
| Tang, Bridget,17730 | 4752.23 | 0.00 | 3578.27 | 0.00 | 1173.96 |
| Rai, Johnny, A,13135 | 6773.14 | 0.00 | 0.00 | 2049.10 | 4724.04 |
| Raman, Michele,17233 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Bailey, Destiny, C,22941 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Gonzalez, Jay, C,14238 | 5642.90 | 0.00 | 0.00 | 2049.10 | 3593.80 |
| Wang, Crystal, C,11112 | 8295.02 | 0.00 | 3374.99 | 0.00 | 4920.03 |
| Ortega, Lance, C,12354 | 6797.13 | 0.00 | 2049.10 | 0.00 | 4748.03 |
| Russell, Alexis, L,13634 | 234.93 | 0.00 | 0.00 | 0.00 | 234.93 |
| Xu, Trisha,20282 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Xie, Nina,12997 | 118.18 | 0.00 | 0.00 | 0.00 | 118.18 |
| Zhang, Roger,12690 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Miller, Dalton, D,13130 | 6797.15 | 0.00 | 0.00 | 2049.10 | 4748.05 |
| Raman, Sergio,27866 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Raman, Rachael,25216 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Mehta, Mayra,12998 | 5694.90 | 0.00 | 0.00 | 2049.10 | 3645.80 |
| Blanco, Robyn, R,24179 | 3052.31 | 0.00 | 0.00 | 2443.35 | 608.96 |
| Gutierrez, Latasha, C,15022 | 2999.91 | 0.00 | 0.00 | 2071.42 | 928.49 |
| Gonzalez, Ann,11894 | 8223.00 | 0.00 | 3374.99 | 0.00 | 4848.01 |
| Gomez, Randall, R,11762 | 8228.01 | 0.00 | 3399.99 | 0.00 | 4828.02 |
| Chander, Andres, E,29460 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Shen, Calvin, W,26145 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Raman, Dominique, D,13023 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Kapoor, Rachael, D,11911 | 62.46 | 0.00 | 0.00 | 0.00 | 62.46 |
| Deng, Deborah,23324 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Rai, Willie,14673 | 5117.75 | 0.00 | 0.00 | 2071.42 | 3046.33 |
| Nara, Dale, L,21226 | 4659.80 | 0.00 | 0.00 | 2181.56 | 2478.24 |
| Alvarez, Jessie,14324 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
| Miller, Zachary, M,15169 | 2919.89 | 0.00 | 0.00 | 2071.42 | 848.47 |
| Suarez, Lawrence, C,26131 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Lal, Nina, L,14263 | 5647.93 | 0.00 | 0.00 | 2049.10 | 3598.83 |
| Martin, Tabitha,25269 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Prasad, Cory,19748 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Romero, Raquel, Z,22916 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Gill, Dwayne, A,19675 | 198.99 | 0.00 | 0.00 | 0.00 | 198.99 |
| Luo, Julie, M,29121 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Prasad, Francisco,16628 | 187.58 | 0.00 | 0.00 | 0.00 | 187.58 |
| Goel, Ricardo, T,25961 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Beck, April,14302 | 5140.73 | 0.00 | 0.00 | 2071.42 | 3069.31 |
| Parker, Gabriella,21394 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Gill, Jay,27975 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Washington, Abigail,23661 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Raman, Geoffrey, P,15435 | 3801.39 | 0.00 | 0.00 | 2071.42 | 1729.97 |
| Nath, Dawn, L,11759 | 8054.05 | 0.00 | 3374.99 | 0.00 | 4679.06 |
| Zeng, Alvin, M,11118 | 115.85 | 0.00 | 0.00 | 0.00 | 115.85 |
| Taylor, Devin, L,12248 | 3939.98 | 0.00 | 3399.99 | 0.00 | 539.99 |
| Yuan, Karla, W,13629 | 6889.11 | 0.00 | 0.00 | 2049.10 | 4840.01 |
| Diaz, Frank, F,29086 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Evans, Xavier,19098 | 122.24 | 0.00 | 0.00 | 0.00 | 122.24 |
| Vazquez, Jimmy, D,12348 | 6906.09 | 0.00 | 2049.10 | 0.00 | 4856.99 |
| Gao, Candice, M,17493 | 130.96 | 0.00 | 0.00 | 0.00 | 130.96 |
| Suri, Phillip,17914 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Serrano, Gloria, G,21556 | 4930.68 | 0.00 | 2443.35 | 0.00 | 2487.33 |
| Sullivan, Summer, E,21181 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Sun, Christy,25218 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 0.00 | 2049.10 | 4744.05 |
| Sanders, Gabriella,11906 | 8151.00 | 0.00 | 3374.99 | 0.00 | 4776.01 |
| Xu, Alicia,11370 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Hernandez, Hailey, A,18727 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Alonso, Brandi,17061 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Lal, Tommy,14516 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Sara, Troy, R,22583 | 2821.51 | 0.00 | 0.00 | 2181.56 | 639.95 |
| Sanz, Nelson, M,14056 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Nath, Bethany,16177 | 133.34 | 0.00 | 0.00 | 0.00 | 133.34 |
| Flores, Antonio, D,14259 | 3630.93 | 0.00 | 0.00 | 2049.10 | 1581.83 |
| Moreno, Danny, M,29458 | 811.32 | 0.00 | 0.00 | 0.00 | 811.32 |
| Goel, Karla, L,11146 | 112.93 | 0.00 | 0.00 | 0.00 | 112.93 |
| Sai, Tina, L,15425 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Ferrier, Jaime, P,23528 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Gutierrez, Victor, J,27357 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sanchez, Henry,26968 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Luo, Lacey,24175 | 2743.04 | 0.00 | 0.00 | 2181.56 | 561.48 |
| Li, Jaclyn,18281 | 6081.10 | 0.00 | 3578.27 | 0.00 | 2502.83 |
| Johnson, Brianna, J,17319 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raji, Lacey, E,16341 | 88.25 | 0.00 | 0.00 | 0.00 | 88.25 |
| Diaz, Emma, L,18711 | 10.24 | 0.00 | 0.00 | 0.00 | 10.24 |
| Torres, Wendy, A,18269 | 6113.20 | 0.00 | 3578.27 | 0.00 | 2534.93 |
| Sanchez, George, M,12680 | 6880.10 | 0.00 | 0.00 | 2049.10 | 4831.00 |
| Lewis, Nicole,21881 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Chow, Christy, M,12681 | 6784.13 | 0.00 | 0.00 | 2049.10 | 4735.03 |
| Smith, Andre,21174 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Rubio, Tanya, I,15598 | 167.93 | 0.00 | 0.00 | 0.00 | 167.93 |
| Lin, Jake,24248 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Malhotra, Marco, L,29459 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Wood, Julia, L,12356 | 6810.13 | 0.00 | 2049.10 | 0.00 | 4761.03 |
| Patterson, Melissa, E,12668 | 6839.46 | 0.00 | 0.00 | 2071.42 | 4768.04 |
| Mr., Schmidt, Irving, W,12669 | 6791.10 | 0.00 | 0.00 | 2049.10 | 4742.00 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| Nara, Devon, C,21964 | 103.49 | 0.00 | 0.00 | 0.00 | 103.49 |
| Ramos, Larry,18446 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Gao, Louis,14666 | 5199.92 | 0.00 | 0.00 | 2049.10 | 3150.82 |
| Long, Julian,12034 | 72.25 | 0.00 | 0.00 | 0.00 | 72.25 |
| Martin, Lance,25236 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Suri, Patricia, E,15436 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Srini, Manuel,24168 | 2790.52 | 0.00 | 0.00 | 2181.56 | 608.96 |
| Young, Morgan, L,12342 | 6838.12 | 0.00 | 2049.10 | 0.00 | 4789.02 |
| Shan, Damien, M,11362 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Wang, Micah, C,14676 | 5188.41 | 0.00 | 0.00 | 2049.10 | 3139.31 |
| Madan, Summer, D,12347 | 6839.12 | 0.00 | 2049.10 | 0.00 | 4790.02 |
| Wang, Randy, G,25125 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Li, Crystal, L,14325 | 5152.70 | 0.00 | 0.00 | 2049.10 | 3103.60 |
| Richardson, Abigail, S,14236 | 5710.23 | 0.00 | 0.00 | 2071.42 | 3638.81 |
| Goel, Carl, S,17249 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Sullivan, Toni, M,29083 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Huang, Crystal, L,26023 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Sanz, Tabitha,17496 | 110.96 | 0.00 | 0.00 | 0.00 | 110.96 |
| Zeng, Dawn, D,29455 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Romero, Frank, M,15209 | 2916.56 | 0.00 | 0.00 | 2049.10 | 867.46 |
| She, Christine,16184 | 78.20 | 0.00 | 0.00 | 0.00 | 78.20 |
| Chavez, Corey, R,15731 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Navarro, Jacquelyn,15465 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Ruiz, Sabrina, A,22214 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Sutton, Kern, A,26660 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Vazquez, Danny, J,26033 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Yang, Darryl, K,21571 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Hernandez, Clinton,29462 | 854.82 | 0.00 | 0.00 | 0.00 | 854.82 |
| Torres, Dwayne, R,17288 | 4426.24 | 0.00 | 3578.27 | 0.00 | 847.97 |
| Williams, Madison, J,21198 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Serrano, Lori,17066 | 105.75 | 0.00 | 0.00 | 0.00 | 105.75 |
| Xu, Crystal, E,15754 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Sanchez, Levi, A,27745 | 617.47 | 0.00 | 0.00 | 617.47 | 0.00 |
| Rana, Meredith,25032 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Anand, Johnny,14058 | 5652.52 | 0.00 | 0.00 | 2071.42 | 3581.10 |
| Ma, Warren, A,19762 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
Generated 2025-12-24 08:32:21.965 UTC