[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 972 > < TAKE 28 >
28 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Richardson, Brian,28608 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
Li, Gilbert,23999 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
Dominguez, Kari, S,17789 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
Bailey, Jeremy,20122 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
Lin, Marshall,16822 | 7176.38 | 0.00 | 0.00 | 2443.35 | 4733.03 |
Pal, Mario, C,17824 | 4334.61 | 0.00 | 0.00 | 2443.35 | 1891.26 |
Chavez, Kara, P,13285 | 214.35 | 0.00 | 0.00 | 119.89 | 94.46 |
Jai, Hunter, M,28272 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
Anderson, Taylor, A,15851 | 3198.46 | 0.00 | 0.00 | 782.99 | 2415.47 |
Li, Heather, C,12803 | 144.18 | 0.00 | 0.00 | 99.96 | 44.22 |
Sanders, Erin, A,11310 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
Evans, Jonathan, D,15185 | 4393.70 | 0.00 | 0.00 | 2071.42 | 2322.28 |
Washington, Alexandra, E,15498 | 256.52 | 0.00 | 0.00 | 223.92 | 32.60 |
Taylor, Eduardo, L,17796 | 3921.02 | 0.00 | 0.00 | 2181.56 | 1739.46 |
Hayes, Isabel,21908 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
Watson, Ariana,17039 | 1799.48 | 0.00 | 0.00 | 1799.48 | 0.00 |
Gonzalez, Jackson, S,14480 | 194.94 | 0.00 | 0.00 | 0.00 | 194.94 |
Suri, Sergio, C,16391 | 4624.91 | 0.00 | 0.00 | 4624.91 | 0.00 |
Diaz, Thomas, O,16020 | 595.96 | 0.00 | 0.00 | 595.96 | 0.00 |
Sai, Tammy,12718 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
Russell, Jordyn,16129 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
Romero, Reginald, F,12854 | 4367.02 | 0.00 | 0.00 | 2049.10 | 2317.92 |
Young, Rebecca, W,14418 | 1928.93 | 0.00 | 0.00 | 1000.44 | 928.49 |
Cai, Bianca, D,22173 | 2735.53 | 0.00 | 2181.56 | 553.97 | 0.00 |
Flores, Jessica, R,27251 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
Wilson, Jennifer,14435 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
Subram, Troy, R,19607 | 6054.22 | 0.00 | 3578.27 | 2475.95 | 0.00 |
Alonso, Deanna, A,15347 | 1631.46 | 0.00 | 782.99 | 0.00 | 848.47 |
Generated 2024-09-21 12:36:09.097 UTC