[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 50 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzalez, Summer, L,20266 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Shen, Karla, E,22925 | 134.93 | 0.00 | 0.00 | 0.00 | 134.93 |
| Anand, Johnny,14058 | 5652.52 | 0.00 | 0.00 | 2071.42 | 3581.10 |
| Raman, Abby, T,15122 | 5193.72 | 0.00 | 0.00 | 2071.42 | 3122.30 |
| Huang, Tamara, E,14053 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Rodriguez, Wyatt, D,21218 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Zhang, Jon,28111 | 865.31 | 0.00 | 0.00 | 0.00 | 865.31 |
| Munoz, Shannon, S,29122 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Lopez, Darren,29081 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Garcia, Andre, H,12705 | 6854.11 | 0.00 | 0.00 | 2049.10 | 4805.01 |
| She, Melvin,16516 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Gonzalez, Virginia,11929 | 4965.78 | 0.00 | 3374.99 | 0.00 | 1590.79 |
| Prasad, Levi,25705 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Guo, Lacey,16744 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Navarro, Daisy,27514 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Nara, Karl,15142 | 138.46 | 0.00 | 0.00 | 0.00 | 138.46 |
| Vazquez, Jonathon,17906 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Shen, Jodi, A,22028 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Munoz, Theresa, M,13953 | 6840.75 | 0.00 | 0.00 | 2071.42 | 4769.33 |
| Ms., Seidel, Birgit,16621 | 73.86 | 0.00 | 0.00 | 0.00 | 73.86 |
| Sanz, Meghan, L,28352 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Cai, Karen,22572 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Srini, Cindy, E,26026 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Alvarez, Kari, C,11108 | 8124.04 | 0.00 | 3374.99 | 2329.99 | 2419.06 |
| Nath, Cassie,24606 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
| Saunders, Jillian,21178 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Ruiz, Alfredo,21975 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| He, Kelli, A,28872 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Mehta, Arthur, A,19957 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Nelson, Sophia,16664 | 4377.75 | 0.00 | 3578.27 | 799.48 | 0.00 |
| She, Bradley, L,16016 | 117.93 | 0.00 | 0.00 | 0.00 | 117.93 |
| Kumar, Cedric, B,22860 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Powell, Lucas, T,18278 | 158.95 | 0.00 | 0.00 | 0.00 | 158.95 |
| Morris, Isaac, G,26439 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Hughes, Lucas, E,26657 | 1357.97 | 0.00 | 0.00 | 1357.97 | 0.00 |
| Kumar, Bridget,15802 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Rai, Raul, R,15133 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Nara, Rafael, J,17052 | 96.92 | 0.00 | 0.00 | 0.00 | 96.92 |
| Mr., Shen, Alan,24257 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Green, Jennifer,12571 | 2641.39 | 0.00 | 2071.42 | 0.00 | 569.97 |
| Martin, Ebony, F,15223 | 4366.41 | 0.00 | 0.00 | 2071.42 | 2294.99 |
| Xie, Michele, M,15039 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Moreno, Kristine, K,28481 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Cook, Sydney, D,13118 | 5669.90 | 0.00 | 0.00 | 2049.10 | 3620.80 |
| Chande, Katrina, L,19968 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Rai, Christy,16683 | 69.87 | 0.00 | 0.00 | 0.00 | 69.87 |
| Sun, Krystal,18908 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Zeng, Louis,18903 | 4143.74 | 0.00 | 3578.27 | 565.47 | 0.00 |
| Lee, Grace, J,28318 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Ramos, Jerome, L,29187 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Ms., Robinson, Rebecca, A.,11913 | 41.26 | 0.00 | 0.00 | 0.00 | 41.26 |
| Kapoor, Kristina,11997 | 7029.78 | 0.00 | 3399.99 | 0.00 | 3629.79 |
| She, Bridget, M,19557 | 5358.24 | 0.00 | 3578.27 | 0.00 | 1779.97 |
| Ortega, Joanna,17909 | 4761.74 | 0.00 | 3578.27 | 0.00 | 1183.47 |
| Hernandez, Jill, L,13003 | 230.25 | 0.00 | 0.00 | 0.00 | 230.25 |
| Shen, Alison, A,16614 | 71.16 | 0.00 | 0.00 | 0.00 | 71.16 |
Generated 2025-12-23 07:25:18.990 UTC