[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 1250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Anand, Ricardo,21383 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Oliver, Lee,29119 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Huang, Barbara,26442 | 1919.75 | 0.00 | 0.00 | 782.99 | 1136.76 |
| Zhang, Ramon, D,12352 | 274.24 | 0.00 | 0.00 | 0.00 | 274.24 |
| Fernandez, Ivan,22032 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Wang, Alan,13622 | 6841.43 | 0.00 | 0.00 | 2071.42 | 4770.01 |
| Sara, Carmen, W,12582 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Guo, Ernest,25717 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Madan, Ann,21948 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Madan, Francisco, S,25706 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Cox, Isaac,15797 | 4415.68 | 0.00 | 0.00 | 2071.42 | 2344.26 |
| Suri, Cassandra, B,18717 | 87.21 | 0.00 | 0.00 | 0.00 | 87.21 |
| Zhang, Susan, S,18216 | 38.92 | 0.00 | 0.00 | 8.99 | 29.93 |
| Serrano, Marvin, E,17316 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| Rodriguez, Frederick, S,24458 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Wang, Autumn,13049 | 5647.22 | 0.00 | 0.00 | 2071.42 | 3575.80 |
| Anand, Carly,25918 | 1260.58 | 0.00 | 699.10 | 0.00 | 561.48 |
| Gomez, Kathleen, J,16158 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Nath, Jaime,11033 | 6495.29 | 3374.99 | 0.00 | 0.00 | 3120.30 |
| Hayes, Alexis,13048 | 190.23 | 0.00 | 0.00 | 0.00 | 190.23 |
| Zeng, Dennis, S,13050 | 5651.25 | 0.00 | 0.00 | 2071.42 | 3579.83 |
| Suarez, Erika,15120 | 5217.70 | 0.00 | 0.00 | 2049.10 | 3168.60 |
| Sanchez, Ross,28310 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Tang, Willie, A,25939 | 1264.57 | 0.00 | 699.10 | 0.00 | 565.47 |
| Sanz, Jésus,29313 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Liang, Steve,14317 | 81.26 | 0.00 | 0.00 | 49.99 | 31.27 |
| Sharma, Julie, R,18191 | 94.47 | 0.00 | 0.00 | 8.99 | 85.48 |
| Reed, Steven,24373 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Dominguez, Theodore, F,21987 | 4638.89 | 0.00 | 0.00 | 2181.56 | 2457.33 |
| Powell, Elizabeth, K,28306 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sutton, Kern, A,26660 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Romero, Gary,22181 | 4673.88 | 0.00 | 0.00 | 2181.56 | 2492.32 |
| Sanz, Diane, M,20153 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Pal, Mohamed, D,12698 | 6786.75 | 0.00 | 2071.42 | 0.00 | 4715.33 |
| Kelly, Emma, A,15646 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Navarro, Teresa, E,25816 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rana, Whitney, A,13006 | 6762.15 | 0.00 | 0.00 | 2049.10 | 4713.05 |
| Rivera, Mariah,20261 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Vance, Ruth, D,17302 | 147.44 | 0.00 | 0.00 | 58.98 | 88.46 |
| Sanchez, Bryant, C,13113 | 6832.41 | 0.00 | 0.00 | 2071.42 | 4760.99 |
| Bryant, Madison, J,16481 | 194.91 | 0.00 | 0.00 | 0.00 | 194.91 |
| Ramirez, Cole, E,13616 | 6872.06 | 0.00 | 0.00 | 2049.10 | 4822.96 |
| King, Hailey, A,28214 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Alvarez, Albert, R,16624 | 5938.25 | 3578.27 | 0.00 | 0.00 | 2359.98 |
| Johnsen, Willie,15218 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Xu, Martha, C,16351 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Andersen, Maurice,15206 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Gutierrez, Jonathon, R,16529 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Lopez, Cesar,17500 | 156.96 | 0.00 | 0.00 | 0.00 | 156.96 |
| Zheng, Rosa, G,16629 | 5933.26 | 3578.27 | 0.00 | 0.00 | 2354.99 |
| Ward, Brooke,13007 | 5671.24 | 0.00 | 0.00 | 2071.42 | 3599.82 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Zhu, Christy,11003 | 8139.29 | 3399.99 | 0.00 | 2318.96 | 2420.34 |
| Zhang, Warren, L,25252 | 1893.05 | 699.10 | 0.00 | 0.00 | 1193.95 |
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 2294.99 | 2438.06 |
| Ramos, Monique,16495 | 6002.23 | 3578.27 | 0.00 | 0.00 | 2423.96 |
| Fernandez, Manuel, A,16514 | 4761.74 | 3578.27 | 0.00 | 1183.47 | 0.00 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Liang, Kelvin, L,16616 | 5915.54 | 3578.27 | 0.00 | 0.00 | 2337.27 |
| Chander, Yolanda,16519 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Fernandez, Brenda, L,16493 | 4197.25 | 3578.27 | 0.00 | 0.00 | 618.98 |
| Garcia, Dominique,16528 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Holt, Krystal,16518 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Sai, Levi,16349 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Huang, Eugene, L,11001 | 6383.88 | 3374.99 | 0.00 | 2419.93 | 588.96 |
| Raman, Shane,16661 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Huang, Damien,16524 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Diaz, Gloria,25270 | 1854.58 | 699.10 | 0.00 | 0.00 | 1155.48 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Sharma, Sharon, T,25294 | 1882.57 | 699.10 | 0.00 | 0.00 | 1183.47 |
| Gomez, Danny, V,16636 | 5932.74 | 3578.27 | 0.00 | 0.00 | 2354.47 |
| Lu, Suzanne, K,16712 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Sai, Harold,11026 | 6575.79 | 3399.99 | 0.00 | 0.00 | 3175.80 |
| Dominguez, Wendy,11035 | 6451.31 | 3374.99 | 0.00 | 0.00 | 3076.32 |
| Alvarez, Janet, G,11006 | 8119.03 | 3399.99 | 0.00 | 2334.97 | 2384.07 |
| Yuan, Christine,11046 | 6616.81 | 3374.99 | 0.00 | 0.00 | 3241.82 |
| Verhoff, Rob,11008 | 8106.31 | 3374.99 | 0.00 | 4731.32 | 0.00 |
| Perez, Joel,16684 | 4158.24 | 3578.27 | 0.00 | 0.00 | 579.97 |
| Jimenez, Jill,11028 | 6474.62 | 3374.99 | 0.00 | 0.00 | 3099.63 |
| Sanchez, Denise,16703 | 6090.59 | 3578.27 | 0.00 | 2512.32 | 0.00 |
| Ramos, Theresa, G,11031 | 6478.60 | 3399.99 | 0.00 | 0.00 | 3078.61 |
| Powell, Jeremy,11048 | 6498.24 | 3374.99 | 0.00 | 0.00 | 3123.25 |
| Jones, Emily,16659 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Ye, Dennis, M,16638 | 5974.23 | 3578.27 | 0.00 | 0.00 | 2395.96 |
| Romero, Lawrence, C,16687 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Stewart, Bryan, M,16928 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Lu, Jaclyn, D,11047 | 6582.33 | 3399.99 | 0.00 | 0.00 | 3182.34 |
| Sai, Preston, D,17046 | 4467.74 | 3578.27 | 0.00 | 0.00 | 889.47 |
| Zeng, Claudia, M,16696 | 4506.76 | 3578.27 | 0.00 | 928.49 | 0.00 |
| Xu, Edwin, J,25272 | 1873.58 | 699.10 | 0.00 | 0.00 | 1174.48 |
| Yuan, Bethany, G,11030 | 6471.32 | 3399.99 | 0.00 | 0.00 | 3071.33 |
| Gomez, Tabitha, L,16688 | 6081.10 | 3578.27 | 0.00 | 2502.83 | 0.00 |
| She, Alvin, E,16657 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Zhang, Ronnie,16656 | 5930.23 | 3578.27 | 0.00 | 0.00 | 2351.96 |
| Nelson, Sophia,16664 | 4377.75 | 3578.27 | 0.00 | 799.48 | 0.00 |
| Flores, Adam, L,11044 | 6515.30 | 3374.99 | 0.00 | 0.00 | 3140.31 |
| Blanco, Lee, M,16660 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Wilson, Zachary,25558 | 1307.06 | 699.10 | 0.00 | 0.00 | 607.96 |
| Lu, Trisha,25555 | 1277.56 | 699.10 | 0.00 | 0.00 | 578.46 |
| Zheng, Christy,17069 | 4426.74 | 3578.27 | 0.00 | 0.00 | 848.47 |
| Lopez, Heidi,11052 | 8131.32 | 3374.99 | 0.00 | 2337.27 | 2419.06 |
| Sanz, Victor,17295 | 4392.74 | 3578.27 | 0.00 | 0.00 | 814.47 |
| Gutierrez, Natasha,17048 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Nath, Carly, J,17255 | 4442.24 | 0.00 | 3578.27 | 0.00 | 863.97 |
| Coleman, Ethan, G,16693 | 6060.50 | 3578.27 | 0.00 | 2482.23 | 0.00 |
| Rai, Tracy, K,17079 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Andersen, Carl, J,11057 | 8088.04 | 3374.99 | 0.00 | 2319.99 | 2393.06 |
| Price, Isabella, L,17278 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Pal, Mitchell, R,16742 | 6044.59 | 3578.27 | 0.00 | 2466.32 | 0.00 |
| Alvarez, Tanya,17279 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Nara, Tony, L,16713 | 6090.59 | 3578.27 | 0.00 | 2512.32 | 0.00 |
| Navarro, Tyrone, K,25557 | 1262.87 | 0.00 | 699.10 | 0.00 | 563.77 |
| Lu, Krystal,17049 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| 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 |
| Yuan, Louis, C,18193 | 4145.54 | 0.00 | 3578.27 | 0.00 | 567.27 |
| Wang, Alejandro,17310 | 6029.57 | 3578.27 | 0.00 | 0.00 | 2451.30 |
| Navarro, Bruce, D,17353 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Arun, Ruth, S,17294 | 4355.71 | 3578.27 | 0.00 | 0.00 | 777.44 |
| Raje, Cristina, S,17917 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Gray, Stephanie,17064 | 4506.76 | 3578.27 | 0.00 | 0.00 | 928.49 |
| Suri, Cesar,17512 | 4170.54 | 0.00 | 3578.27 | 592.27 | 0.00 |
| Wilson, Jasmine,17329 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Xu, Tracy, L,17916 | 4787.74 | 0.00 | 3578.27 | 0.00 | 1209.47 |
| Martin, Joan, R,25556 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
Generated 2024-11-14 04:39:09.566 UTC