[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 1124 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lopez, Brenda,26592 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Jai, Calvin, S,22918 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Becker, Leonard, C,22405 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Mehta, Deanna, P,17280 | 6089.59 | 3578.27 | 0.00 | 0.00 | 2511.32 |
| Morgan, Nathaniel, E,16626 | 71.57 | 0.00 | 0.00 | 36.59 | 34.98 |
| Hernandez, Melinda,16174 | 140.45 | 0.00 | 0.00 | 0.00 | 140.45 |
| Black, Peter, E,21213 | 64.26 | 0.00 | 0.00 | 0.00 | 64.26 |
| Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Huang, Jorge,17291 | 86.27 | 0.00 | 0.00 | 53.99 | 32.28 |
| Flores, Adam, L,11044 | 6515.30 | 3374.99 | 0.00 | 0.00 | 3140.31 |
| She, Roger, L,15724 | 4359.07 | 0.00 | 0.00 | 2049.10 | 2309.97 |
| Malhotra, Kristopher, L,15265 | 2897.57 | 0.00 | 0.00 | 2049.10 | 848.47 |
| Mr., Solanki, Ajay,18295 | 144.27 | 0.00 | 0.00 | 0.00 | 144.27 |
| Madan, Denise, R,25248 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alvarez, Jessie,14324 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
| Ashe, Marshall,28932 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Fernandez, Emmanuel,28955 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Ye, Vincent,13013 | 256.24 | 0.00 | 0.00 | 0.00 | 256.24 |
| Rai, Willie,14673 | 5117.75 | 0.00 | 0.00 | 2071.42 | 3046.33 |
| Alonso, Naomi,15830 | 2680.38 | 0.00 | 0.00 | 2071.42 | 608.96 |
| Gomez, Danny, V,16636 | 5932.74 | 3578.27 | 0.00 | 0.00 | 2354.47 |
| Russell, Alexis, L,13634 | 234.93 | 0.00 | 0.00 | 0.00 | 234.93 |
| Wood, Sydney,23310 | 3333.32 | 0.00 | 0.00 | 3333.32 | 0.00 |
| Serrano, Gloria, G,21556 | 4930.68 | 0.00 | 2443.35 | 0.00 | 2487.33 |
| Carlson, Philip, P,11915 | 8143.00 | 0.00 | 3374.99 | 2369.96 | 2398.05 |
| Perez, Evelyn,14346 | 3583.26 | 0.00 | 0.00 | 2071.42 | 1511.84 |
| Blanco, Alberto, R,27867 | 2443.55 | 0.00 | 0.00 | 0.00 | 2443.55 |
| Kovar, Nancy, F,26568 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Raman, Cindy,16157 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Evans, Jackson,14321 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| She, Ashlee,28319 | 556.93 | 0.00 | 0.00 | 0.00 | 556.93 |
| Suri, Cassandra, B,18717 | 87.21 | 0.00 | 0.00 | 0.00 | 87.21 |
| Sharma, Lindsay, E,24478 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Torres, Neil,17305 | 196.97 | 0.00 | 0.00 | 196.97 | 0.00 |
| Ruiz, Marvin, R,18796 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Flores, Katherine,21180 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Clark, Sydney,16610 | 67.58 | 0.00 | 0.00 | 32.60 | 34.98 |
| Liu, Susan,18718 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Evans, Carlos, J,23538 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Zhang, Glenn, A,13967 | 5721.91 | 0.00 | 0.00 | 2049.10 | 3672.81 |
| Suarez, Tabitha,25110 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Patterson, Ashley, R,18736 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Moreno, Lori, M,15226 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Anand, Jodi,26129 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Zheng, Roger,29321 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Allen, Devin,15806 | 102.85 | 0.00 | 0.00 | 38.88 | 63.97 |
| Lu, Randy,26441 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Xie, Marshall, M,19796 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Dominguez, Robyn, P,23305 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Goel, Misty, M,18245 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Guo, Randy, L,22956 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Arun, Ruth, S,17294 | 4355.71 | 3578.27 | 0.00 | 0.00 | 777.44 |
| He, Brent, R,25712 | 1262.06 | 0.00 | 699.10 | 0.00 | 562.96 |
| Gomez, Erik, T,29180 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Raji, Corey,25058 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Russell, Cassidy, N,26144 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Black, Shaun, M,17355 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Gonzalez, Jan, A,15262 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Gonzales, Logan,16607 | 5897.53 | 3578.27 | 0.00 | 0.00 | 2319.26 |
| Raman, Allen, R,25129 | 60.47 | 0.00 | 0.00 | 60.47 | 0.00 |
| Foster, Lucas,13519 | 4492.45 | 0.00 | 0.00 | 4492.45 | 0.00 |
| Munoz, Robyn,14214 | 5759.87 | 0.00 | 0.00 | 2049.10 | 3710.77 |
| Hall, Jeremiah, M,18250 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Li, Dawn, B,13962 | 40.22 | 0.00 | 0.00 | 40.22 | 0.00 |
| Serrano, Leslie, T,14014 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Suri, Gerald,13617 | 116.92 | 0.00 | 0.00 | 0.00 | 116.92 |
| Watson, Maria,17229 | 4471.74 | 3578.27 | 0.00 | 0.00 | 893.47 |
| Srini, Kristopher, A,23997 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Guo, Glenn, J,18712 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Andersen, Nina,18338 | 6124.58 | 0.00 | 3578.27 | 0.00 | 2546.31 |
| Washington, Julian, C,23330 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Price, Isabella, L,17278 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Kumar, Wayne,17502 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Sanz, Larry,14067 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Sun, Suzanne, P,24587 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Bradley, Victoria,29454 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Munoz, Monique,24008 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Sara, Adriana, M,15146 | 161.94 | 0.00 | 0.00 | 0.00 | 161.94 |
| Dominguez, Leslie,27346 | 1390.95 | 0.00 | 0.00 | 782.99 | 607.96 |
| Patel, Bryant, L,27969 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Gonzalez, Deanna, S,15204 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Ye, Willie,22963 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Xu, Cedric, M,24278 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| Lopez, Stanley, M,28962 | 2477.53 | 0.00 | 0.00 | 0.00 | 2477.53 |
| Browning, Jay, M,24251 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Stone, Christine, D,25948 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Chande, Kelli, C,22933 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| She, Mandy, K,21972 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Rubio, Juan,16170 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Campbell, Jason, J,13625 | 6962.14 | 0.00 | 0.00 | 2049.10 | 4913.04 |
| Diaz, Gerald, M,25118 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Foster, Luke,15137 | 161.94 | 0.00 | 0.00 | 97.97 | 63.97 |
| Patterson, Kyle,11448 | 8132.01 | 0.00 | 3374.99 | 2318.96 | 2438.06 |
| Vazquez, Juan, P,22578 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Sun, Todd,22018 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Lopez, Cesar,17500 | 156.96 | 0.00 | 0.00 | 0.00 | 156.96 |
| Yang, Hunter, E,20237 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Serrano, Julio,20992 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Ashe, Brad,25228 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Zhang, Warren, L,25252 | 1893.05 | 699.10 | 0.00 | 0.00 | 1193.95 |
| Lal, Karla,25219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Xu, Alison,14227 | 114.96 | 0.00 | 0.00 | 49.99 | 64.97 |
| Ma, Lacey, K,18723 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Shen, Michele,27985 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Sanchez, Carla,18274 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Liu, Bianca, K,11458 | 31.92 | 0.00 | 0.00 | 0.00 | 31.92 |
| Raje, Louis, M,25707 | 1262.06 | 0.00 | 699.10 | 0.00 | 562.96 |
| Li, Karen, K,17921 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Martin, Deanna,13091 | 6864.95 | 0.00 | 0.00 | 2071.42 | 4793.53 |
| Chandra, Gerald,25131 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chande, Ashlee, N,23096 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ma, Louis,21879 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Carter, Sophia, D,25230 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Deng, Michele,21946 | 4659.80 | 0.00 | 2181.56 | 0.00 | 2478.24 |
| Srini, Candace,15437 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Ye, Claudia, J,19102 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Ma, Cara,18885 | 110.46 | 0.00 | 0.00 | 110.46 | 0.00 |
| Ashe, Orlando, I,11897 | 8203.02 | 0.00 | 3399.99 | 0.00 | 4803.03 |
| Mr., Short, Carlos, M.,25139 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Andersen, Ashlee, J,11059 | 116.93 | 0.00 | 0.00 | 116.93 | 0.00 |
| Smith, Tina, K,19793 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Black, Michele,13995 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Ramos, Jerome, L,29187 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Ramos, Francis,16345 | 4173.24 | 3578.27 | 0.00 | 0.00 | 594.97 |
Generated 2025-11-04 06:51:13.530 UTC