[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 1125 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Deng, April,11117 | 8184.99 | 0.00 | 3399.99 | 2365.94 | 2419.06 |
| Carlson, Philip, P,11915 | 8143.00 | 0.00 | 3374.99 | 2369.96 | 2398.05 |
| Alonso, Kathleen,21196 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Ruiz, Marie, J,27498 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Chandra, Jermaine, A,14299 | 5108.76 | 0.00 | 0.00 | 2071.42 | 3037.34 |
| Rana, Molly,21554 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Suarez, Leslie, C,22955 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Kumar, Barbara, N,27499 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Alvarez, Tabitha,15028 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Zhu, Christy,11003 | 8139.29 | 3399.99 | 0.00 | 2318.96 | 2420.34 |
| Alvarez, Marc, B,18221 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Guo, Rosa, M,24474 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Guo, Don,18742 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 2294.99 | 2438.06 |
| Yang, Cedric,15038 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Jiménez, Byron,16026 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Rubio, Walter, R,25912 | 63.47 | 0.00 | 0.00 | 0.00 | 63.47 |
| Fernandez, Manuel, A,16514 | 4761.74 | 3578.27 | 0.00 | 1183.47 | 0.00 |
| Ruiz, Naomi,23649 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Price, Deb,24502 | 3623.32 | 0.00 | 0.00 | 2443.35 | 1179.97 |
| Nara, Edwin, R,11097 | 8099.03 | 0.00 | 3374.99 | 0.00 | 4724.04 |
| Liang, Kelvin, L,16616 | 5915.54 | 3578.27 | 0.00 | 0.00 | 2337.27 |
| Vazquez, Kristine, M,17736 | 4742.74 | 0.00 | 3578.27 | 0.00 | 1164.47 |
| Dominguez, Lee, R,24597 | 4009.50 | 0.00 | 0.00 | 2181.56 | 1827.94 |
| Gomez, Ricky,18737 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Fernandez, Brenda, L,16493 | 4197.25 | 3578.27 | 0.00 | 0.00 | 618.98 |
| Serrano, Joy, L,14069 | 173.94 | 0.00 | 0.00 | 0.00 | 173.94 |
| Lal, Gabriel,27473 | 1398.46 | 0.00 | 0.00 | 782.99 | 615.47 |
| Diaz, Jacquelyn, K,18747 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Huang, Eugene, L,11001 | 6383.88 | 3374.99 | 0.00 | 2419.93 | 588.96 |
| Goel, Lacey, N,18704 | 33.26 | 0.00 | 0.00 | 0.00 | 33.26 |
| Hernandez, Erika,16160 | 2644.07 | 0.00 | 0.00 | 2049.10 | 594.97 |
| Sai, Troy,16515 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Huang, Damien,16524 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 0.00 | 4720.33 |
| Torres, Monique,25235 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Zheng, Christy,17069 | 4426.74 | 3578.27 | 0.00 | 0.00 | 848.47 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 0.00 | 1179.97 |
| Arun, Gerald,25940 | 1277.56 | 0.00 | 699.10 | 0.00 | 578.46 |
| Luo, Jerry, M,24586 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Patel, Kaitlin, L,16615 | 95.84 | 0.00 | 0.00 | 0.00 | 95.84 |
| Gomez, Danny, V,16636 | 5932.74 | 3578.27 | 0.00 | 0.00 | 2354.47 |
| James, Evan, V,11119 | 85.22 | 0.00 | 0.00 | 35.23 | 49.99 |
| Sun, Dennis, K,24481 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Ramos, Albert, E,27716 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Alvarez, Janet, G,11006 | 8119.03 | 3399.99 | 0.00 | 2334.97 | 2384.07 |
| Sai, Barry,22907 | 4169.33 | 0.00 | 0.00 | 2443.35 | 1725.98 |
| Zhang, Kristen,27484 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Zhang, Brittney, W,19975 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Verhoff, Rob,11008 | 8106.31 | 3374.99 | 0.00 | 4731.32 | 0.00 |
| Gonzalez, Edgar, A,15648 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Martinez, Jay,24592 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Moreno, Leslie, C,11114 | 122.89 | 0.00 | 0.00 | 0.00 | 122.89 |
| Walker, Anthony, T,25250 | 1883.56 | 699.10 | 0.00 | 0.00 | 1184.46 |
| Yuan, Colin,11758 | 58.05 | 0.00 | 0.00 | 0.00 | 58.05 |
| Hu, Susan,25242 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Rodriguez, Jonathan, J,13046 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Jimenez, Jill,11028 | 6474.62 | 3374.99 | 0.00 | 0.00 | 3099.63 |
| Suarez, Hector, L,15034 | 103.45 | 0.00 | 0.00 | 0.00 | 103.45 |
| Rai, Tonya,25243 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Rodriguez, Joel, C,16488 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Raje, Devon,29289 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
Generated 2024-11-14 04:53:14.581 UTC