[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount SELECT *.TMB() AS * < ORDER BY OrderDate.YearMonth()Id
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| _SUM | 29.4M | 9.1M | 1.8M | 238K | 181K | 3.4M | 14.7M |
| 2021-08 | 199K | 75K | 3.6K | 17.9K | 14.1K | 22.7K | 66K |
| 2021-09 | 499K | 250K | 25.5K | 35.6K | 33.2K | 30.5K | 125K |
| 2021-10 | 491K | 191K | 28.9K | 33.6K | 21.8K | 65K | 152K |
| 2021-11 | 532K | 205K | 10.7K | 25.4K | 29.8K | 77K | 184K |
| 2021-12 | 538K | 221K | 12.6K | 56K | 25.5K | 31.2K | 192K |
| 2022-01 | 633K | 239K | 44.0K | 40.2K | 37.5K | 40.2K | 232K |
| 2022-02 | 599K | 197K | 51K | 29.4K | 18.6K | 47.4K | 256K |
| 2022-03 | 628K | 230K | 50K | 0 | 0 | 86K | 262K |
| 2022-04 | 572K | 180K | 39.2K | 0 | 0 | 22.3K | 330K |
| 2022-05 | 625K | 217K | 46.1K | 0 | 0 | 39.2K | 323K |
| 2022-06 | 730K | 248K | 61K | 0 | 0 | 35.9K | 385K |
| 2022-07 | 647K | 218K | 47.4K | 0 | 0 | 36.6K | 344K |
| 2022-08 | 629K | 159K | 65K | 0 | 0 | 39.6K | 366K |
| 2022-09 | 486K | 137K | 39.9K | 0 | 0 | 42.3K | 268K |
| 2022-10 | 485K | 142K | 21.2K | 0 | 0 | 69K | 252K |
| 2022-11 | 359K | 156K | 17.0K | 0 | 0 | 48.0K | 138K |
| 2022-12 | 383K | 143K | 15.4K | 0 | 0 | 43.6K | 182K |
| 2023-01 | 472K | 149K | 14.1K | 0 | 0 | 72K | 237K |
| 2023-02 | 463K | 186K | 21.2K | 0 | 0 | 61K | 195K |
| 2023-03 | 480K | 199K | 22.5K | 0 | 0 | 69K | 190K |
| 2023-04 | 504K | 215K | 16.7K | 0 | 0 | 55K | 217K |
| 2023-05 | 507K | 197K | 25.5K | 0 | 0 | 62K | 222K |
| 2023-06 | 518K | 200K | 20.5K | 0 | 0 | 59K | 239K |
| 2023-07 | 568K | 213K | 15.3K | 0 | 0 | 60K | 279K |
| 2023-08 | 724K | 242K | 26.2K | 0 | 0 | 87K | 369K |
| 2023-09 | 828K | 205K | 41.0K | 0 | 0 | 140K | 441K |
| 2023-10 | 962K | 246K | 61K | 0 | 0 | 133K | 522K |
| 2023-11 | 1.0M | 317K | 69K | 0 | 0 | 125K | 505K |
| 2023-12 | 1.1M | 351K | 66K | 0 | 0 | 141K | 533K |
| 2024-01 | 1.6M | 375K | 91K | 0 | 0 | 226K | 858K |
| 2024-02 | 1.4M | 341K | 136K | 0 | 0 | 178K | 768K |
| 2024-03 | 1.4M | 441K | 90K | 0 | 0 | 187K | 726K |
| 2024-04 | 1.5M | 397K | 87K | 0 | 0 | 191K | 830K |
| 2024-05 | 1.5M | 389K | 93K | 0 | 0 | 182K | 810K |
| 2024-06 | 1.8M | 453K | 126K | 0 | 0 | 209K | 964K |
| 2024-07 | 1.9M | 484K | 142K | 0 | 0 | 223K | 1.1M |
| 2024-08 | 1.1M | 245K | 65K | 0 | 0 | 151K | 612K |
| 2024-09 | 27.6K | 0 | 0 | 0 | 0 | 0 | 27.6K |
Generated 2024-09-16 19:16:08.150 UTC