[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 833 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Nelson, Julia, L,11102 | 102.91 | 0.00 | 0.00 | 0.00 | 102.91 |
| Jones, Emily,16659 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| King, Evan,16637 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Sanz, Lawrence, M,14030 | 6905.47 | 0.00 | 0.00 | 2071.42 | 4834.05 |
| Liang, Alejandro, W,29193 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Kapoor, Jarrod,28930 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Deng, Kurt, D,13635 | 215.74 | 0.00 | 0.00 | 0.00 | 215.74 |
| Ashe, Kathryn,16168 | 80.11 | 0.00 | 0.00 | 0.00 | 80.11 |
| Zheng, Omar, C,14522 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Nath, Omar, F,14672 | 5237.72 | 0.00 | 0.00 | 2071.42 | 3166.30 |
| Wang, Micah, C,14676 | 5188.41 | 0.00 | 0.00 | 2049.10 | 3139.31 |
| Garcia, George,20160 | 4237.22 | 0.00 | 3578.27 | 0.00 | 658.95 |
| Tang, Colin,14323 | 5222.02 | 0.00 | 0.00 | 2071.42 | 3150.60 |
| Wang, Randy, G,25125 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Chavez, Colin,16032 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Srini, Jay, M,18326 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Richardson, Abigail, S,14236 | 5710.23 | 0.00 | 0.00 | 2071.42 | 3638.81 |
| Rana, Cory, E,16173 | 43.21 | 0.00 | 0.00 | 0.00 | 43.21 |
| Garcia, Jermaine,21566 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Chander, Tommy,19086 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Huang, Crystal, L,26023 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Martin, Felicia, L,15018 | 112.46 | 0.00 | 0.00 | 0.00 | 112.46 |
| Shen, Jaclyn, A,12575 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| She, Christine,16184 | 78.20 | 0.00 | 0.00 | 0.00 | 78.20 |
| Zhu, Colleen,17252 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Martin, Joe,14668 | 5216.69 | 0.00 | 0.00 | 2071.42 | 3145.27 |
| He, Colin, B,14300 | 5322.73 | 0.00 | 0.00 | 2071.42 | 3251.31 |
| Ruiz, Sabrina, A,22214 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Gomez, Alfredo, C,18200 | 4150.53 | 0.00 | 3578.27 | 0.00 | 572.26 |
| Vazquez, Danny, J,26033 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Nelson, Mary, L,13107 | 5650.90 | 0.00 | 0.00 | 2049.10 | 3601.80 |
| Williams, Madison, J,21198 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Barnes, Alexia, D,15231 | 59.48 | 0.00 | 0.00 | 0.00 | 59.48 |
| Raji, Shawna, P,13961 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Hernandez, Mathew, A,15184 | 4441.38 | 0.00 | 0.00 | 2071.42 | 2369.96 |
| Shan, Colleen, D,15150 | 4379.08 | 0.00 | 0.00 | 2049.10 | 2329.98 |
| Sanchez, Cynthia, S,23662 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Raje, Kurt,15210 | 2926.39 | 0.00 | 0.00 | 2071.42 | 854.97 |
| Collins, James, E,26742 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Edwards, Evan, L,21888 | 4925.58 | 0.00 | 0.00 | 2443.35 | 2482.23 |
| Raman, Meagan, J,15134 | 5151.71 | 0.00 | 0.00 | 2071.42 | 3080.29 |
| Yuan, Bradley,17920 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Subram, Francisco, A,21897 | 4909.67 | 0.00 | 0.00 | 2443.35 | 2466.32 |
| Chander, Carl,14315 | 109.71 | 0.00 | 0.00 | 0.00 | 109.71 |
| Young, Allison, R,23644 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Schmidt, Shane,17922 | 4821.72 | 0.00 | 3578.27 | 0.00 | 1243.45 |
| King, Nathan,27719 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Shen, Brendan, L,14305 | 3652.20 | 0.00 | 0.00 | 2049.10 | 1603.10 |
| Xu, Tasha, E,11948 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Rubio, Daisy, A,16181 | 170.06 | 0.00 | 0.00 | 0.00 | 170.06 |
| Jai, Calvin, S,22918 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perez, Henry,26752 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Gutierrez, Philip, M,21979 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Dominguez, Neil, K,23663 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Gutierrez, Jill, N,26024 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Martin, Joan, R,25556 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Goel, Carly, C,12989 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Ms., Robinson, Rebecca, A.,11913 | 41.26 | 0.00 | 0.00 | 0.00 | 41.26 |
| Zheng, Barbara,27493 | 1353.46 | 0.00 | 0.00 | 782.99 | 570.47 |
| Zhang, Kristen,27484 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
Generated 2026-01-04 05:25:27.506 UTC