[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 531 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanchez, Manuel,15126 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Dominguez, Philip,15730 | 122.96 | 0.00 | 0.00 | 0.00 | 122.96 |
| Luo, Michele,26027 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Nara, Latoya, J,18208 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Foster, Lucas,13519 | 4492.45 | 0.00 | 0.00 | 4492.45 | 0.00 |
| Patel, Ruben, I,19765 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Alvarez, Kari, C,11108 | 8124.04 | 0.00 | 3374.99 | 2329.99 | 2419.06 |
| Xu, Peter, K,28204 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Liu, Jessie,11106 | 8079.05 | 0.00 | 3399.99 | 2294.99 | 2384.07 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 2294.99 | 2419.06 |
| Anderson, Blake,11076 | 8159.04 | 0.00 | 3399.99 | 2374.98 | 2384.07 |
| Andersen, Karl, M,23105 | 3361.53 | 0.00 | 0.00 | 3361.53 | 0.00 |
| Wang, Shannon,11017 | 6434.31 | 3374.99 | 0.00 | 2316.97 | 742.35 |
| Hernandez, Jacquelyn, J,21568 | 4659.80 | 0.00 | 0.00 | 2181.56 | 2478.24 |
| Nara, Leonard, G,11045 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Xu, Glenn,18743 | 67.21 | 0.00 | 0.00 | 0.00 | 67.21 |
| Chander, Cassie, M,18258 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Raje, Louis, M,25707 | 1262.06 | 0.00 | 699.10 | 0.00 | 562.96 |
| Raji, Kelli, G,13123 | 6765.44 | 0.00 | 0.00 | 2049.10 | 4716.34 |
| Diaz, Marc,11058 | 8248.02 | 0.00 | 3399.99 | 2374.98 | 2473.05 |
| Zhou, Jon, L,11060 | 8153.02 | 0.00 | 3399.99 | 2319.99 | 2433.04 |
| Sharma, Kelvin, D,26655 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Smith, Arthur,18240 | 6098.58 | 0.00 | 3578.27 | 2520.31 | 0.00 |
| Lu, Roger, F,19763 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Kennedy, Devon, J,13133 | 6813.12 | 0.00 | 0.00 | 2049.10 | 4764.02 |
| Vance, Marco,13124 | 87.93 | 0.00 | 0.00 | 0.00 | 87.93 |
| Lin, Jaclyn,28721 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cai, Trisha,18265 | 64.98 | 0.00 | 0.00 | 0.00 | 64.98 |
| Serrano, Dwayne,16695 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Morris, Isaac, G,26439 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Shan, Colin,25921 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Chandra, Ann,18209 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Suri, Ronald,18214 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Zeng, Louis,18903 | 4143.74 | 0.00 | 3578.27 | 565.47 | 0.00 |
| Saunders, Micheal,17513 | 4260.24 | 0.00 | 3578.27 | 681.97 | 0.00 |
| Alonso, Danny, S,18217 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Huang, Eugene, L,11001 | 6383.88 | 3374.99 | 0.00 | 2419.93 | 588.96 |
| 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 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 0.00 | 3490.03 | 0.00 |
| Carlson, Shannon, C,11009 | 8091.33 | 3374.99 | 0.00 | 2297.28 | 2419.06 |
| Yuan, Grant, C,24909 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Fernandez, Allen,19596 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Martinez, Ann,12009 | 8195.50 | 0.00 | 3399.99 | 0.00 | 4795.51 |
| Vance, Monica, G,12338 | 8265.00 | 0.00 | 3374.99 | 0.00 | 4890.01 |
| Simmons, Isabel, H,26432 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Gonzalez, Cynthia,15787 | 167.93 | 0.00 | 0.00 | 0.00 | 167.93 |
| Blanco, Kari,19627 | 41.75 | 0.00 | 0.00 | 0.00 | 41.75 |
| Torres, Mathew, L,18900 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Sara, Edgar, A,11104 | 8173.03 | 0.00 | 3399.99 | 2334.98 | 2438.06 |
| Lal, Karl, R,14264 | 5217.73 | 0.00 | 0.00 | 2822.76 | 2394.97 |
| Harris, Eduardo, S,18238 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Jordan, Ross, F,11124 | 8129.02 | 0.00 | 3399.99 | 2309.97 | 2419.06 |
| She, Kristin, L,19961 | 97.97 | 0.00 | 0.00 | 0.00 | 97.97 |
| Sai, Frederick,20991 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Ortega, Jessie, J,17051 | 6060.50 | 3578.27 | 0.00 | 0.00 | 2482.23 |
| Jiménez, Beth, H,11120 | 8242.49 | 0.00 | 3374.99 | 0.00 | 4867.50 |
| Serrano, Rebekah,14130 | 3814.06 | 0.00 | 0.00 | 2049.10 | 1764.96 |
| Li, Lacey,17515 | 4143.26 | 0.00 | 3578.27 | 0.00 | 564.99 |
| Wood, Maria,12667 | 6813.12 | 0.00 | 2049.10 | 0.00 | 4764.02 |
| Yang, Lacey,13150 | 89.24 | 0.00 | 0.00 | 0.00 | 89.24 |
| Ortega, Joanna,17909 | 4761.74 | 0.00 | 3578.27 | 0.00 | 1183.47 |
| Anand, Kara,11989 | 8139.53 | 0.00 | 3374.99 | 0.00 | 4764.54 |
| Raji, Arturo,23998 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Nath, Ricardo, C,12039 | 8213.00 | 0.00 | 3374.99 | 0.00 | 4838.01 |
| Alonso, Meredith, M,20621 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Blanco, Alberto, R,27867 | 2443.55 | 0.00 | 0.00 | 0.00 | 2443.55 |
| Chander, Russell, E,29067 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Mehta, Brett,11450 | 8173.26 | 0.00 | 3374.99 | 2370.22 | 2428.05 |
| Lin, Wesley,21407 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Raje, Terry, A,28311 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Sanz, Mathew, L,14557 | 63.97 | 0.00 | 0.00 | 63.97 | 0.00 |
| Rowe, Jacquelyn, I,13615 | 146.91 | 0.00 | 0.00 | 7.95 | 138.96 |
| Sun, Rafael,26749 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Serrano, Francis, R,23547 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Gutierrez, Erika,17227 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Wu, Ernest, L,11147 | 8195.50 | 0.00 | 3374.99 | 0.00 | 4820.51 |
| Gutierrez, Clinton,21001 | 3018.33 | 0.00 | 2443.35 | 0.00 | 574.98 |
| Hall, Jeremiah, M,18250 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Torres, Neil,17305 | 196.97 | 0.00 | 0.00 | 196.97 | 0.00 |
| Goel, Roger, A,23652 | 3907.54 | 0.00 | 0.00 | 2181.56 | 1725.98 |
| Jimenez, Gary, E,16609 | 344.04 | 0.00 | 0.00 | 84.95 | 259.09 |
| Yang, Connor,17735 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Fernandez, Ross, R,11763 | 76.65 | 0.00 | 0.00 | 24.49 | 52.16 |
| Wang, Jeffery, E,18188 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Goldstein, Dustin,12337 | 8137.01 | 0.00 | 3399.99 | 0.00 | 4737.02 |
| Hu, Aimee, R,27981 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Blanco, Rodney, A,20158 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Deng, Kurt, D,13635 | 215.74 | 0.00 | 0.00 | 32.27 | 183.47 |
| Smith, Christian, L,14313 | 222.44 | 0.00 | 0.00 | 0.00 | 222.44 |
| Wood, Jacqueline,16705 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Serrano, Neil, L,17076 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Kumar, Shawna, L,19085 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Zhou, Jaclyn, C,21179 | 4935.67 | 0.00 | 2443.35 | 0.00 | 2492.32 |
| Lal, Cristina, M,14671 | 2934.37 | 0.00 | 0.00 | 2071.42 | 862.95 |
| Suarez, Jerome, L,20622 | 6139.59 | 0.00 | 3578.27 | 0.00 | 2561.32 |
| Alvarez, Erik, M,14311 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Moreno, Janet, L,15592 | 59.98 | 0.00 | 0.00 | 24.99 | 34.99 |
| Shen, Jodi, A,22028 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Martin, Larry,18254 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| James, Evan, V,11119 | 85.22 | 0.00 | 0.00 | 35.23 | 49.99 |
| Xie, Alvin, M,16617 | 160.55 | 0.00 | 0.00 | 69.97 | 90.58 |
| Zhou, Cedric,17514 | 4142.23 | 0.00 | 3578.27 | 563.96 | 0.00 |
| Nara, Sharon,18482 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Ramos, Kristine,17479 | 163.40 | 0.00 | 0.00 | 0.00 | 163.40 |
| Ramos, Byron,14306 | 3653.23 | 0.00 | 0.00 | 2071.42 | 1581.81 |
| Zhou, Heather, M,24914 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Pal, Kara,24916 | 2169.90 | 0.00 | 0.00 | 1000.44 | 1169.46 |
| Shan, Carl, D,24919 | 2212.89 | 0.00 | 0.00 | 1000.44 | 1212.45 |
| Cai, Amy,24920 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Malhotra, Kristina,25031 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Sara, Candace,21380 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Tang, Jenny, E,14210 | 5621.24 | 0.00 | 0.00 | 2071.42 | 3549.82 |
| Stone, Denise,11032 | 6525.56 | 0.00 | 3374.99 | 0.00 | 3150.57 |
| Lee, Richard, I,23996 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Suarez, Neil,15242 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Pal, Nichole, J,26741 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Nara, Karl,15142 | 138.46 | 0.00 | 0.00 | 0.00 | 138.46 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Sanchez, Terrance,19584 | 116.74 | 0.00 | 0.00 | 0.00 | 116.74 |
| She, Rafael, I,20152 | 4142.75 | 0.00 | 3578.27 | 0.00 | 564.48 |
| Ferrier, Leslie, M,28535 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Hernandez, Kristine,14286 | 5234.40 | 0.00 | 0.00 | 2049.10 | 3185.30 |
Generated 2025-12-24 06:17:18.897 UTC