[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 937 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jai, Alison,23657 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhu, Lacey,24167 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Hernandez, Walter,13141 | 240.24 | 0.00 | 0.00 | 0.00 | 240.24 |
| She, Corey, T,21214 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Raji, Jaclyn,18289 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Hernandez, Hailey, A,18727 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Sai, Harold,11026 | 6575.79 | 3399.99 | 0.00 | 0.00 | 3175.80 |
| Alonso, Brandi,17061 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Rubio, Beth,20240 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Lal, Tommy,14516 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Cook, Kaylee,11904 | 8214.50 | 0.00 | 3399.99 | 0.00 | 4814.51 |
| Hernandez, Jill, L,13003 | 230.25 | 0.00 | 0.00 | 0.00 | 230.25 |
| Ramirez, Isaiah,11905 | 8155.98 | 0.00 | 3374.99 | 0.00 | 4780.99 |
| Rana, Terrance, M,28134 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Henderson, Angela, T,11898 | 8179.03 | 0.00 | 3399.99 | 0.00 | 4779.04 |
| Ms., Sherwood, Irma, J.,24598 | 4228.31 | 0.00 | 0.00 | 2443.35 | 1784.96 |
| Zhang, Jon,28111 | 865.31 | 0.00 | 0.00 | 0.00 | 865.31 |
| Zhu, Jorge,26141 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Sai, Emmanuel,23417 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Zhu, Ernest,20159 | 4167.23 | 0.00 | 3578.27 | 0.00 | 588.96 |
| Green, Alex, K,20317 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Reed, Riley, A,20157 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Kapoor, Brandy, I,15236 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Mr., Rovira Diez, Pablo,21190 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Guo, Glenn, J,18712 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Nath, Carly, J,17255 | 4442.24 | 0.00 | 3578.27 | 0.00 | 863.97 |
| Stewart, Ariana,16743 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Raman, Rachael,25216 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Lopez, Cesar,17500 | 156.96 | 0.00 | 0.00 | 0.00 | 156.96 |
| Ye, Franklin, L,13952 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Chow, Shannon,18444 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Rai, Raul, R,15133 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Goel, Bridget,26134 | 1926.45 | 0.00 | 0.00 | 782.99 | 1143.46 |
| Blanco, Robyn, R,24179 | 3052.31 | 0.00 | 0.00 | 2443.35 | 608.96 |
| Evans, Mason,15439 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Jimenez, Latasha, E,13121 | 121.25 | 0.00 | 0.00 | 0.00 | 121.25 |
| Serrano, Beth,24304 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Ma, Rafael, T,13022 | 2644.02 | 0.00 | 0.00 | 2049.10 | 594.92 |
| Srini, Darren, P,15591 | 4346.38 | 0.00 | 0.00 | 2049.10 | 2297.28 |
| Cai, Jeffery, A,15582 | 2907.56 | 0.00 | 0.00 | 2049.10 | 858.46 |
| Guo, Alisha, P,23571 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Vance, Henry,27986 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Blanco, Wendy, J,19604 | 171.73 | 0.00 | 0.00 | 0.00 | 171.73 |
| Dominguez, Robin,16685 | 4183.23 | 0.00 | 3578.27 | 0.00 | 604.96 |
| Carter, Amber, E,16679 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Kumar, Jaime, O,29061 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Moreno, Melody, R,11760 | 274.92 | 0.00 | 0.00 | 0.00 | 274.92 |
| Lee, Destiny,17058 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| She, Tonya, L,16521 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Dominguez, Lee, R,24597 | 4009.50 | 0.00 | 0.00 | 2181.56 | 1827.94 |
| Subram, Arthur, E,27350 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Kumar, Tonya, A,22934 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Zhang, Tiffany, R,17318 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Arthur, Rebekah,22939 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Mehta, Marie, L,29102 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Gao, Candice, M,17493 | 130.96 | 0.00 | 0.00 | 0.00 | 130.96 |
| Kumar, Keith, M,25224 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Subram, Ronald, P,27733 | 157.29 | 0.00 | 0.00 | 0.00 | 157.29 |
| Ma, Autumn,20994 | 4191.72 | 0.00 | 3578.27 | 0.00 | 613.45 |
| Fernandez, Manuel, A,16514 | 4761.74 | 3578.27 | 0.00 | 0.00 | 1183.47 |
| Raman, Raymond, R,19588 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Cai, Alvin, D,11115 | 35.23 | 0.00 | 0.00 | 0.00 | 35.23 |
| Raji, Michele,15183 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Yang, Colleen,22167 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Ruiz, Julio,11005 | 8121.33 | 3374.99 | 0.00 | 2362.27 | 2384.07 |
| Perez, Preston,12370 | 61.53 | 0.00 | 0.00 | 0.00 | 61.53 |
| Andersen, Tonya, N,13527 | 4529.04 | 0.00 | 0.00 | 2049.10 | 2479.94 |
| Patel, Jillian,26667 | 1390.95 | 0.00 | 0.00 | 782.99 | 607.96 |
| Xu, Martha, C,16351 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Lin, Darryl, J,15031 | 41.27 | 0.00 | 0.00 | 0.00 | 41.27 |
| Zheng, Aimee, H,24283 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Andersen, Nina,18338 | 6124.58 | 0.00 | 3578.27 | 0.00 | 2546.31 |
| Yang, Todd, J,19094 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Pal, Omar,27714 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Arun, Cory, O,16527 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Gonzales, Hunter,26570 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Sanchez, Terrance,19584 | 116.74 | 0.00 | 0.00 | 0.00 | 116.74 |
| Lu, Rosa, A,16663 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 |
| Liang, Martha,16525 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Gill, Byron, J,18483 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Wu, Kelvin,24595 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 0.00 | 1179.97 |
| Shen, Roger, G,14011 | 3831.89 | 0.00 | 0.00 | 2071.42 | 1760.47 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Pais, Wilson, C,13038 | 5581.26 | 0.00 | 0.00 | 2071.42 | 3509.84 |
| Zhang, Warren, L,25252 | 1893.05 | 699.10 | 0.00 | 0.00 | 1193.95 |
| Luo, Ashlee,23534 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Lin, Kelvin, A,13075 | 6843.94 | 0.00 | 0.00 | 2071.42 | 4772.52 |
| Sai, Ann,27339 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Ramos, Monique,16495 | 6002.23 | 3578.27 | 0.00 | 0.00 | 2423.96 |
| Raji, Katrina, M,16517 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Lal, Shawna,17924 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Shen, Priscilla, A,28215 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Sharma, Terrence, N,17351 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Ramos, Joe,12353 | 6765.46 | 0.00 | 0.00 | 2071.42 | 4694.04 |
| Watson, Alexandra, H,25249 | 1868.56 | 699.10 | 0.00 | 0.00 | 1169.46 |
| Chander, Yolanda,16519 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Pal, Casey,16522 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Alvarez, Janet, G,11006 | 8119.03 | 3399.99 | 0.00 | 2334.97 | 2384.07 |
| Jai, Bonnie,11977 | 8212.50 | 0.00 | 3399.99 | 0.00 | 4812.51 |
| Serrano, Max, E,12010 | 8203.50 | 0.00 | 3374.99 | 0.00 | 4828.51 |
| Malhotra, Mayra, E,15577 | 143.45 | 0.00 | 0.00 | 0.00 | 143.45 |
| Xu, Colin, C,29461 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Ward, Haley, J,16631 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Raje, Gilbert,11055 | 8168.01 | 0.00 | 3374.99 | 0.00 | 4793.02 |
| Li, Crystal, L,14325 | 5152.70 | 0.00 | 0.00 | 2049.10 | 3103.60 |
| Gill, Monique, L,17727 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Garcia, Andre, H,12705 | 6854.11 | 0.00 | 0.00 | 2049.10 | 4805.01 |
| Allen, Hailey, C,26759 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Li, Marshall,12687 | 6805.47 | 0.00 | 0.00 | 2071.42 | 4734.05 |
| Nara, Clayton,11768 | 8139.04 | 0.00 | 3399.99 | 0.00 | 4739.05 |
| Jones, Emily,16659 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Holt, Krystal,16518 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Zheng, Jeffery, W,15030 | 3786.39 | 0.00 | 0.00 | 2071.42 | 1714.97 |
| Suarez, Kristi, D,23099 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Rodriguez, Allen, L,17732 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Huang, Damien,16524 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Yuan, Bethany, G,11030 | 6471.32 | 0.00 | 3399.99 | 0.00 | 3071.33 |
| Perez, Ross, E,14307 | 196.26 | 0.00 | 0.00 | 0.00 | 196.26 |
| Andersen, Maurice,15206 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Raman, Roy,16348 | 5918.24 | 3578.27 | 0.00 | 0.00 | 2339.97 |
Generated 2026-01-04 05:26:50.828 UTC