[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 500 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 4733.05 | 0.00 |
| Moore, Lucas, J,15021 | 38.98 | 0.00 | 0.00 | 29.99 | 8.99 |
| Zhao, Laura, T,24589 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| Diaz, Danny, C,18190 | 30.97 | 0.00 | 0.00 | 8.99 | 21.98 |
| Liu, Susan,18718 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Martinez, Ethan, C,20260 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Ramos, Sabrina, L,29082 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Deng, Priscilla, M,25127 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Cook, Kaylee,11904 | 8214.50 | 0.00 | 3399.99 | 0.00 | 4814.51 |
| Vazquez, Byron,11122 | 42.93 | 0.00 | 0.00 | 7.95 | 34.98 |
| Sun, Leah,17734 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Mehta, Erick, E,14123 | 61.58 | 0.00 | 0.00 | 0.00 | 61.58 |
| Sutton, Cassie, S,16613 | 129.35 | 0.00 | 0.00 | 0.00 | 129.35 |
| West, James, M,15148 | 90.75 | 0.00 | 0.00 | 0.00 | 90.75 |
| Patterson, Ashley, R,18736 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Nath, Dawn, L,11759 | 8054.05 | 0.00 | 3374.99 | 0.00 | 4679.06 |
| Raji, Katrina, M,16517 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Prasad, Darren,12372 | 99.03 | 0.00 | 0.00 | 0.00 | 99.03 |
| Gonzales, Victoria,11751 | 8215.02 | 0.00 | 3399.99 | 0.00 | 4815.03 |
| Parker, Gabriel,19606 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Malhotra, Arthur, E,25267 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Ye, Willie,22963 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Munoz, Teresa, R,27712 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Collins, Jennifer,11364 | 4921.82 | 0.00 | 3374.99 | 0.00 | 1546.83 |
| Ye, Gilbert,29344 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Zheng, Jenny, R,11947 | 4747.30 | 0.00 | 3374.99 | 629.96 | 742.35 |
| Lopez, Mason, E,22923 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Malhotra, Terrance, E,20223 | 187.38 | 0.00 | 0.00 | 0.00 | 187.38 |
| She, Jessie, A,13650 | 6768.14 | 0.00 | 0.00 | 2049.10 | 4719.04 |
| Anand, Chad,24484 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Hill, Luis,27500 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| She, Ricardo, A,14233 | 78.97 | 0.00 | 0.00 | 0.00 | 78.97 |
| Rai, Johnny, A,13135 | 6773.14 | 0.00 | 0.00 | 2049.10 | 4724.04 |
| Hernandez, Marvin, A,23077 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Luo, Colin, L,21210 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Chande, Carl,18932 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Hernandez, Darren, A,18709 | 6098.54 | 0.00 | 3578.27 | 0.00 | 2520.27 |
| Serrano, Dana, S,12678 | 341.43 | 0.00 | 0.00 | 0.00 | 341.43 |
| Suri, Evelyn, A,21223 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Goel, Alisha, C,26767 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| She, Nichole, M,11909 | 8105.31 | 0.00 | 3374.99 | 0.00 | 4730.32 |
| Rodriguez, Ruth, R,26179 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Kapoor, Denise, M,18725 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Zhou, Ernest, P,15792 | 2645.40 | 0.00 | 0.00 | 2071.42 | 573.98 |
| Hernandez, Tabitha, L,19603 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Sai, Harold,11026 | 6575.79 | 3399.99 | 0.00 | 0.00 | 3175.80 |
| Patterson, Jordan,17238 | 147.48 | 0.00 | 0.00 | 53.99 | 93.49 |
| Ashe, Kathryn,16168 | 80.11 | 0.00 | 0.00 | 34.89 | 45.22 |
| Cai, Jessie, A,12249 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Chavez, Jodi, A,18909 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Xie, Nina,12997 | 118.18 | 0.00 | 0.00 | 0.00 | 118.18 |
| Madan, Bruce, G,18206 | 65.96 | 0.00 | 0.00 | 0.00 | 65.96 |
| Miller, Dalton, D,13130 | 6797.15 | 0.00 | 0.00 | 2049.10 | 4748.05 |
| Rodriguez, Tammy,15233 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Moyer, Meghan,21220 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Huang, Omar, C,14232 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Torres, Naomi, J,14061 | 82.26 | 0.00 | 0.00 | 32.27 | 49.99 |
| Gonzalez, Ivan, C,19625 | 52.77 | 0.00 | 0.00 | 0.00 | 52.77 |
| Mehta, Patricia, K,29179 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Raje, Alison, J,12345 | 64.71 | 0.00 | 0.00 | 0.00 | 64.71 |
| Liang, Candice,22208 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Arun, Marie, E,22844 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Wang, Jaclyn, M,17063 | 100.25 | 0.00 | 0.00 | 37.27 | 62.98 |
| Moreno, Melody, R,11760 | 274.92 | 0.00 | 0.00 | 0.00 | 274.92 |
| Lopez, Virginia, J,27338 | 1339.92 | 0.00 | 0.00 | 782.99 | 556.93 |
| Ashe, Tara, J,19093 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Nara, Kelsey, A,24905 | 2195.91 | 0.00 | 0.00 | 1000.44 | 1195.47 |
| She, Tonya, L,16521 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Suarez, Renee, L,12703 | 6891.12 | 0.00 | 0.00 | 2049.10 | 4842.02 |
| Chander, Lindsay, R,19972 | 49.70 | 0.00 | 0.00 | 0.00 | 49.70 |
| Raman, Meagan, J,15134 | 5151.71 | 0.00 | 0.00 | 2071.42 | 3080.29 |
| Patel, Arthur, B,26671 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Schmidt, Shane,17922 | 4821.72 | 0.00 | 3578.27 | 0.00 | 1243.45 |
| Ms., Ryan, Justine, J.,23079 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Prasad, Harold,19608 | 68.45 | 0.00 | 0.00 | 0.00 | 68.45 |
| Deng, Deborah,23324 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Bryant, Lauren,11752 | 137.87 | 0.00 | 0.00 | 77.96 | 59.91 |
| Vazquez, Casey, S,13132 | 6880.62 | 0.00 | 0.00 | 2049.10 | 4831.52 |
| Liu, Jenny,16165 | 81.81 | 0.00 | 0.00 | 0.00 | 81.81 |
| King, Nathan,27719 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Mehta, Cindy, A,21943 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Shen, Brendan, L,14305 | 3652.20 | 0.00 | 0.00 | 2049.10 | 1603.10 |
| Xu, Tasha, E,11948 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| She, Jeffery, M,27149 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Jai, Calvin, S,22918 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Blanco, Krista, L,27580 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gutierrez, Philip, M,21979 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Dominguez, Neil, K,23663 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Subram, Arthur, E,27350 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Zhao, Kristen,16930 | 7.95 | 0.00 | 0.00 | 0.00 | 7.95 |
| Ma, Autumn,20994 | 4191.72 | 0.00 | 3578.27 | 0.00 | 613.45 |
| Sharma, Alvin, M,19586 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Xu, Rafael, A,21885 | 4641.85 | 0.00 | 2181.56 | 0.00 | 2460.29 |
| Alan, Jamie, S,21224 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Lopez, Patricia,28305 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| White, Taylor, D,25011 | 1589.40 | 0.00 | 0.00 | 1000.44 | 588.96 |
| Jiménez, Daisy,21944 | 4713.89 | 0.00 | 2181.56 | 0.00 | 2532.33 |
| Carlson, Marc, W,17501 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Madan, Johnathan, D,13626 | 6909.09 | 0.00 | 0.00 | 2049.10 | 4859.99 |
| Alexander, David,15783 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Rodriguez, Ebony,14517 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Raman, Jay, M,13618 | 6763.15 | 0.00 | 0.00 | 2049.10 | 4714.05 |
| Diaz, Frank, F,29086 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Ruiz, Marvin, R,18796 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Martin, Ebony, F,15223 | 4366.41 | 0.00 | 0.00 | 2071.42 | 2294.99 |
| Adams, Amber,26746 | 2001.45 | 0.00 | 0.00 | 782.99 | 1218.46 |
| Zheng, Dennis, E,25567 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Zhang, Clarence, M,13001 | 6799.43 | 0.00 | 0.00 | 2049.10 | 4750.33 |
| Goel, Nichole, A,17277 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Gao, Lisa, A,19753 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bailey, Sean, L,27710 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Shan, Gregory,20614 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Sun, Christy,25218 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Gonzalez, Clifford,24505 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| She, Tamara, M,14224 | 5621.22 | 0.00 | 0.00 | 2049.10 | 3572.12 |
| Rai, Tasha, L,24301 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Sanchez, Lydia, S,12579 | 2589.09 | 0.00 | 2049.10 | 0.00 | 539.99 |
| Jiménez, Alberto, C,15215 | 4468.56 | 0.00 | 0.00 | 2049.10 | 2419.46 |
| Lal, Deborah, T,21982 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Alonso, Brandi,17061 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Lal, Tommy,14516 | 78.98 | 0.00 | 0.00 | 24.99 | 53.99 |
| Ward, Katelyn,20258 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Lopez, Kristi,28137 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sara, Troy, R,22583 | 2821.51 | 0.00 | 0.00 | 2181.56 | 639.95 |
Generated 2024-11-10 02:51:14.723 UTC