[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount SELECT *.TMB() AS * ORDER BY OrderDate.YearMonth()Id DESC >
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2025-07 | 2.6K | 0 | 0 | 0 | 0 | 0 | 2.6K |
| 2025-06 | 48.2K | 222 | 472 | 0 | 0 | 51 | 47.5K |
| 2025-05 | 2.0M | 498K | 144K | 0 | 0 | 264K | 1.1M |
| 2025-04 | 1.8M | 417K | 126K | 0 | 0 | 207K | 1.1M |
| 2025-03 | 1.7M | 455K | 107K | 0 | 0 | 191K | 907K |
| 2025-02 | 1.3M | 353K | 82K | 0 | 0 | 173K | 711K |
| 2025-01 | 1.6M | 440K | 92K | 0 | 0 | 212K | 828K |
| 2024-12 | 1.3M | 392K | 111K | 0 | 0 | 159K | 680K |
| 2024-11 | 1.7M | 370K | 121K | 0 | 0 | 213K | 965K |
| 2024-10 | 1.3M | 348K | 94K | 0 | 0 | 181K | 636K |
| 2024-09 | 1.1M | 336K | 47.5K | 0 | 0 | 153K | 521K |
| 2024-08 | 1.0M | 334K | 63K | 0 | 0 | 133K | 505K |
| 2024-07 | 847K | 188K | 62K | 0 | 0 | 124K | 474K |
| 2024-06 | 863K | 249K | 38.2K | 0 | 0 | 131K | 444K |
| 2024-05 | 579K | 206K | 7.4K | 0 | 0 | 57K | 308K |
| 2024-04 | 541K | 197K | 28.1K | 0 | 0 | 68K | 248K |
| 2024-03 | 528K | 213K | 14.0K | 0 | 0 | 52K | 250K |
| 2024-02 | 456K | 188K | 22.7K | 0 | 0 | 56K | 189K |
| 2024-01 | 536K | 223K | 27.0K | 0 | 0 | 69K | 217K |
| 2023-12 | 433K | 188K | 12.2K | 0 | 0 | 64K | 169K |
| 2023-11 | 566K | 200K | 23.9K | 0 | 0 | 74K | 268K |
| 2023-10 | 342K | 104K | 9.2K | 0 | 0 | 50K | 179K |
| 2023-09 | 408K | 187K | 16.3K | 0 | 0 | 47.9K | 157K |
| 2023-08 | 374K | 126K | 15.2K | 0 | 0 | 54K | 178K |
| 2023-07 | 542K | 148K | 37.7K | 0 | 0 | 64K | 293K |
| 2023-06 | 481K | 123K | 42.1K | 0 | 0 | 40.5K | 275K |
| 2023-05 | 684K | 210K | 65K | 0 | 0 | 42.9K | 367K |
| 2023-04 | 666K | 206K | 46.1K | 0 | 0 | 26.1K | 388K |
| 2023-03 | 678K | 228K | 71K | 0 | 0 | 35.4K | 343K |
| 2023-02 | 590K | 214K | 24.8K | 0 | 0 | 36.1K | 315K |
| 2023-01 | 613K | 186K | 57K | 0 | 0 | 47.2K | 322K |
| 2022-12 | 597K | 217K | 50K | 3.6K | 0 | 75K | 251K |
| 2022-11 | 733K | 273K | 36.3K | 52K | 37.7K | 51K | 283K |
| 2022-10 | 551K | 211K | 29.8K | 46.8K | 36.8K | 27.0K | 200K |
| 2022-09 | 507K | 218K | 11.9K | 36.8K | 11.4K | 55K | 173K |
| 2022-08 | 495K | 185K | 21.3K | 25.7K | 39.7K | 63K | 161K |
| 2022-07 | 500K | 216K | 25.5K | 40.8K | 15.5K | 54K | 149K |
| 2022-06 | 458K | 206K | 22.0K | 32.0K | 39.5K | 37.5K | 121K |
| _SUM | 29.4M | 9.1M | 1.8M | 238K | 181K | 3.4M | 14.7M |
Generated 2025-07-02 00:46:47.216 UTC