[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 1500 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Carlson, Jill,21886 | 4696.49 | 0.00 | 2181.56 | 0.00 | 2514.93 |
| Rana, Bryant,21878 | 4663.79 | 0.00 | 2181.56 | 0.00 | 2482.23 |
| Jiménez, Daisy,21944 | 4713.89 | 0.00 | 2181.56 | 0.00 | 2532.33 |
| Kovár, Barry, A,21570 | 4705.48 | 0.00 | 2181.56 | 0.00 | 2523.92 |
| Jimenez, Gary, E,16609 | 344.04 | 0.00 | 0.00 | 84.95 | 259.09 |
| Raje, Lindsey,24614 | 2120.93 | 0.00 | 1000.44 | 1120.49 | 0.00 |
| Navarro, Kellie, I,21873 | 4661.50 | 0.00 | 2181.56 | 0.00 | 2479.94 |
| Mehta, Cindy, A,21943 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Malhotra, Mayra, E,15577 | 143.45 | 0.00 | 0.00 | 0.00 | 143.45 |
| Dominguez, Micheal,26142 | 1952.45 | 0.00 | 782.99 | 0.00 | 1169.46 |
| Raji, Donna,24906 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Flores, Alexandra, C,26165 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Srini, Joe,22180 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Madan, Toni,26668 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Brown, Cameron, D,13041 | 153.95 | 0.00 | 0.00 | 0.00 | 153.95 |
| Ramos, Briana, J,14303 | 3636.91 | 0.00 | 0.00 | 2049.10 | 1587.81 |
| Moreno, Beth,21980 | 4334.61 | 0.00 | 0.00 | 2443.35 | 1891.26 |
| Fernandez, Ivan,22032 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Suri, Arthur,26190 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Barnes, Julia, R,21999 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Lal, Deborah, T,21982 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Hill, Noah,26192 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Andersen, Drew, K,22412 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Blanco, Orlando,22575 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Long, Alexis,22580 | 3051.31 | 0.00 | 0.00 | 2443.35 | 607.96 |
| Nara, Kelsey, A,24905 | 2195.91 | 0.00 | 0.00 | 1000.44 | 1195.47 |
| Morris, Isaac, G,26439 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Vazquez, Juan, P,22578 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Shan, Clarence,22408 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Rubio, Nelson,26433 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Shen, Alisha, J,26438 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Fernandez, Arthur, J,22399 | 2785.05 | 0.00 | 0.00 | 2181.56 | 603.49 |
| Sanz, Lance,22573 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Rubio, Pedro, E,23098 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Li, Krystal, A,24912 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Chandra, Harold, K,17236 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Ramos, Roberto, M,13159 | 208.18 | 0.00 | 0.00 | 0.00 | 208.18 |
| Deng, Grant, C,16625 | 81.81 | 0.00 | 0.00 | 0.00 | 81.81 |
| Gomez, Marvin, C,28479 | 831.33 | 0.00 | 0.00 | 0.00 | 831.33 |
| Li, Luis, K,20251 | 59.47 | 0.00 | 0.00 | 0.00 | 59.47 |
| Sullivan, Henry, L,20603 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Xu, Dennis,21997 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Suarez, Orlando,11121 | 58.16 | 0.00 | 0.00 | 0.00 | 58.16 |
| Zhu, Jenny, J,17078 | 186.94 | 0.00 | 0.00 | 186.94 | 0.00 |
| Goel, Karla, L,11146 | 112.93 | 0.00 | 0.00 | 53.95 | 58.98 |
| Pal, Peter, K,22848 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Liang, Steve,14317 | 81.26 | 0.00 | 0.00 | 49.99 | 31.27 |
| Sai, Martin, L,21221 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Wu, Alisha,23654 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Chander, Misty,17333 | 80.94 | 0.00 | 0.00 | 0.00 | 80.94 |
| Zhou, Colleen,23122 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Powell, Elizabeth, K,28306 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Serrano, Dana, S,12678 | 341.43 | 0.00 | 0.00 | 89.46 | 251.97 |
| Andersen, Rafael, E,12691 | 247.46 | 0.00 | 0.00 | 0.00 | 247.46 |
| Raji, Derek, D,19591 | 63.42 | 0.00 | 0.00 | 0.00 | 63.42 |
| She, Candice,29178 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Mr., Rovira Diez, Pablo,21190 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Xu, Jessie, R,27517 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Raji, Maurice, C,20619 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Malhotra, Terrance, E,20223 | 187.38 | 0.00 | 0.00 | 0.00 | 187.38 |
| Luo, Nichole, A,29296 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Tang, Louis, A,18292 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Gill, Jimmy,29098 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Coleman, Brittany,15579 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Ramos, Jaime,15720 | 70.22 | 0.00 | 0.00 | 35.23 | 34.99 |
| Johnsen, Willie,15218 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Yang, Colleen,22167 | 123.98 | 0.00 | 0.00 | 123.98 | 0.00 |
| Vazquez, Danny, J,26033 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| She, Katie, B,11965 | 118.74 | 0.00 | 0.00 | 94.25 | 24.49 |
| Travers, Danny,12587 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Perez, Preston,12370 | 61.53 | 0.00 | 0.00 | 34.56 | 26.97 |
| Moreno, Mallory, P,22912 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Gonzalez, Cynthia,15787 | 167.93 | 0.00 | 0.00 | 0.00 | 167.93 |
| Serrano, Neil, L,17076 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Arthur, Tammy, L,21363 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Suarez, Gina,20248 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| She, Kristin, L,19961 | 97.97 | 0.00 | 0.00 | 0.00 | 97.97 |
| Weber, Levi, A,13120 | 205.39 | 0.00 | 0.00 | 49.48 | 155.91 |
| Li, Justin,14124 | 57.59 | 0.00 | 0.00 | 0.00 | 57.59 |
| Gutierrez, Jay, C,13155 | 226.95 | 0.00 | 0.00 | 84.47 | 142.48 |
| Gomez, Erik, T,29180 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Chen, Jake,22845 | 4633.90 | 0.00 | 0.00 | 2181.56 | 2452.34 |
| Patel, Rachael, G,13640 | 71.25 | 0.00 | 0.00 | 32.27 | 38.98 |
| Russell, Noah, M,26447 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Chander, Julie, E,18763 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Subram, Rebekah,26030 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Huang, Margaret, H,17070 | 123.96 | 0.00 | 0.00 | 123.96 | 0.00 |
| Sara, Ruben, A,19566 | 164.91 | 0.00 | 0.00 | 0.00 | 164.91 |
| Lopez, Carla, G,28326 | 2442.54 | 0.00 | 0.00 | 2442.54 | 0.00 |
| Kapoor, Abby, J,29054 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Martinez, Cory, A,15125 | 81.26 | 0.00 | 0.00 | 31.27 | 49.99 |
| Guo, Cara, R,15721 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Chen, Claudia, R,16627 | 64.88 | 0.00 | 0.00 | 29.99 | 34.89 |
| Alonso, Raquel,17313 | 51.92 | 0.00 | 0.00 | 0.00 | 51.92 |
| Gutierrez, Erika,17227 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Tang, Barbara,27711 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Raje, Arturo, C,14228 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Yang, Darryl, K,21571 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Li, Glenn, A,29295 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Williams, Madison, J,21198 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Lal, Clarence, L,24470 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jiménez, Darren, W,28931 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Ramos, Kristy,16682 | 66.58 | 0.00 | 0.00 | 0.00 | 66.58 |
| Suri, Shane, L,25126 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Yang, Lacey,13150 | 89.24 | 0.00 | 0.00 | 0.00 | 89.24 |
| Munoz, Robyn,14214 | 5759.87 | 0.00 | 0.00 | 2049.10 | 3710.77 |
| Serrano, Lori,17066 | 105.75 | 0.00 | 0.00 | 0.00 | 105.75 |
| Travers, Reginald,28488 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Garcia, Monica, D,20267 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Liu, Dennis,29062 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Kumar, Yolanda, J,18194 | 85.96 | 0.00 | 0.00 | 0.00 | 85.96 |
| Gill, Billy, L,16700 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Carlson, Lawrence, L,22064 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Chander, Cassie, M,18258 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Huang, Amy, C,12244 | 114.96 | 0.00 | 0.00 | 49.99 | 64.97 |
| Patel, Gerald,23095 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rodriguez, Dylan, E,16611 | 75.53 | 0.00 | 0.00 | 42.93 | 32.60 |
| Patel, Cynthia, M,15222 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Suri, Holly, M,18286 | 141.55 | 0.00 | 0.00 | 69.97 | 71.58 |
| Liu, Krystal, D,13526 | 4549.76 | 0.00 | 0.00 | 2071.42 | 2478.34 |
| Wu, Lisa,26158 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Alonso, Gloria, S,19964 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Blanco, Alberto, R,27867 | 2443.55 | 0.00 | 0.00 | 0.00 | 2443.55 |
Generated 2025-11-03 20:52:41.626 UTC