[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 625 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Stone, Brenda, J,12697 | 296.19 | 0.00 | 0.00 | 0.00 | 296.19 |
| Nara, Tara,21194 | 3911.53 | 0.00 | 2181.56 | 0.00 | 1729.97 |
| Zeng, Suzanne,17918 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Nara, Dale, L,21226 | 4659.80 | 0.00 | 2181.56 | 0.00 | 2478.24 |
| Lal, Terry,18277 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Alvarez, Jessie,14324 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
| Tang, Terrence, R,17303 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Yuan, Kelsey, D,13034 | 94.71 | 0.00 | 0.00 | 0.00 | 94.71 |
| Suarez, Lawrence, C,26131 | 1952.45 | 0.00 | 782.99 | 0.00 | 1169.46 |
| Ortega, Eddie,22908 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Madan, Patricia, L,22988 | 4194.33 | 0.00 | 0.00 | 2443.35 | 1750.98 |
| Jenkins, Anna, M,17234 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| White, Olivia, E,18457 | 4826.23 | 0.00 | 3578.27 | 0.00 | 1247.96 |
| Rana, Ruben,27696 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Nath, Melvin, D,27697 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Gill, Dwayne, A,19675 | 198.99 | 0.00 | 0.00 | 0.00 | 198.99 |
| Chen, Bianca,24891 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Beck, April,14302 | 5140.73 | 0.00 | 0.00 | 2071.42 | 3069.31 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Raman, Veronica, R,12359 | 95.74 | 0.00 | 0.00 | 0.00 | 95.74 |
| Simpson, Sharon, L,25123 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alvarez, Diana,13638 | 6832.12 | 0.00 | 0.00 | 2049.10 | 4783.02 |
| Nelson, Julia, L,11102 | 102.91 | 0.00 | 0.00 | 0.00 | 102.91 |
| Zheng, Sandra, P,15141 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Martin, Adrienne,19952 | 39.46 | 0.00 | 0.00 | 25.48 | 13.98 |
| Wu, Aimee,16690 | 165.07 | 0.00 | 0.00 | 0.00 | 165.07 |
| Tang, Christy, R,23660 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Kapoor, Cynthia,29457 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Torres, Sebastian, V,25831 | 1882.57 | 0.00 | 699.10 | 0.00 | 1183.47 |
| Suri, Phillip,17914 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Hernandez, Bruce,17919 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Jai, Tommy, C,15027 | 2853.57 | 0.00 | 0.00 | 2049.10 | 804.47 |
| Sullivan, Summer, E,21181 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Raman, Virginia,26159 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Liang, Alejandro, W,29193 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Carlson, Ebony,13959 | 6858.42 | 0.00 | 0.00 | 2049.10 | 4809.32 |
| Ma, Curtis,28119 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Blanco, Hector, J,22938 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Gomez, Adrienne,11920 | 8156.32 | 0.00 | 3374.99 | 0.00 | 4781.33 |
| Gonzalez, Cynthia,15787 | 167.93 | 0.00 | 0.00 | 0.00 | 167.93 |
| Moreno, Tanya,11139 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Murphy, Grace, J,23655 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Fernandez, Holly, M,12675 | 6812.77 | 0.00 | 2071.42 | 0.00 | 4741.35 |
| Sai, Tina, L,15425 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Zeng, Jon, O,14310 | 5200.66 | 0.00 | 0.00 | 2071.42 | 3129.24 |
| Lopez, Kristopher, L,21560 | 4702.39 | 0.00 | 2181.56 | 0.00 | 2520.83 |
| Xie, Casey,21217 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Ma, Colin,26428 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Luo, Lacey,24175 | 2743.04 | 0.00 | 0.00 | 2181.56 | 561.48 |
| Lal, Alisha, C,21872 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Huang, Lacey, J,11951 | 63.52 | 0.00 | 0.00 | 0.00 | 63.52 |
| Vance, Toni, L,23438 | 123.48 | 0.00 | 0.00 | 0.00 | 123.48 |
| 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 |
| Kapoor, Candace,18282 | 30.97 | 0.00 | 0.00 | 21.98 | 8.99 |
| Wang, Laura, L,26146 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ashe, Marshall,28932 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Blanco, Lee, M,16660 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Sanchez, Michelle, R,26569 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Green, Jonathan, A,17332 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Zhu, Gilbert,11921 | 63.24 | 0.00 | 0.00 | 0.00 | 63.24 |
| Malhotra, Marco, L,29459 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Sun, Suzanne, P,24587 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Cooper, Cody, A,16028 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Rai, Shaun,26431 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Raje, Donna, A,20607 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Alonso, Krista, P,20212 | 100.74 | 0.00 | 0.00 | 0.00 | 100.74 |
| Jai, Latoya, S,21229 | 4198.33 | 0.00 | 2443.35 | 0.00 | 1754.98 |
| Shen, Wayne, P,23647 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Nath, Louis, C,25830 | 1833.57 | 0.00 | 699.10 | 0.00 | 1134.47 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| Zhou, Laura, D,12683 | 6801.45 | 0.00 | 2071.42 | 0.00 | 4730.03 |
| Johnson, Morgan, E,12011 | 4735.81 | 0.00 | 3374.99 | 618.47 | 742.35 |
| Anand, Jodi,26129 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Gray, Brooke, P,26756 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Shan, Jenny, W,16706 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| 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 |
| Nara, Karla, C,25827 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Chander, Keith, A,24174 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Suarez, Melinda,29181 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Perez, Joe, A,14326 | 5207.70 | 0.00 | 0.00 | 2071.42 | 3136.28 |
| Lal, Kate,21557 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Gill, Kellie,17292 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Carson, Mitchell,13623 | 99.20 | 0.00 | 0.00 | 0.00 | 99.20 |
| Zhang, Ronnie,16656 | 5930.23 | 3578.27 | 0.00 | 0.00 | 2351.96 |
| Guo, Jon,22927 | 3913.82 | 0.00 | 0.00 | 2181.56 | 1732.26 |
| Xu, Alejandro, R,26585 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Butler, Jason,17510 | 4369.74 | 0.00 | 3578.27 | 0.00 | 791.47 |
| Sai, Levi,16349 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Cai, Gilbert, J,18256 | 98.96 | 0.00 | 0.00 | 63.97 | 34.99 |
| Barnes, Taylor,14279 | 5137.71 | 0.00 | 0.00 | 2049.10 | 3088.61 |
| Goel, Mario, J,12360 | 6750.48 | 0.00 | 2071.42 | 0.00 | 4679.06 |
| Hernandez, Logan,12350 | 6791.75 | 0.00 | 2071.42 | 0.00 | 4720.33 |
| Liu, Kelli, A,24480 | 4175.61 | 0.00 | 0.00 | 2443.35 | 1732.26 |
| Jiménez, Byron,16026 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Turner, Rebecca, W,27699 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gonzalez, George, L,11942 | 4792.29 | 0.00 | 3399.99 | 614.96 | 777.34 |
| Sanz, Rodney,16926 | 44.95 | 0.00 | 0.00 | 0.00 | 44.95 |
| He, Karen, C,27861 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Sullivan, Ruth,27723 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Ye, Vincent,13013 | 256.24 | 0.00 | 0.00 | 0.00 | 256.24 |
| Suarez, Joy, B,12665 | 74.54 | 0.00 | 0.00 | 0.00 | 74.54 |
| Xu, Brad,26157 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sun, Mandy, L,16694 | 78.20 | 0.00 | 0.00 | 39.22 | 38.98 |
| Zhu, Colleen,17252 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Chavez, Corey, R,15731 | 59.98 | 0.00 | 0.00 | 24.99 | 34.99 |
| Serrano, Gerald, M,27591 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bryant, Madison, J,16481 | 194.91 | 0.00 | 0.00 | 0.00 | 194.91 |
| Zeng, Erica,26924 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Andersen, Warren,11919 | 8171.52 | 0.00 | 3374.99 | 0.00 | 4796.53 |
| Lu, Randy,26441 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Washington, Sydney,28924 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nath, Keith,19617 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
| Madan, Brandy, A,27687 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Dominguez, Roberto, A,26917 | 1339.25 | 0.00 | 0.00 | 782.99 | 556.26 |
| Jiménez, Briana, T,28118 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Yang, Rosa,18713 | 237.26 | 0.00 | 0.00 | 0.00 | 237.26 |
| Zeng, Stacey, J,17317 | 128.95 | 0.00 | 0.00 | 0.00 | 128.95 |
| Kumar, Derek, M,15135 | 4381.39 | 0.00 | 0.00 | 2071.42 | 2309.97 |
| Sutton, Kern, A,26660 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Pal, Mohamed, D,12698 | 6786.75 | 0.00 | 2071.42 | 0.00 | 4715.33 |
| Johnsen, Willie,15218 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Vazquez, Danny, J,26033 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| Goldberg, Mindy,16159 | 4411.65 | 0.00 | 0.00 | 2071.42 | 2340.23 |
Generated 2025-11-04 12:43:45.607 UTC