[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1188 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zeng, Tiffany, B,21890 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Ramos, Roberto, M,13159 | 208.18 | 0.00 | 0.00 | 0.00 | 208.18 |
| Fernandez, Tammy, A,25825 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Willie,23421 | 4208.31 | 0.00 | 0.00 | 2443.35 | 1764.96 |
| Dominguez, Jerome, F,22987 | 3942.03 | 0.00 | 0.00 | 2181.56 | 1760.47 |
| Arthur, Rebekah,22939 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Johnsen, Mario, W,26587 | 1920.42 | 0.00 | 0.00 | 782.99 | 1137.43 |
| Shen, Kelsey, R,22921 | 4647.88 | 0.00 | 0.00 | 2181.56 | 2466.32 |
| Fernandez, Brandy, B,22958 | 4208.31 | 0.00 | 0.00 | 2443.35 | 1764.96 |
| Lewis, Hannah,26561 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Pal, Lacey, K,26571 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Yuan, Kathryn, L,23106 | 3956.01 | 0.00 | 0.00 | 2181.56 | 1774.45 |
| Goldstein, Brendan,13518 | 2638.36 | 0.00 | 0.00 | 2049.10 | 589.26 |
| Lal, Bradley,13156 | 2663.69 | 0.00 | 0.00 | 2071.42 | 592.27 |
| Wood, Jacqueline,16705 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Shan, Elijah, L,26795 | 1992.46 | 0.00 | 0.00 | 782.99 | 1209.47 |
| Patel, Summer, G,26753 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Barnes, Angelica,15128 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Srini, Kristopher, A,23997 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Blanco, Hector, J,22938 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Cook, Sydney, D,13118 | 5669.90 | 0.00 | 0.00 | 2049.10 | 3620.80 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 0.00 | 782.99 | 578.46 |
| Tang, Latoya, F,22910 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Raman, Brett, L,22930 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Sara, Ebony,24923 | 2159.40 | 0.00 | 0.00 | 1000.44 | 1158.96 |
| Prasad, Cesar,23411 | 3577.82 | 0.00 | 0.00 | 3577.82 | 0.00 |
| Browning, Javier,23120 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Moreno, Bruce, F,26652 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Hernandez, Melody, E,28212 | 619.46 | 0.00 | 0.00 | 0.00 | 619.46 |
| Hu, Omar, S,28954 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Ramos, Michele, J,19574 | 96.74 | 0.00 | 0.00 | 0.00 | 96.74 |
| Raji, Carly, L,23346 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Alicia,25225 | 2129.92 | 0.00 | 0.00 | 1000.44 | 1129.48 |
| Alonso, Alfredo, T,23323 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Alonso, Teresa,13138 | 83.97 | 0.00 | 0.00 | 3.99 | 79.98 |
| Romero, Kathleen,14019 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Navarro, Teresa, E,25816 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| He, Curtis, D,24921 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Liang, Darryl,26658 | 1390.95 | 0.00 | 0.00 | 1390.95 | 0.00 |
| Hall, Amanda,26656 | 1345.95 | 0.00 | 0.00 | 1345.95 | 0.00 |
| Huang, Lacey, J,11951 | 63.52 | 0.00 | 0.00 | 0.00 | 63.52 |
| Zhao, Crystal,25906 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Schmidt, Danny, M,28926 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Srini, Candace,15437 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Fernandez, Cassandra, C,14134 | 3835.07 | 0.00 | 0.00 | 2049.10 | 1785.97 |
| Liu, Lacey, L,23545 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Serrano, Rebekah,14130 | 3814.06 | 0.00 | 0.00 | 2049.10 | 1764.96 |
| Chandra, Arthur, L,14032 | 6859.43 | 0.00 | 0.00 | 2071.42 | 4788.01 |
| Shen, Roger, G,14011 | 3831.89 | 0.00 | 0.00 | 2071.42 | 1760.47 |
| Kumar, Alejandro,14055 | 5177.40 | 0.00 | 0.00 | 2049.10 | 3128.30 |
| Li, Jack, J,14071 | 5617.92 | 0.00 | 0.00 | 2049.10 | 3568.82 |
| Vazquez, Marvin, K,21953 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Madan, Kristi, I,29184 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Dominguez, Sabrina, M,28116 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Gomez, Mallory, R,24898 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ms., Rousey, Linda, R.,21279 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bailey, Savannah, J,23428 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zeng, Ramon,27979 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gill, Jimmy,29098 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Gill, Ricky, A,15607 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Lu, Warren, H,28925 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Subram, Meredith, S,14261 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Black, Michele,13995 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Lin, Kelli, A,21392 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Raheem, Bethany, L,21965 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Prasad, Denise,18294 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Martin, Byron, E,25217 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gonzalez, Cynthia,15787 | 167.93 | 0.00 | 0.00 | 0.00 | 167.93 |
| Rana, Meredith,25032 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| He, Dennis, J,27878 | 1283.82 | 0.00 | 0.00 | 0.00 | 1283.82 |
| Srini, Douglas, M,16733 | 35.26 | 0.00 | 0.00 | 0.00 | 35.26 |
| Huang, Mandy,18266 | 72.26 | 0.00 | 0.00 | 0.00 | 72.26 |
| Shen, Devon, G,27358 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Gomez, Erik, T,29180 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Torres, Kellie,19569 | 112.24 | 0.00 | 0.00 | 0.00 | 112.24 |
| Ramos, Kendra,24896 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Gutierrez, Micheal, S,27299 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Li, Glenn, A,29295 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Anand, Calvin, E,28717 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Perez, Rachael, D,26762 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Andersen, Deborah,19610 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Patel, Veronica,13963 | 74.48 | 0.00 | 0.00 | 0.00 | 74.48 |
| Chande, Bonnie, L,23992 | 3167.82 | 0.00 | 0.00 | 2443.35 | 724.47 |
| Griffin, Noah, E,29118 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Luo, Kenneth, S,15211 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Lopez, Toni, K,25140 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Alonso, Billy, M,22852 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Malhotra, Meredith,29314 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Anand, Tamara,29088 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Hu, Susan,25242 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Blanco, Alberto, R,27867 | 2443.55 | 0.00 | 0.00 | 0.00 | 2443.55 |
| McDonald, Brent,14068 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Zhao, Jamie,16179 | 72.16 | 0.00 | 0.00 | 0.00 | 72.16 |
| Pal, Dale,18451 | 75.47 | 0.00 | 0.00 | 0.00 | 75.47 |
| Goel, Karla, L,11146 | 112.93 | 0.00 | 0.00 | 53.95 | 58.98 |
| Goel, Roger, A,23652 | 3907.54 | 0.00 | 0.00 | 2181.56 | 1725.98 |
| Jimenez, Jaime, E,29095 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Alvarez, Marvin,23651 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Hall, Mary, R,20277 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Shen, Cedric,22209 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Ashe, Barbara,18734 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Chapman, Pamela, L,27145 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Anand, Alison, J,24009 | 2746.04 | 0.00 | 0.00 | 2181.56 | 564.48 |
| Kapoor, Phillip,27581 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Davis, Nicole,22957 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Reed, Kimberly, D,17311 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| James, Evan, V,11119 | 85.22 | 0.00 | 0.00 | 35.23 | 49.99 |
| Deng, Colleen, S,27728 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Anand, Cassie, M,29342 | 801.83 | 0.00 | 0.00 | 0.00 | 801.83 |
| Chander, Kelvin, E,27879 | 1313.34 | 0.00 | 0.00 | 0.00 | 1313.34 |
| Suarez, Neil,15242 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Fernandez, Kristi,19585 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Zeng, Stacey, J,17317 | 128.95 | 0.00 | 0.00 | 0.00 | 128.95 |
| Li, Cara,27587 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 |
| Serrano, Randall,27973 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Vazquez, Janet, R,21973 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Zhou, Steve, C,20263 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Serrano, Danny,24381 | 3970.52 | 0.00 | 0.00 | 2181.56 | 1788.96 |
| Nara, Lindsay, M,25247 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Serrano, Alberto, L,15800 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Lal, Franklin, A,14101 | 3679.90 | 0.00 | 0.00 | 2049.10 | 1630.80 |
| Thomas, Sydney,14322 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Navarro, Byron,16622 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
Generated 2025-12-22 00:10:11.042 UTC