[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 750 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Perez, Ivan, S,23408 | 4218.82 | 0.00 | 0.00 | 2443.35 | 1775.47 |
| Rubio, Beth,20240 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Kapoor, Kristina,11997 | 7029.78 | 0.00 | 3399.99 | 1249.84 | 2379.95 |
| Ramos, Theresa, G,11031 | 6478.60 | 3399.99 | 0.00 | 0.00 | 3078.61 |
| Yang, Alan, L,15605 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Shan, Clarence,22408 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Nara, Tony, L,16713 | 6090.59 | 3578.27 | 0.00 | 2512.32 | 0.00 |
| Dominguez, Diana, L,29292 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 8.99 | 64.97 |
| Lewis, Justin, L,28303 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Raman, Rachael,25216 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Suarez, Daisy, A,18288 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Vazquez, Casey, S,13132 | 6880.62 | 0.00 | 0.00 | 2049.10 | 4831.52 |
| Sullivan, Dominic, M,22840 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Raman, Ruth, L,21199 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Green, Devin, J,26440 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Ruiz, Frank, M,14260 | 3716.23 | 0.00 | 0.00 | 2964.89 | 751.34 |
| Raje, Casey, A,14686 | 203.46 | 0.00 | 0.00 | 0.00 | 203.46 |
| Collins, James, E,26742 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Martinez, Cynthia,22170 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Dominguez, Stacy, S,19105 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Ortega, Julio, M,11892 | 8119.03 | 0.00 | 3399.99 | 0.00 | 4719.04 |
| Navarro, Kristy, J,19570 | 74.94 | 0.00 | 0.00 | 45.95 | 28.99 |
| Sun, Jaclyn,18211 | 65.96 | 0.00 | 0.00 | 56.97 | 8.99 |
| Sanders, Devin, J,12014 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Lal, Shaun, H,17056 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Rai, Brad, S,18490 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Liang, Omar,24245 | 17.27 | 0.00 | 0.00 | 0.00 | 17.27 |
| Malhotra, Cory, E,17923 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Reed, Kimberly, D,17311 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Suarez, Renee, L,12703 | 6891.12 | 0.00 | 0.00 | 2049.10 | 4842.02 |
| Raje, Kelli, A,28136 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Ashe, Deanna,20284 | 5328.23 | 0.00 | 3578.27 | 0.00 | 1749.96 |
| Barnes, Mariah, H,19621 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Sanz, Gerald, J,17060 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Xu, Grant, M,19266 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Gao, Louis,14666 | 5199.92 | 0.00 | 0.00 | 2049.10 | 3150.82 |
| Long, Mariah, C,16730 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Raji, Nicolas, N,17301 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Arun, Cory, O,16527 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Cox, Isaac,15797 | 4415.68 | 0.00 | 0.00 | 2071.42 | 2344.26 |
| Gill, Dwayne, A,19675 | 198.99 | 0.00 | 0.00 | 0.00 | 198.99 |
| Gao, Laura,22029 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Suri, Troy, M,12251 | 3924.97 | 0.00 | 3374.99 | 0.00 | 549.98 |
| Lal, Terrence,12369 | 94.23 | 0.00 | 0.00 | 0.00 | 94.23 |
| Suri, Holly, M,18286 | 141.55 | 0.00 | 0.00 | 69.97 | 71.58 |
| Goel, Karla, L,11146 | 112.93 | 0.00 | 0.00 | 53.95 | 58.98 |
| Vazquez, Mallory, M,18283 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Patel, Arthur, B,26671 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ross, Arianna, E,26774 | 1331.97 | 0.00 | 0.00 | 1331.97 | 0.00 |
| Lopez, Carmen, S,13528 | 4531.04 | 0.00 | 0.00 | 2071.42 | 2459.62 |
| Mr., Rovira Diez, Pablo,21190 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Diaz, Nelson, C,21387 | 2745.33 | 0.00 | 2181.56 | 0.00 | 563.77 |
| Zhou, Ernest, P,15792 | 2645.40 | 0.00 | 0.00 | 2645.40 | 0.00 |
| Ms., Salavaria, Sharon,11964 | 8173.53 | 0.00 | 3399.99 | 2329.99 | 2443.55 |
| Adams, Amber,26746 | 2001.45 | 0.00 | 0.00 | 782.99 | 1218.46 |
| Yang, Colin, J,20612 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| James, Brooke,18745 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Ramos, Rodney, C,14059 | 106.75 | 0.00 | 0.00 | 74.48 | 32.27 |
| Shen, Franklin,27144 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Nath, Melvin, D,27697 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Rubio, Daisy, A,16181 | 170.06 | 0.00 | 0.00 | 0.00 | 170.06 |
Generated 2025-11-04 06:34:04.623 UTC