[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 625 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Yuan, Bradley,17920 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Rodriguez, Allen, L,17732 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Sharma, Bonnie, R,25562 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Raji, Bradley, E,17925 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Li, Lacey,17515 | 4143.26 | 0.00 | 3578.27 | 0.00 | 564.99 |
| Navarro, Latasha, L,11100 | 8172.51 | 0.00 | 3374.99 | 0.00 | 4797.52 |
| Hernandez, Bruce,17919 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Martinez, Daniel, P,17725 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Suri, Phillip,17914 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Malhotra, Cory, E,17923 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Saunders, Micheal,17513 | 4260.24 | 0.00 | 3578.27 | 681.97 | 0.00 |
| Raji, Willie, T,11070 | 8165.55 | 0.00 | 3399.99 | 2345.22 | 2420.34 |
| Jimenez, Felicia, L,11075 | 8068.03 | 0.00 | 3374.99 | 2294.99 | 2398.05 |
| Sun, Leah,17734 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| 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 |
| Yang, Curtis,11110 | 8093.03 | 0.00 | 3399.99 | 2294.99 | 2398.05 |
| Townsend, Larry, D,11134 | 4911.83 | 0.00 | 3399.99 | 0.00 | 1511.84 |
| Lal, Katie, E,18210 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Gomez, Alfredo, C,18200 | 4150.53 | 0.00 | 3578.27 | 0.00 | 572.26 |
| Rana, Ivan, K,18196 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Wu, Ernest, L,11147 | 8195.50 | 0.00 | 3374.99 | 0.00 | 4820.51 |
| Xu, Cedric,18198 | 4143.25 | 0.00 | 3578.27 | 0.00 | 564.98 |
| Martin, Larry,18254 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Smith, Arthur,18240 | 6098.58 | 0.00 | 3578.27 | 2520.31 | 0.00 |
| Moreno, Pedro, A,18248 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Sun, Alvin,18252 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Mehta, Tina, C,11444 | 8136.02 | 0.00 | 3374.99 | 2376.96 | 2384.07 |
| Torres, Kari,18486 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Serrano, Audrey,18337 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Kim, Kari, S,11445 | 8098.03 | 0.00 | 3399.99 | 2304.98 | 2393.06 |
| Nath, Tasha, J,18487 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Suarez, Daisy, A,18288 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| White, Olivia, E,18457 | 4826.23 | 0.00 | 3578.27 | 0.00 | 1247.96 |
| Zheng, Vincent,18496 | 6121.71 | 0.00 | 3578.27 | 2543.44 | 0.00 |
| Chen, Erica, P,18308 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Zhang, Amy,18307 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Prasad, Jarrod,11359 | 4960.07 | 0.00 | 3374.99 | 0.00 | 1585.08 |
| Gonzalez, Michele, D,18491 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Suri, Adriana,18463 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Nara, Johnny, R,18489 | 6081.10 | 0.00 | 3578.27 | 2502.83 | 0.00 |
| Patterson, Kyle,11448 | 8132.01 | 0.00 | 3374.99 | 2318.96 | 2438.06 |
| Serrano, Shannon, R,18303 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Lal, Kenneth, J,18701 | 5357.74 | 0.00 | 3578.27 | 1779.47 | 0.00 |
| Wu, Christy, D,25568 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Lopez, Savannah,25709 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Zhu, Clarence, A,18462 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Mehta, Preston, G,18692 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Suri, Toni,18464 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Xie, Wayne, S,18302 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Gill, Byron, J,18483 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Malhotra, Emmanuel,18332 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Chavez, Jodi, A,18909 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Liu, Glenn,18899 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Xie, Ricardo,18710 | 6098.58 | 0.00 | 3578.27 | 2520.31 | 0.00 |
| Andersen, Willie, M,27970 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Torres, Mathew, L,18900 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Madan, Toni,26668 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Chen, Willie, C,28322 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Brown, Cameron, D,13041 | 153.95 | 0.00 | 0.00 | 0.00 | 153.95 |
| Malhotra, Stanley, H,11453 | 8176.98 | 0.00 | 3374.99 | 2382.93 | 2419.06 |
| Ramos, Briana, J,14303 | 3636.91 | 0.00 | 0.00 | 2049.10 | 1587.81 |
| Lin, Laura, L,11462 | 8116.33 | 0.00 | 3374.99 | 2322.28 | 2419.06 |
| Gutierrez, Jaime, C,11457 | 8211.48 | 0.00 | 3374.99 | 2359.96 | 2476.53 |
| Dominguez, Theresa, L,18769 | 5304.25 | 0.00 | 3578.27 | 0.00 | 1725.98 |
| Chen, Steve, R,18902 | 4186.23 | 0.00 | 3578.27 | 607.96 | 0.00 |
| Serrano, Max, E,12010 | 8203.50 | 0.00 | 3374.99 | 0.00 | 4828.51 |
| Parker, Evan, R,18729 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| Chapman, Kathryn,11988 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Ma, Lacey, K,18723 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Suri, Roy, M,17253 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Sara, Tabitha, W,25715 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Liu, Autumn, J,20985 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Gao, Edwin,25716 | 1302.59 | 0.00 | 699.10 | 0.00 | 603.49 |
| Price, Megan,24907 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Navarro, Melinda,11454 | 8089.04 | 0.00 | 3374.99 | 2294.99 | 2419.06 |
| Diaz, Samuel,14065 | 5608.55 | 0.00 | 0.00 | 2071.42 | 3537.13 |
| Suri, Douglas,19096 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Martin, Randall, B,19560 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Prasad, Darren,12372 | 99.03 | 0.00 | 0.00 | 0.00 | 99.03 |
| Powell, Kaitlyn,19598 | 5310.53 | 0.00 | 3578.27 | 0.00 | 1732.26 |
| Gonzalez, Kristopher, C,19264 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Serrano, Orlando,19561 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Hill, Mackenzie,19576 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Jimenez, Jacquelyn,14304 | 3595.93 | 0.00 | 0.00 | 2049.10 | 1546.83 |
| Ortega, Gloria, R,19558 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Martinez, Terrance,25718 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Cai, Cedric,19559 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Jai, Alvin,19599 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Sharma, Alvin, M,19586 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Martinez, Meredith, M,19095 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Deng, Sheena,19099 | 6038.56 | 0.00 | 3578.27 | 0.00 | 2460.29 |
| Ma, Cedric, W,11094 | 157.93 | 0.00 | 0.00 | 0.00 | 157.93 |
| Gao, Krystal,25821 | 1879.07 | 0.00 | 699.10 | 0.00 | 1179.97 |
| She, Bridget, M,19557 | 5358.24 | 0.00 | 3578.27 | 0.00 | 1779.97 |
| Romero, Billy,20419 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Madan, Ronald,25828 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Ramirez, Isaiah,11905 | 8155.98 | 0.00 | 3374.99 | 0.00 | 4780.99 |
| Ashe, Orlando, I,11897 | 8203.02 | 0.00 | 3399.99 | 0.00 | 4803.03 |
| Ortega, Danny, K,19794 | 6098.58 | 0.00 | 3578.27 | 0.00 | 2520.31 |
| Carlson, Orlando, J,11893 | 8123.03 | 0.00 | 3374.99 | 2319.99 | 2428.05 |
| Young, Morgan, L,12342 | 6838.12 | 0.00 | 2049.10 | 0.00 | 4789.02 |
| Nath, Louis, C,25830 | 1833.57 | 0.00 | 699.10 | 0.00 | 1134.47 |
| Nara, Clayton,11768 | 8139.04 | 0.00 | 3399.99 | 2319.99 | 2419.06 |
| Perez, Brenda,11899 | 8189.50 | 0.00 | 3374.99 | 2395.45 | 2419.06 |
| Alonso, Gloria, S,19964 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Jai, Tasha, A,19771 | 4167.23 | 0.00 | 3578.27 | 588.96 | 0.00 |
| Patel, Janelle, T,29116 | 17.27 | 0.00 | 0.00 | 0.00 | 17.27 |
| Ramos, Jessie, R,11764 | 8129.02 | 0.00 | 3399.99 | 0.00 | 4729.03 |
| Patel, Kaitlin, L,16615 | 95.84 | 0.00 | 0.00 | 0.00 | 95.84 |
| Wu, Amy,19790 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Hu, Lacey,19948 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Goldstein, Dustin,12337 | 8137.01 | 0.00 | 3399.99 | 0.00 | 4737.02 |
| Henderson, Angela, T,11898 | 8179.03 | 0.00 | 3399.99 | 0.00 | 4779.04 |
| Cook, Kaylee,11904 | 8214.50 | 0.00 | 3399.99 | 0.00 | 4814.51 |
| Raman, Candace, M,11766 | 8280.48 | 0.00 | 3399.99 | 2419.46 | 2461.03 |
| Tang, Rafael, A,11908 | 8079.05 | 0.00 | 3374.99 | 2319.99 | 2384.07 |
| Gonzalez, Ivan, C,19625 | 52.77 | 0.00 | 0.00 | 0.00 | 52.77 |
| Lopez, Jay, A,19965 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Hu, Kristen, C,19788 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Vazquez, Andy,19620 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Gonzalez, Ann,11894 | 8223.00 | 0.00 | 3374.99 | 2394.97 | 2453.04 |
| Garcia, Sarah,11907 | 8135.33 | 0.00 | 3399.99 | 2297.28 | 2438.06 |
| Tang, Shawn,25832 | 1850.86 | 0.00 | 699.10 | 0.00 | 1151.76 |
| Blanco, Rodney, A,20158 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
Generated 2024-11-10 05:22:01.356 UTC