[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 500 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Lal, Karl, R,14264 | 5217.73 | 0.00 | 0.00 | 2822.76 | 2394.97 |
| Harris, Eduardo, S,18238 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Jordan, Ross, F,11124 | 8129.02 | 0.00 | 3399.99 | 2309.97 | 2419.06 |
| She, Kristin, L,19961 | 97.97 | 0.00 | 0.00 | 0.00 | 97.97 |
| Nelson, Julia, L,11102 | 102.91 | 0.00 | 0.00 | 0.00 | 102.91 |
| Martin, Adrienne,19952 | 39.46 | 0.00 | 0.00 | 25.48 | 13.98 |
| Raman, Shane,16661 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| King, Evan,16637 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Rana, Pedro, F,13970 | 6843.14 | 0.00 | 0.00 | 2049.10 | 4794.04 |
| Kumar, Jaime, O,29061 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Ye, Leah,11077 | 8169.03 | 0.00 | 3374.99 | 2374.98 | 2419.06 |
| Mehta, Brett,11450 | 8173.26 | 0.00 | 3374.99 | 2370.22 | 2428.05 |
| Navarro, Carolyn,11069 | 8104.05 | 0.00 | 3399.99 | 2319.99 | 2384.07 |
| Andersen, Carl, J,11057 | 8088.04 | 3374.99 | 0.00 | 2319.99 | 2393.06 |
| Muñoz, Ruben, L,11451 | 8249.49 | 0.00 | 3399.99 | 2366.94 | 2482.56 |
| Lin, Wesley,21407 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Sanz, Arthur,27688 | 166.28 | 0.00 | 0.00 | 166.28 | 0.00 |
| Butler, Austin, W,18293 | 74.24 | 0.00 | 0.00 | 74.24 | 0.00 |
| Wright, Miguel,25811 | 86.45 | 0.00 | 0.00 | 86.45 | 0.00 |
| Malhotra, Ross, R,29307 | 14.98 | 0.00 | 0.00 | 14.98 | 0.00 |
| Black, Priscilla,15766 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Rowe, Jacquelyn, I,13615 | 146.91 | 0.00 | 0.00 | 7.95 | 138.96 |
| Sun, Rafael,26749 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Wu, Mandy,18309 | 6090.59 | 0.00 | 3578.27 | 2512.32 | 0.00 |
| Gomez, Danny, V,16636 | 5932.74 | 3578.27 | 0.00 | 0.00 | 2354.47 |
| Carson, Kelvin, A,11995 | 8249.01 | 0.00 | 3399.99 | 0.00 | 4849.02 |
| Carlson, Ebony,13959 | 6858.42 | 0.00 | 0.00 | 2049.10 | 4809.32 |
| Navarro, Monique, R,15240 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Dominguez, Lee, R,24597 | 4009.50 | 0.00 | 0.00 | 2181.56 | 1827.94 |
| Lu, Alan,19761 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Hall, Jeremiah, M,18250 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Lin, Suzanne,29287 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Zhou, Rafael, A,24494 | 9.99 | 0.00 | 0.00 | 9.99 | 0.00 |
| Kumar, Rafael, L,19088 | 24.27 | 0.00 | 0.00 | 2.29 | 21.98 |
| Griffin, Blake, S,18699 | 5308.24 | 0.00 | 3578.27 | 1729.97 | 0.00 |
| Wang, Laura, L,26146 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Andersen, Nina,18338 | 6124.58 | 0.00 | 3578.27 | 0.00 | 2546.31 |
| Munoz, Meredith,13957 | 5645.24 | 0.00 | 0.00 | 2071.42 | 3573.82 |
| Deng, Kenneth,20235 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Mr., Schulte, Scot,15807 | 70.57 | 0.00 | 0.00 | 0.00 | 70.57 |
| Beck, Alisha, E,11463 | 47.92 | 0.00 | 0.00 | 7.95 | 39.97 |
| Lin, Autumn, E,18272 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Kapoor, Patricia, R,21883 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Cox, Nicole, V,22950 | 3917.54 | 0.00 | 0.00 | 3917.54 | 0.00 |
| Serrano, Stacy,24613 | 2148.21 | 0.00 | 1000.44 | 1147.77 | 0.00 |
| Srini, Veronica,11996 | 7058.70 | 0.00 | 3374.99 | 1291.77 | 2391.94 |
| Zhao, Ernest, C,18700 | 5328.23 | 0.00 | 3578.27 | 1749.96 | 0.00 |
| Nath, Michele, L,11056 | 8207.50 | 3374.99 | 0.00 | 2413.45 | 2419.06 |
| Bradley, Diane, A,15140 | 62.27 | 0.00 | 0.00 | 27.28 | 34.99 |
| Huang, Lacey, J,11951 | 63.52 | 0.00 | 0.00 | 0.00 | 63.52 |
| Beck, Bonnie, A,29097 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Subram, Raymond,23994 | 2790.52 | 0.00 | 0.00 | 2181.56 | 608.96 |
| Suarez, Lance, C,17230 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Tang, Grant, H,11466 | 90.19 | 0.00 | 0.00 | 0.00 | 90.19 |
| Andersen, Brendan,15121 | 5202.73 | 0.00 | 0.00 | 2071.42 | 3131.31 |
| He, Ramon,26919 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Sun, Suzanne, P,24587 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Raje, Ashlee, E,16658 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Romero, Wendy, H,11372 | 4965.81 | 0.00 | 3374.99 | 0.00 | 1590.82 |
| Sanz, Sabrina, A,19650 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Rai, Shaun,26431 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Chander, Omar, W,17241 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
Generated 2024-11-10 05:38:52.743 UTC