[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 125 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Andersen, Marshall, V,15786 | 4366.07 | 0.00 | 0.00 | 2049.10 | 2316.97 |
| Hernandez, Diana, F,11038 | 6437.33 | 3374.99 | 0.00 | 0.00 | 3062.34 |
| Guo, Lisa, S,17314 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Patel, Virginia, R,11366 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Shan, Brad, H,19605 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Ye, Christy,14219 | 5744.22 | 0.00 | 0.00 | 2071.42 | 3672.80 |
| Munoz, Ebony,13106 | 5697.52 | 0.00 | 0.00 | 2071.42 | 3626.10 |
| Lee, Austin,26151 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Morgan, Natalie,15149 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Zhao, Randy, J,27874 | 1288.31 | 0.00 | 0.00 | 1288.31 | 0.00 |
| Long, Megan, J,15791 | 42.26 | 0.00 | 0.00 | 24.99 | 17.27 |
| Lopez, Francisco, L,18714 | 24.27 | 0.00 | 0.00 | 21.98 | 2.29 |
| Rogers, Seth, R,14318 | 138.45 | 0.00 | 0.00 | 63.97 | 74.48 |
| He, Kelli, A,28872 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Zhang, Lacey, L,14127 | 3809.57 | 0.00 | 0.00 | 3809.57 | 0.00 |
| Ramos, Mary, B,15019 | 72.96 | 0.00 | 0.00 | 8.99 | 63.97 |
| Zheng, Jaclyn, F,11910 | 8113.03 | 0.00 | 3374.99 | 2319.99 | 2418.05 |
| Tang, Leonard, L,28109 | 778.62 | 0.00 | 0.00 | 778.62 | 0.00 |
| Sharma, Cedric, A,14060 | 99.47 | 0.00 | 0.00 | 49.99 | 49.48 |
| Romero, Paula, B,16691 | 4471.74 | 3578.27 | 0.00 | 893.47 | 0.00 |
| Kumar, Chad,11095 | 8158.01 | 0.00 | 3374.99 | 2363.96 | 2419.06 |
| Ruiz, Adrienne,13523 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Guo, Don,18742 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Jai, Dylan, J,23128 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rowe, Jacquelyn, I,13615 | 146.91 | 0.00 | 0.00 | 7.95 | 138.96 |
| Deng, Willie, J,27876 | 1214.85 | 0.00 | 0.00 | 0.00 | 1214.85 |
| Jai, Katrina,13044 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Hernandez, Javier, A,16156 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Powell, Jeremy,11048 | 6498.24 | 3374.99 | 0.00 | 0.00 | 3123.25 |
| Morgan, Mackenzie, E,16162 | 185.04 | 0.00 | 0.00 | 0.00 | 185.04 |
| Romero, Erika,19958 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Sun, Tamara, L,19976 | 44.04 | 0.00 | 0.00 | 0.00 | 44.04 |
| Fernandez, Jay,20155 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Jai, Derek, E,13613 | 105.22 | 0.00 | 0.00 | 27.28 | 77.94 |
| Chen, Claudia, R,16627 | 64.88 | 0.00 | 0.00 | 29.99 | 34.89 |
| Sai, Bryant, S,22577 | 2743.04 | 0.00 | 0.00 | 2181.56 | 561.48 |
| Cai, Karen,22572 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Davis, Morgan, J,27359 | 1344.47 | 0.00 | 0.00 | 782.99 | 561.48 |
| Sai, Abby, L,11101 | 8262.52 | 0.00 | 3399.99 | 2439.99 | 2422.54 |
| Carlson, Orlando, J,11893 | 8123.03 | 0.00 | 3374.99 | 2319.99 | 2428.05 |
| Chander, Clarence, E,13982 | 59.98 | 0.00 | 0.00 | 34.99 | 24.99 |
| Lu, Margaret, D,20814 | 4186.23 | 0.00 | 3578.27 | 607.96 | 0.00 |
| Patel, Rachael, G,13640 | 71.25 | 0.00 | 0.00 | 32.27 | 38.98 |
| Hu, Ramon,23439 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| Gonzalez, Donald,11079 | 32.96 | 0.00 | 0.00 | 9.99 | 22.97 |
| Garcia, Frederick, J,16489 | 112.73 | 0.00 | 0.00 | 88.46 | 24.27 |
| Zheng, Alan,11050 | 5007.30 | 3374.99 | 0.00 | 854.97 | 777.34 |
| Gomez, Ricky,18737 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Nara, Jon,22006 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Torres, Bailey,18259 | 30.97 | 0.00 | 0.00 | 8.99 | 21.98 |
| Turner, Savannah, E,23430 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perez, Marie,13996 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Sara, Adriana, M,15146 | 161.94 | 0.00 | 0.00 | 0.00 | 161.94 |
| Sanz, Renee, L,14319 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Deng, Priscilla, M,25127 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Sharma, Arturo,13648 | 6765.44 | 0.00 | 0.00 | 2049.10 | 4716.34 |
| Becker, Keith, P,27515 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Lopez, Brandy, S,18199 | 99.94 | 0.00 | 0.00 | 0.00 | 99.94 |
| Zhu, Sandra, V,15732 | 4376.40 | 0.00 | 0.00 | 2071.42 | 2304.98 |
| Lu, Warren, H,28925 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Deng, Michele,21946 | 4659.80 | 0.00 | 2181.56 | 0.00 | 2478.24 |
| Shen, Alison, A,16614 | 71.16 | 0.00 | 0.00 | 0.00 | 71.16 |
Generated 2025-11-03 01:43:03.280 UTC