[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 20 < SKIP 376 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lal, Tracy, W,23086 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Goldstein, Dustin,12337 | 8137.01 | 0.00 | 3399.99 | 0.00 | 4737.02 |
| Liu, Ronnie,26130 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Sara, Adriana, M,15146 | 161.94 | 0.00 | 0.00 | 0.00 | 161.94 |
| Lal, Colin, M,16640 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Zhang, Ronnie,16656 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Ma, Curtis,28119 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Zhang, Warren, L,25252 | 1893.05 | 699.10 | 0.00 | 0.00 | 1193.95 |
| Madan, Carla, D,28135 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Suarez, Jacquelyn, C,11010 | 8088.04 | 3399.99 | 0.00 | 2294.99 | 2393.06 |
| Ms., Rusek, Pearlie, J.,21945 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Romero, Walter, A,25020 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Alvarez, Pedro, E,28120 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Collins, Rebecca, M,26153 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Shen, Alison, A,16614 | 71.16 | 0.00 | 0.00 | 0.00 | 71.16 |
| Vazquez, Eddie, T,14012 | 5249.92 | 0.00 | 0.00 | 2049.10 | 3200.82 |
| Barnes, Angelica,15128 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Nara, Jaclyn, M,11930 | 5035.81 | 0.00 | 3399.99 | 0.00 | 1635.82 |
| Blanco, Kristi,15464 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Hu, Jenny, A,16634 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Ye, Lacey,29090 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Gonzalez, Jan, A,15262 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Munoz, Theresa, M,13953 | 6840.75 | 0.00 | 0.00 | 2071.42 | 4769.33 |
| Torres, Naomi, J,14061 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Morgan, Carlos,25819 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Navarro, Meredith,27703 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Powell, Grace, B,29194 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Vance, Kristi, T,28338 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Sai, Francisco, W,18766 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Chande, Derek,26743 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Roberts, Jennifer,11447 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
Generated 2025-12-24 06:34:49.099 UTC