[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 43 > < TAKE 112 >
112 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martin, Roy,22065 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sai, Ruth, D,24461 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Vazquez, Diane, D,11987 | 279.23 | 0.00 | 0.00 | 0.00 | 279.23 |
| Nath, Melvin, D,27697 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Kapoor, Cesar, J,24302 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Jiménez, Deanna,28115 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Sharma, Raul, E,16347 | 5918.50 | 3578.27 | 0.00 | 0.00 | 2340.23 |
| Richardson, Katelyn,18930 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Hernandez, Philip,21193 | 3905.52 | 0.00 | 2181.56 | 0.00 | 1723.96 |
| Moreno, Kristi,23415 | 3588.83 | 0.00 | 0.00 | 2443.35 | 1145.48 |
| Sharma, Misty,25708 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Sanz, Nelson, M,14056 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Huang, Randy,24007 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Tang, Ashlee, D,11369 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Lin, Alan,22973 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Mehta, Preston, G,18692 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Sullivan, Ruth,27723 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Vazquez, Francis, E,17281 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Sanchez, Francisco, D,21172 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Williams, Madison, J,21198 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Ortega, Lawrence,14685 | 146.74 | 0.00 | 0.00 | 0.00 | 146.74 |
| Sanchez, Olivia, J,14278 | 177.46 | 0.00 | 0.00 | 0.00 | 177.46 |
| Ramos, Rebekah, L,27984 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Harris, Thomas,24002 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Raman, Shane,16661 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Diaz, Ruben, A,25136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhou, Ernest, P,15792 | 2645.40 | 0.00 | 0.00 | 2071.42 | 573.98 |
| Garcia, Darren,28716 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Gao, Jorge,23573 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Ortega, Renee,18447 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Diaz, Ricky, E,18335 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Diaz, Aaron, C,18695 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Chandra, Ann,18209 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Jai, Gregory,16342 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Yuan, Tamara, E,21166 | 4909.67 | 0.00 | 2443.35 | 0.00 | 2466.32 |
| Butler, Elijah, D,21551 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Gutierrez, Armando,29310 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Powell, Adam,23423 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Adams, Amber,26746 | 2001.45 | 0.00 | 0.00 | 782.99 | 1218.46 |
| Coleman, Ethan, G,16693 | 6060.50 | 0.00 | 3578.27 | 2482.23 | 0.00 |
| Zheng, Arturo, C,11467 | 47.92 | 0.00 | 0.00 | 0.00 | 47.92 |
| Zhao, Marshall, C,22033 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Hernandez, Jessie, A,24172 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Lopez, Pamela, E,26444 | 1938.71 | 0.00 | 0.00 | 782.99 | 1155.72 |
| Martinez, Monica, A,14129 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Lin, Mandy, C,25035 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Yang, Hunter, E,20237 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Sun, Clayton,28533 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Sanders, Devin, J,12014 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Ma, Cedric, W,11094 | 157.93 | 0.00 | 0.00 | 0.00 | 157.93 |
| Wang, Rosa, I,11993 | 8131.32 | 0.00 | 3374.99 | 0.00 | 4756.33 |
| Raman, Virginia,26159 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ruiz, Bruce, W,16171 | 103.86 | 0.00 | 0.00 | 0.00 | 103.86 |
| Goel, Dawn,23535 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanz, Kari, V,27341 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Liu, Trisha, V,20214 | 5304.25 | 0.00 | 3578.27 | 0.00 | 1725.98 |
| Kumar, Tasha, M,20249 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Liu, Clarence,19797 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zhu, Tiffany,26437 | 1953.47 | 0.00 | 0.00 | 782.99 | 1170.48 |
| She, Colin, M,15139 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Raje, Johnny,13975 | 5138.72 | 0.00 | 0.00 | 2049.10 | 3089.62 |
| Ms., Robinson, Rebecca, A.,11913 | 41.26 | 0.00 | 0.00 | 0.00 | 41.26 |
| Arthur, Johnathan,18730 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Morris, Megan,23641 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Luo, Dustin,17240 | 4385.03 | 0.00 | 3578.27 | 0.00 | 806.76 |
| Rana, Marco, K,24473 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Hernandez, Orlando, C,21951 | 4923.29 | 0.00 | 0.00 | 2443.35 | 2479.94 |
| Liang, Barbara, T,22953 | 3899.49 | 0.00 | 0.00 | 2181.56 | 1717.93 |
| Sai, Frederick,20991 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Madan, Kristi, I,29184 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Gray, Stephanie,17064 | 4506.76 | 0.00 | 3578.27 | 0.00 | 928.49 |
| Kumar, Kurt, L,27360 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Goel, Bethany,27511 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Gutierrez, Francis,25245 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Alonso, Meghan, A,24457 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Munoz, Jimmy, E,21573 | 61.97 | 0.00 | 0.00 | 0.00 | 61.97 |
| Jimenez, Felicia, L,11075 | 8068.03 | 0.00 | 3374.99 | 2294.99 | 2398.05 |
| Smith, Adriana,18702 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Blanco, Victor,15586 | 4469.37 | 0.00 | 0.00 | 2071.42 | 2397.95 |
| Browning, Janet,19979 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Bell, Isabella,27698 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Ashe, Orlando, I,11897 | 8203.02 | 0.00 | 3399.99 | 0.00 | 4803.03 |
| Zimmerman, Candice, J,26754 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Tang, Leonard, L,28109 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Chander, Julie, E,18763 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Wang, Jon, A,26191 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| She, Rosa,18931 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Young, Marcus, A,18494 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Gonzales, Lucas,29463 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Hu, Kristen, C,19788 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Davis, Ryan, C,27870 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Dominguez, Kellie, E,17244 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Raji, Dawn, C,20244 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Huang, Jake,19589 | 95.26 | 0.00 | 0.00 | 0.00 | 95.26 |
| Vazquez, Shannon,26035 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Zeng, Marshall, M,20987 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Rubio, Jessie, J,27868 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Andersen, Lacey,19600 | 94.46 | 0.00 | 0.00 | 0.00 | 94.46 |
| Suarez, Ruben,14031 | 6964.42 | 0.00 | 0.00 | 2049.10 | 4915.32 |
| Martinez, Pamela, A,13529 | 4614.86 | 0.00 | 0.00 | 2071.42 | 2543.44 |
| Raman, Deanna, H,17053 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Hu, Marshall, H,26797 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Zhou, Brent,15434 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Garcia, Ivan, L,17354 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Gutierrez, Tabitha, A,21884 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Luo, Devon, D,22850 | 4657.51 | 0.00 | 0.00 | 2181.56 | 2475.95 |
| Shen, Jodi, A,22028 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Adams, Savannah,23536 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Shen, Kelvin,22406 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Martin, Marc, J,11039 | 6636.58 | 0.00 | 3399.99 | 0.00 | 3236.59 |
| Saunders, Brandy,11946 | 4697.31 | 0.00 | 3399.99 | 0.00 | 1297.32 |
Generated 2025-12-22 06:46:28.275 UTC