[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 30 >
30 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Carlson, Jill,21886 | 4696.49 | 0.00 | 2181.56 | 0.00 | 2514.93 |
Thompson, Michael, M,26148 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
Arthur, Jay, R,12694 | 6785.13 | 0.00 | 2049.10 | 0.00 | 4736.03 |
Serrano, Stacy,24613 | 2148.21 | 0.00 | 1000.44 | 1147.77 | 0.00 |
Dominguez, Jimmy,21959 | 4702.39 | 0.00 | 2181.56 | 0.00 | 2520.83 |
Nara, Dawn, M,21891 | 4921.69 | 0.00 | 2443.35 | 0.00 | 2478.34 |
Li, Marshall,12687 | 6805.47 | 0.00 | 2071.42 | 2349.98 | 2384.07 |
Long, Emily, L,26140 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
Rai, Brendan, A,21569 | 4960.16 | 0.00 | 2443.35 | 0.00 | 2516.81 |
Dominguez, Micheal,26142 | 1952.45 | 0.00 | 782.99 | 0.00 | 1169.46 |
She, Kelli, J,24889 | 2269.91 | 0.00 | 1000.44 | 1269.47 | 0.00 |
Chander, Latoya, C,26138 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
Xie, Brendan,13018 | 2642.38 | 0.00 | 2071.42 | 0.00 | 570.96 |
Mehta, Mayra,12998 | 5694.90 | 0.00 | 2049.10 | 0.00 | 3645.80 |
Torres, Jacqueline,21976 | 4198.33 | 0.00 | 2443.35 | 0.00 | 1754.98 |
Liang, Glenn,21983 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
Chande, Michele, C,13078 | 6850.46 | 0.00 | 2071.42 | 0.00 | 4779.04 |
Raje, Rafael, M,13000 | 6799.45 | 0.00 | 2071.42 | 2294.99 | 2433.04 |
Sara, Barry, R,13965 | 6872.39 | 0.00 | 0.00 | 2071.42 | 4800.97 |
Lal, Franklin, A,14101 | 3679.90 | 0.00 | 0.00 | 2888.58 | 791.32 |
Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 34.89 | 29.99 |
Hernandez, Max,18192 | 63.97 | 0.00 | 0.00 | 34.99 | 28.98 |
She, Derek,15036 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 |
Kapoor, Kristina,11997 | 7029.78 | 0.00 | 3399.99 | 1249.84 | 2379.95 |
Lu, Micah,22174 | 3007.83 | 0.00 | 2443.35 | 564.48 | 0.00 |
Ye, Martha,22200 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
Yuan, Jaclyn,24904 | 2199.90 | 0.00 | 1000.44 | 1199.46 | 0.00 |
Nara, Grant,12995 | 6850.58 | 0.00 | 2049.10 | 0.00 | 4801.48 |
Hernandez, Leslie, D,12990 | 6829.47 | 0.00 | 2071.42 | 0.00 | 4758.05 |
Serrano, Jésus, B,12991 | 5641.90 | 0.00 | 2049.10 | 0.00 | 3592.80 |
Generated 2024-09-20 08:27:37.835 UTC