[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| West, Colleen, C,13128 | 6817.14 | 0.00 | 0.00 | 2049.10 | 4768.04 |
| Watson, Maria,17229 | 4471.74 | 3578.27 | 0.00 | 0.00 | 893.47 |
| Wang, Shannon,11017 | 6434.31 | 3374.99 | 0.00 | 2316.97 | 742.35 |
| Gao, Tiffany, E,16352 | 5948.49 | 3578.27 | 0.00 | 0.00 | 2370.22 |
| Suarez, Jacquelyn, C,11010 | 8088.04 | 3399.99 | 0.00 | 2294.99 | 2393.06 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 0.00 | 1179.97 |
| Raman, Roy,16348 | 5918.24 | 3578.27 | 0.00 | 0.00 | 2339.97 |
| Madan, Toni,26668 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Zhang, Warren, L,25252 | 1893.05 | 699.10 | 0.00 | 0.00 | 1193.95 |
| Chen, Willie, C,28322 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Lin, Kelvin, A,13075 | 6843.94 | 0.00 | 0.00 | 2071.42 | 4772.52 |
| Sanders, Arianna, E,22859 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rodriguez, Monica, J,28951 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Madan, Henry, E,17283 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 0.00 | 3165.30 |
| Ramos, Francis,16345 | 4173.24 | 3578.27 | 0.00 | 0.00 | 594.97 |
| Shen, Priscilla, A,28215 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Beck, Donna, J,18247 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Mehta, Erick, E,14123 | 61.58 | 0.00 | 0.00 | 0.00 | 61.58 |
| Roberts, Jordan,23432 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Johnson, Elizabeth,11004 | 8196.01 | 3399.99 | 0.00 | 2376.96 | 2419.06 |
| Sanchez, George, M,12680 | 6880.10 | 0.00 | 2049.10 | 0.00 | 4831.00 |
| Tang, Dawn, R,16496 | 5960.23 | 3578.27 | 0.00 | 0.00 | 2381.96 |
| Wu, Clarence, L,13115 | 6779.42 | 0.00 | 0.00 | 2049.10 | 4730.32 |
| Alvarez, Janet, G,11006 | 8119.03 | 3399.99 | 0.00 | 2334.97 | 2384.07 |
| Madan, Summer, D,12347 | 6839.12 | 0.00 | 2049.10 | 0.00 | 4790.02 |
| Diaz, Briana,13131 | 6737.15 | 0.00 | 0.00 | 2049.10 | 4688.05 |
| Sai, Levi,16349 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Zeng, Barbara,23102 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Kumar, Misty, H,25010 | 1540.43 | 0.00 | 0.00 | 1000.44 | 539.99 |
| Xu, Karl,23321 | 3060.82 | 0.00 | 0.00 | 2443.35 | 617.47 |
| Ms., Rusek, Pearlie, J.,21945 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Diaz, Ruben, A,25136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Shen, Shaun,12684 | 6893.08 | 0.00 | 2049.10 | 0.00 | 4843.98 |
| Xu, Alan,16741 | 6056.61 | 3578.27 | 0.00 | 0.00 | 2478.34 |
| Gonzalez, Ebony,11034 | 6491.32 | 3399.99 | 0.00 | 0.00 | 3091.33 |
| Rubio, Kendra,17047 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Serrano, Julio,20992 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Sharma, Sharon, T,25294 | 1882.57 | 699.10 | 0.00 | 0.00 | 1183.47 |
| Anand, Kelli, A,20451 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Lu, Suzanne, K,16712 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Diaz, Samuel,14065 | 5608.55 | 0.00 | 0.00 | 2071.42 | 3537.13 |
| Clark, Sydney,16610 | 67.58 | 0.00 | 0.00 | 32.60 | 34.98 |
| Guo, Randy, L,22956 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Rai, Alejandro, R,21990 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Yuan, Christine,11046 | 6616.81 | 3374.99 | 0.00 | 0.00 | 3241.82 |
| Dominguez, Robin,16685 | 4183.23 | 3578.27 | 0.00 | 0.00 | 604.96 |
| Ward, Brooke,13007 | 5671.24 | 0.00 | 0.00 | 2071.42 | 3599.82 |
| She, Alvin, E,16657 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Sanchez, Denise,16703 | 6090.59 | 3578.27 | 0.00 | 2512.32 | 0.00 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| Powell, Jeremy,11048 | 6498.24 | 3374.99 | 0.00 | 0.00 | 3123.25 |
| Nelson, Sophia,16664 | 4377.75 | 3578.27 | 0.00 | 799.48 | 0.00 |
| Hall, Jesse,26133 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Hernandez, Max,18192 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Coleman, Melanie, H,15639 | 34.57 | 0.00 | 0.00 | 0.00 | 34.57 |
| Jimenez, Latasha, E,13121 | 121.25 | 0.00 | 0.00 | 0.00 | 121.25 |
| Scott, Savannah, E,16929 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Lu, Trisha,25555 | 1277.56 | 699.10 | 0.00 | 0.00 | 578.46 |
| Rubio, Jay,15179 | 4444.89 | 0.00 | 0.00 | 2071.42 | 2373.47 |
| Stone, Denise,11032 | 6525.56 | 3374.99 | 0.00 | 0.00 | 3150.57 |
| She, Cedric, R,12580 | 2589.09 | 0.00 | 2049.10 | 0.00 | 539.99 |
| Cai, Cedric,19559 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Zheng, Alan,11050 | 5007.30 | 3374.99 | 0.00 | 854.97 | 777.34 |
| Martinez, Manuel, J,15832 | 2611.41 | 0.00 | 0.00 | 2071.42 | 539.99 |
| Evans, Carlos, J,23538 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Gonzalez, Edgar, A,15648 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Price, Deb,24502 | 3623.32 | 0.00 | 0.00 | 2443.35 | 1179.97 |
| Suri, Lydia,13126 | 6815.08 | 0.00 | 0.00 | 2049.10 | 4765.98 |
| Gomez, Tabitha, L,16688 | 6081.10 | 3578.27 | 0.00 | 2502.83 | 0.00 |
| Ramos, Cindy, G,11361 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Torres, Diane, M,25211 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Subram, Tabitha, C,17511 | 4150.53 | 0.00 | 3578.27 | 572.26 | 0.00 |
| Cox, Michelle, E,17328 | 4387.74 | 3578.27 | 0.00 | 0.00 | 809.47 |
| Lopez, Heidi,11052 | 8131.32 | 3374.99 | 0.00 | 2337.27 | 2419.06 |
| Ma, Amy, E,17309 | 6030.61 | 3578.27 | 0.00 | 0.00 | 2452.34 |
| Gonzalez, Phillip, N,18207 | 6089.59 | 0.00 | 3578.27 | 2511.32 | 0.00 |
| Romero, Rodney,14521 | 117.96 | 0.00 | 0.00 | 0.00 | 117.96 |
| Malhotra, Stanley, H,11453 | 8176.98 | 0.00 | 3374.99 | 2382.93 | 2419.06 |
| Ferrier, Linda, D,13149 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Chen, Steve, R,18902 | 4186.23 | 0.00 | 3578.27 | 607.96 | 0.00 |
| Torres, Meghan, I,21256 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
| Pal, Christine, I,18242 | 6121.71 | 0.00 | 3578.27 | 2543.44 | 0.00 |
| Schmidt, Pamela, I,24375 | 31.73 | 0.00 | 0.00 | 0.00 | 31.73 |
| Harris, Eduardo, S,18238 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Goel, Carl, S,17249 | 4426.74 | 3578.27 | 0.00 | 0.00 | 848.47 |
| Jordan, Ross, F,11124 | 8129.02 | 0.00 | 3399.99 | 2309.97 | 2419.06 |
| Rai, Brendan, A,21569 | 4960.16 | 0.00 | 0.00 | 2443.35 | 2516.81 |
| Perez, Toni,15581 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| Yuan, Darrell,18271 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Raman, Cassandra,28718 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Zhou, Jon, L,11060 | 8153.02 | 0.00 | 3399.99 | 2319.99 | 2433.04 |
| Suarez, Leslie, C,22955 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Vazquez, Craig,28117 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Xu, Cristina,25017 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Lopez, Luis, P,17334 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Shan, Deborah,20624 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Martin, Joan, R,25556 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Johnston, Joanna, L,17296 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Raman, Michele,17233 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Raman, Johnathan,19103 | 63.91 | 0.00 | 0.00 | 41.93 | 21.98 |
| Martin, Ethan, M,13998 | 245.25 | 0.00 | 0.00 | 97.97 | 147.28 |
| Suri, Mayra, M,15729 | 4393.70 | 0.00 | 0.00 | 2071.42 | 2322.28 |
| Morris, Eduardo,19619 | 112.75 | 0.00 | 0.00 | 88.97 | 23.78 |
| Serrano, Randall,27973 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Alvarez, Tanya,17279 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Gutierrez, Pedro, S,15224 | 71.92 | 0.00 | 0.00 | 0.00 | 71.92 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| Ramos, Jaime,15720 | 70.22 | 0.00 | 0.00 | 35.23 | 34.99 |
| Malhotra, Geoffrey, W,18298 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Subram, Kari,12682 | 227.96 | 0.00 | 0.00 | 0.00 | 227.96 |
| Ortega, Lawrence,14685 | 146.74 | 0.00 | 0.00 | 0.00 | 146.74 |
| Hill, Kaylee, L,11918 | 8204.99 | 0.00 | 3399.99 | 0.00 | 4805.00 |
| Prasad, Dominic, D,19962 | 46.75 | 0.00 | 0.00 | 0.00 | 46.75 |
| Sai, Ross, A,21966 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Allen, Alexandra, B,17293 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Hernandez, Armando,21950 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Luo, Casey,11072 | 8194.00 | 0.00 | 3399.99 | 2395.96 | 2398.05 |
| Raman, Deanna, H,17053 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Li, Karen, K,17921 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Ruiz, Adrienne,13523 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Andersen, Jenny,20259 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Hu, Barbara,19567 | 104.96 | 0.00 | 0.00 | 0.00 | 104.96 |
| Yuan, Bradley,17920 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
Generated 2024-11-12 22:36:46.530 UTC