[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 250 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Xu, Clarence,21877 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Xu, Barbara,29195 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| She, Cedric, R,12580 | 2589.09 | 0.00 | 2049.10 | 0.00 | 539.99 |
| Martinez, Manuel, J,15832 | 2611.41 | 0.00 | 0.00 | 2071.42 | 539.99 |
| Li, Stacey,14064 | 5694.21 | 0.00 | 0.00 | 2071.42 | 3622.79 |
| King, Evan,16637 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Nath, Michele, L,11056 | 8207.50 | 3374.99 | 0.00 | 2413.45 | 2419.06 |
| Kapoor, Kaitlin, M,17072 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Andersen, Kate,14237 | 90.25 | 0.00 | 0.00 | 0.00 | 90.25 |
| Raji, Tammy, K,17071 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Ma, Amy, E,17309 | 6030.61 | 3578.27 | 0.00 | 0.00 | 2452.34 |
| Chande, Dale, K,17242 | 4387.23 | 3578.27 | 0.00 | 0.00 | 808.96 |
| She, Willie,17055 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Chen, Cedric, R,17065 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Wu, Micah,17246 | 4380.04 | 3578.27 | 0.00 | 0.00 | 801.77 |
| Ferrier, Jaclyn, D,17299 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Moore, Michael,17247 | 4432.72 | 3578.27 | 0.00 | 0.00 | 854.45 |
| Patel, Janelle, T,29116 | 17.27 | 0.00 | 0.00 | 0.00 | 17.27 |
| Rana, Darren, M,17257 | 4480.73 | 0.00 | 3578.27 | 0.00 | 902.46 |
| Green, Fernando,17258 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Mr., Schmidt, Irving, W,12669 | 6791.10 | 0.00 | 2049.10 | 0.00 | 4742.00 |
| Goldstein, Dustin,12337 | 8137.01 | 0.00 | 3399.99 | 0.00 | 4737.02 |
| Rubio, Randall, M,17286 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Flores, Noah,17256 | 4362.74 | 0.00 | 3578.27 | 0.00 | 784.47 |
| Powell, Lucas, T,18278 | 158.95 | 0.00 | 0.00 | 0.00 | 158.95 |
| Allen, Alexandra, B,17293 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Mr., Shakespear, Paul, J.,17326 | 4467.76 | 0.00 | 3578.27 | 0.00 | 889.49 |
| Li, Karen, K,17921 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Sharma, Bonnie, R,25562 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Zhou, Cedric,17514 | 4142.23 | 0.00 | 3578.27 | 563.96 | 0.00 |
| Chander, Damien,11080 | 8204.02 | 0.00 | 3374.99 | 2359.98 | 2469.05 |
| Li, Aimee,17915 | 4792.73 | 0.00 | 3578.27 | 0.00 | 1214.46 |
| Tang, Bridget,17730 | 4752.23 | 0.00 | 3578.27 | 0.00 | 1173.96 |
| Nara, Dustin, M,17910 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Gill, Alberto, P,17733 | 4758.24 | 0.00 | 3578.27 | 0.00 | 1179.97 |
| Ye, Leah,11077 | 8169.03 | 0.00 | 3374.99 | 2374.98 | 2419.06 |
| Hernandez, Bruce,17919 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Goel, Drew,17352 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Martinez, Daniel, P,17725 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Martin, Renee, L,17478 | 4758.24 | 0.00 | 3578.27 | 0.00 | 1179.97 |
| Sai, Abby, L,11101 | 8262.52 | 0.00 | 3399.99 | 2439.99 | 2422.54 |
| Griffin, Caroline,17726 | 4721.73 | 0.00 | 3578.27 | 0.00 | 1143.46 |
| Townsend, Larry, D,11134 | 4911.83 | 0.00 | 3399.99 | 0.00 | 1511.84 |
| Jordan, Ross, F,11124 | 8129.02 | 0.00 | 3399.99 | 2309.97 | 2419.06 |
| Harris, Eduardo, S,18238 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Zheng, Dennis, E,25567 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Suarez, Carolyn, B,18222 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Chapman, Preston, O,18268 | 6102.19 | 0.00 | 3578.27 | 0.00 | 2523.92 |
| Liu, Jessie,11106 | 8079.05 | 0.00 | 3399.99 | 2294.99 | 2384.07 |
| Gutierrez, Meredith, T,11111 | 8137.00 | 0.00 | 3399.99 | 2318.96 | 2418.05 |
| Martinez, Bruce, D,18452 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Sun, Brittney,11365 | 5024.79 | 0.00 | 3374.99 | 0.00 | 1649.80 |
| Diaz, Aaron, C,18695 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Diaz, Ricky, E,18335 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Ye, Edwin,18334 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Kim, Kari, S,11445 | 8098.03 | 0.00 | 3399.99 | 2304.98 | 2393.06 |
| Taylor, Jennifer,18470 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Prasad, Jarrod,11359 | 4960.07 | 0.00 | 3374.99 | 0.00 | 1585.08 |
| Martinez, Tina, J,18461 | 4748.24 | 0.00 | 3578.27 | 0.00 | 1169.97 |
| Lal, Terry,18277 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| McDonald, Kaitlin,18493 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Patterson, Kyle,11448 | 8132.01 | 0.00 | 3374.99 | 2318.96 | 2438.06 |
Generated 2024-11-14 16:44:49.349 UTC