[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 65 > < TAKE 96 >
96 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gutierrez, Micheal, S,27299 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Hernandez, Melody, E,28212 | 619.46 | 0.00 | 0.00 | 0.00 | 619.46 |
| Liang, Lacey, A,15719 | 4429.57 | 0.00 | 0.00 | 2049.10 | 2380.47 |
| Deng, Willie, J,27876 | 1214.85 | 0.00 | 0.00 | 0.00 | 1214.85 |
| Edwards, Carlos,16680 | 104.86 | 0.00 | 0.00 | 0.00 | 104.86 |
| Alonso, Danny, S,18217 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Rodriguez, Joel, C,16488 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Suri, Carmen, E,24250 | 2738.49 | 0.00 | 0.00 | 2181.56 | 556.93 |
| Gutierrez, Clinton,21001 | 3018.33 | 0.00 | 2443.35 | 0.00 | 574.98 |
| Jenkins, Anna, M,17234 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Blanco, Leslie, L,27695 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Gill, Billy, L,16700 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Pal, Christine, I,18242 | 6121.71 | 0.00 | 3578.27 | 2543.44 | 0.00 |
| Shen, Russell, M,11150 | 192.42 | 0.00 | 0.00 | 0.00 | 192.42 |
| Gomez, Gary,15640 | 34.57 | 0.00 | 0.00 | 2.29 | 32.28 |
| Coleman, Ethan, G,16693 | 6060.50 | 0.00 | 3578.27 | 2482.23 | 0.00 |
| Sharma, Dustin, M,18484 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Ma, Laura, L,24503 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Dominguez, Philip,15730 | 122.96 | 0.00 | 0.00 | 0.00 | 122.96 |
| Luo, Roger, J,18728 | 56.71 | 0.00 | 0.00 | 0.00 | 56.71 |
| Patel, Kaitlin, L,16615 | 95.84 | 0.00 | 0.00 | 0.00 | 95.84 |
| Beck, Alejandro,11025 | 6576.80 | 3374.99 | 0.00 | 2405.47 | 796.34 |
| Johnson, Logan, K,22931 | 3882.55 | 0.00 | 0.00 | 3882.55 | 0.00 |
| Arun, Nancy, C,21169 | 4647.88 | 0.00 | 2181.56 | 0.00 | 2466.32 |
| Zhang, Tiffany, R,17318 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Sun, Christy,25218 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Fernandez, Brandy, B,22958 | 4208.31 | 0.00 | 0.00 | 2443.35 | 1764.96 |
| Zeng, Krystal, A,25814 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Lewis, Jasmine,13964 | 6806.45 | 0.00 | 0.00 | 2071.42 | 4735.03 |
| Cai, Curtis,21259 | 3907.54 | 0.00 | 0.00 | 2181.56 | 1725.98 |
| Blanco, Kari,19627 | 41.75 | 0.00 | 0.00 | 0.00 | 41.75 |
| Sutton, Cassie, S,16613 | 129.35 | 0.00 | 0.00 | 0.00 | 129.35 |
| Gutierrez, Rodney, J,20628 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Lu, Crystal, A,15145 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Chavez, Karla, K,16704 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Wu, Laura,20615 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Anand, Kara,11989 | 8139.53 | 0.00 | 3374.99 | 0.00 | 4764.54 |
| Madan, Marco,18895 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Navarro, Tyrone, K,25557 | 1262.87 | 0.00 | 699.10 | 0.00 | 563.77 |
| Raman, Brett, L,22930 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Nara, Kelsey, A,24905 | 2195.91 | 0.00 | 0.00 | 1000.44 | 1195.47 |
| Navarro, Francis, J,27520 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Ramos, Victor, D,24246 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Malhotra, Whitney, D,28944 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Gill, Melinda, G,11151 | 8087.31 | 0.00 | 3374.99 | 0.00 | 4712.32 |
| Xu, Clayton,18488 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Anand, Carly,25918 | 1260.58 | 0.00 | 699.10 | 0.00 | 561.48 |
| Sai, Ross, A,21966 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Hayes, Eric, A,22964 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Rubio, Nelson,26433 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Pal, Nina,29297 | 613.45 | 0.00 | 0.00 | 0.00 | 613.45 |
| Kim, Kari, S,11445 | 8098.03 | 0.00 | 3399.99 | 2304.98 | 2393.06 |
| Griffin, Brianna, K,16487 | 73.24 | 0.00 | 0.00 | 0.00 | 73.24 |
| Washington, Marcus,28329 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Raji, Arturo,23998 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Xu, Sharon, A,23344 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Shen, Kelsey, R,22921 | 4647.88 | 0.00 | 0.00 | 2181.56 | 2466.32 |
| Moreno, Kristi,23415 | 3588.83 | 0.00 | 0.00 | 2443.35 | 1145.48 |
| Hu, Barbara,19567 | 104.96 | 0.00 | 0.00 | 0.00 | 104.96 |
| Lal, Alicia,15734 | 4426.41 | 0.00 | 0.00 | 2071.42 | 2354.99 |
| Chandra, Monica, H,18898 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Raje, Gregory, C,22911 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nara, Rafael, J,17052 | 96.92 | 0.00 | 0.00 | 0.00 | 96.92 |
| Madan, Jay, L,20156 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Suarez, Orlando,11121 | 58.16 | 0.00 | 0.00 | 0.00 | 58.16 |
| Zeng, Warren, R,24477 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Hernandez, Tabitha, L,19603 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Gao, Rosa,26034 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Zhou, Autumn, L,25229 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Ma, Cedric, W,11094 | 157.93 | 0.00 | 0.00 | 0.00 | 157.93 |
| Ms., Salavaria, Sharon,11964 | 8173.53 | 0.00 | 3399.99 | 0.00 | 4773.54 |
| Ramos, Dana, D,25919 | 1248.08 | 0.00 | 699.10 | 0.00 | 548.98 |
| Vazquez, Jésus,26665 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Romero, Erika,19958 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Gutierrez, Philip, M,21979 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Wang, Curtis, A,13108 | 5718.66 | 0.00 | 0.00 | 2071.42 | 3647.24 |
| Zhang, Susan, S,18216 | 38.92 | 0.00 | 0.00 | 0.00 | 38.92 |
| She, Derek,15036 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 |
| Martin, Craig, M,25012 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| King, Maria, E,28202 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Deng, April,11117 | 8184.99 | 0.00 | 3399.99 | 2365.94 | 2419.06 |
| Deng, Latoya, H,21969 | 4759.47 | 0.00 | 0.00 | 2181.56 | 2577.91 |
| Sun, Aimee, R,18319 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Sun, Clayton,28533 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Alonso, Naomi,15830 | 2680.38 | 0.00 | 0.00 | 2071.42 | 608.96 |
| Zheng, Colleen,13026 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Blanco, Victor,15586 | 4469.37 | 0.00 | 0.00 | 2071.42 | 2397.95 |
| King, Hailey, A,28214 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Campbell, Jason, J,13625 | 6962.14 | 0.00 | 0.00 | 2049.10 | 4913.04 |
| Liu, Brittney, M,15804 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Luo, Warren,23562 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raman, Ronald, M,17077 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 0.00 | 1179.97 |
| Lin, Heather, L,15718 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Hernandez, Philip,21193 | 3905.52 | 0.00 | 2181.56 | 0.00 | 1723.96 |
| Carlson, Francis,27340 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
Generated 2025-12-23 22:11:27.876 UTC