[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1031 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhao, Todd,23991 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Davis, Brandon,24398 | 42.84 | 0.00 | 0.00 | 0.00 | 42.84 |
| Vance, Meredith, B,20983 | 4178.73 | 0.00 | 3578.27 | 0.00 | 600.46 |
| Sara, Cassandra, D,20989 | 4148.74 | 0.00 | 3578.27 | 0.00 | 570.47 |
| Romero, Briana, A,19284 | 2736.42 | 0.00 | 0.00 | 1000.44 | 1735.98 |
| Cooper, Adrian,15005 | 1503.58 | 0.00 | 699.10 | 0.00 | 804.48 |
| Pal, Tommy,13840 | 3010.03 | 0.00 | 0.00 | 2181.56 | 828.47 |
| Perez, Molly,25941 | 1255.36 | 0.00 | 699.10 | 0.00 | 556.26 |
| Long, Jocelyn,12886 | 5965.22 | 0.00 | 3578.27 | 0.00 | 2386.95 |
| Evans, Luke,29176 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Ms., King, Amber, S,15935 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gray, Jasmine, A,19904 | 3018.36 | 0.00 | 699.10 | 0.00 | 2319.26 |
| Thomas, Samantha,21690 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Shan, Deborah,20624 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Jai, April,15660 | 5169.07 | 0.00 | 3578.27 | 0.00 | 1590.80 |
| Butler, Antonio,12756 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Thomas, Jonathan, C,19777 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Jai, Jodi, M,27971 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Nelson, Morgan,20501 | 64.98 | 0.00 | 0.00 | 0.00 | 64.98 |
| Sharma, April, J,17997 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Campbell, Jonathan, D,12784 | 5985.22 | 0.00 | 3578.27 | 0.00 | 2406.95 |
| Zhou, Lisa, L,13809 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| King, Connor,26106 | 5768.05 | 0.00 | 3374.99 | 0.00 | 2393.06 |
| White, Dalton, R,16765 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sharma, Rafael, B,12200 | 5935.55 | 0.00 | 3578.27 | 0.00 | 2357.28 |
| Johnson, Chloe, L,20617 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Liang, Crystal, J,11549 | 7023.77 | 0.00 | 3399.99 | 0.00 | 3623.78 |
| Griffin, Morgan, M,24983 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Long, James, Y,21844 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Foster, Destiny, E,12194 | 82.93 | 0.00 | 0.00 | 0.00 | 82.93 |
| Serrano, Billy, P,24080 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Perez, Jillian, E,20827 | 11.94 | 0.00 | 0.00 | 0.00 | 11.94 |
| Ramirez, Amanda, E,15017 | 1307.06 | 0.00 | 699.10 | 607.96 | 0.00 |
| Cook, Jennifer, J,23550 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Smith, Joshua, C,16362 | 2482.23 | 0.00 | 0.00 | 0.00 | 2482.23 |
| Williams, Jessica, A,13594 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Wright, Kevin, A,26096 | 5843.54 | 0.00 | 3399.99 | 0.00 | 2443.55 |
| Ortega, Jamie,14978 | 4209.21 | 0.00 | 3578.27 | 0.00 | 630.94 |
| Zhang, Thomas, H,12769 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Chapman, Jodi, L,22966 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Lee, Seth, C,23006 | 39.47 | 0.00 | 0.00 | 0.00 | 39.47 |
| Ross, Katherine,20292 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Smith, Tammy, L,13555 | 6484.45 | 0.00 | 3578.27 | 0.00 | 2906.18 |
| Howard, Arianna, W,20743 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| She, Alisha, G,24757 | 4343.59 | 0.00 | 3578.27 | 0.00 | 765.32 |
| Ortega, Javier, P,12785 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Shan, Ethan,12178 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Srini, Bryant, P,12186 | 5913.24 | 0.00 | 3578.27 | 0.00 | 2334.97 |
| Harris, Alexis,15316 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Xie, Kurt, A,14344 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Shan, Maurice, M,11433 | 12909.67 | 0.00 | 0.00 | 6934.48 | 5975.19 |
| Ms., Simon, Britta,25946 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Washington, Ian, M,24664 | 4368.58 | 0.00 | 3578.27 | 0.00 | 790.31 |
| Ma, Darryl, R,15599 | 81.24 | 0.00 | 0.00 | 0.00 | 81.24 |
| Alvarez, Latasha,18047 | 2736.42 | 0.00 | 1000.44 | 0.00 | 1735.98 |
| Tang, Tony, C,19930 | 3115.27 | 0.00 | 782.99 | 0.00 | 2332.28 |
| Jai, Shawna, W,17750 | 2888.53 | 0.00 | 0.00 | 2181.56 | 706.97 |
| Sai, Cindy, E,11547 | 4976.38 | 0.00 | 0.00 | 4401.40 | 574.98 |
| She, Leah, R,11621 | 123.24 | 0.00 | 0.00 | 0.00 | 123.24 |
| Liang, Leah,16412 | 4921.59 | 0.00 | 0.00 | 2443.35 | 2478.24 |
| Ma, Trisha, E,13039 | 3282.83 | 0.00 | 2443.35 | 0.00 | 839.48 |
| Simmons, Ethan,13210 | 4501.55 | 0.00 | 2181.56 | 0.00 | 2319.99 |
Generated 2025-12-24 07:09:37.416 UTC