[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 47 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| He, Dennis, J,27878 | 1283.82 | 0.00 | 0.00 | 0.00 | 1283.82 |
| Pal, Alison,13042 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Tang, April, A,25935 | 1256.03 | 0.00 | 699.10 | 0.00 | 556.93 |
| Patel, Jay,22213 | 59.27 | 0.00 | 0.00 | 0.00 | 59.27 |
| Ruiz, Naomi,23649 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Shan, Damien, M,11362 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Ma, Cedric, W,11094 | 157.93 | 0.00 | 0.00 | 0.00 | 157.93 |
| Munoz, Ebony,13106 | 5697.52 | 0.00 | 0.00 | 2071.42 | 3626.10 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| Jai, Tommy, C,15027 | 2853.57 | 0.00 | 0.00 | 2049.10 | 804.47 |
| Zheng, Vincent,18496 | 6121.71 | 0.00 | 3578.27 | 0.00 | 2543.44 |
| Zheng, Shannon, M,14678 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Li, Colin, J,18445 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Lu, Micah,22174 | 3007.83 | 0.00 | 0.00 | 2443.35 | 564.48 |
| Powell, Jeremy,11048 | 6498.24 | 0.00 | 3374.99 | 0.00 | 3123.25 |
| Xie, Nina,12997 | 118.18 | 0.00 | 0.00 | 0.00 | 118.18 |
| Ramos, Kristy,16682 | 66.58 | 0.00 | 0.00 | 0.00 | 66.58 |
| Johnson, Daniel,11051 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Lin, Clarence,29069 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Nath, Michele, L,11056 | 8207.50 | 0.00 | 3374.99 | 2413.45 | 2419.06 |
| Smith, Tina, K,19793 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Gutierrez, Micheal, S,27299 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Sanz, Gerald, J,17060 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Gill, Diana,25710 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Yuan, Tamara, E,21166 | 4909.67 | 0.00 | 2443.35 | 0.00 | 2466.32 |
| Andersen, Carl, J,11057 | 8088.04 | 0.00 | 3374.99 | 2319.99 | 2393.06 |
| Yuan, Rafael, J,20625 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Goel, Alisha, C,26767 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Huang, Randy,24007 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Alvarez, Marvin,23651 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Liu, Trisha, V,20214 | 5304.25 | 0.00 | 3578.27 | 0.00 | 1725.98 |
| Guo, Ernest,25717 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Cook, Isaac, M,13994 | 4528.75 | 0.00 | 0.00 | 2071.42 | 2457.33 |
| He, Karen, C,27861 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Sanz, Bruce,23117 | 3931.52 | 0.00 | 0.00 | 2181.56 | 1749.96 |
| Ward, Jessica,15587 | 4423.38 | 0.00 | 0.00 | 2071.42 | 2351.96 |
| Moreno, Melody, R,11760 | 274.92 | 0.00 | 0.00 | 0.00 | 274.92 |
| Luo, Roger, J,18728 | 56.71 | 0.00 | 0.00 | 0.00 | 56.71 |
| Nath, Louis, C,25830 | 1833.57 | 0.00 | 699.10 | 0.00 | 1134.47 |
| Shen, Tamara, G,22935 | 3951.52 | 0.00 | 0.00 | 2181.56 | 1769.96 |
| Taylor, Logan,13522 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Russell, Cassidy, N,26144 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Yang, Shannon,12001 | 8113.01 | 0.00 | 3374.99 | 0.00 | 4738.02 |
| Kapoor, Bryant,22946 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Garcia, Jermaine,21566 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Simpson, Sharon, L,25123 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jai, Ethan,15217 | 41.26 | 0.00 | 0.00 | 0.00 | 41.26 |
| Suarez, Linda,16665 | 81.81 | 0.00 | 0.00 | 0.00 | 81.81 |
| Serrano, Leslie, T,14014 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Wang, Arturo, A,27720 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ramos, Carolyn,17926 | 4715.70 | 0.00 | 3578.27 | 0.00 | 1137.43 |
| Lu, Candice, I,21204 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Vance, Marco,13124 | 87.93 | 0.00 | 0.00 | 0.00 | 87.93 |
| Rana, Jermaine, S,28927 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Jiménez, Briana, T,28118 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Li, Alvin,26764 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Ruiz, Melody,13621 | 167.40 | 0.00 | 0.00 | 0.00 | 167.40 |
| Morgan, Natalie,15149 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Dominguez, Joy,22175 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Raji, Terry,15597 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
Generated 2025-12-21 15:42:17.682 UTC