[ROOT] dt FactResellerSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount SELECT *.TMB() AS *
34 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | EUR | GBP | USD |
|---|---|---|---|---|---|---|
| 2024-02 | 3.1M | 0 | 510K | 8.6K | 141K | 2.4M |
| 2024-03 | 2.2M | 0 | 489K | 0 | 166K | 1.5M |
| 2023-11 | 3.6M | 0 | 658K | 10.5K | 183K | 2.7M |
| 2024-07 | 4.7M | 0 | 907K | 22.1K | 160K | 3.7M |
| 2025-05 | 2.7M | 77K | 323K | 193K | 151K | 2.0M |
| 2024-09 | 2.7M | 49.8K | 501K | 204K | 152K | 1.8M |
| 2023-01 | 845K | 0 | 235K | 0 | 0 | 610K |
| 2025-09 | 3.4M | 232K | 585K | 136K | 426K | 2.0M |
| 2024-12 | 6.3M | 322K | 1.1M | 329K | 612K | 4.0M |
| 2022-11 | 1.5M | 0 | 317K | 0 | 0 | 1.2M |
| 2022-12 | 1.2M | 0 | 206K | 0 | 0 | 960K |
| 2023-02 | 2.3M | 0 | 382K | 0 | 0 | 1.9M |
| 2023-04 | 713K | 0 | 164K | 0 | 0 | 549K |
| 2023-06 | 1.5M | 0 | 335K | 0 | 0 | 1.1M |
| 2023-07 | 883K | 0 | 228K | 0 | 0 | 655K |
| 2024-01 | 1.8M | 0 | 397K | 18.7K | 63K | 1.3M |
| 2024-04 | 1.3M | 0 | 260K | 4.8K | 36.8K | 1.0M |
| 2025-04 | 1.7M | 63K | 237K | 124K | 81K | 1.2M |
| 2025-03 | 3.5M | 217K | 712K | 161K | 418K | 2.0M |
| 2025-07 | 2.2M | 59K | 386K | 187K | 110K | 1.5M |
| 2022-10 | 489K | 0 | 115K | 0 | 0 | 374K |
| 2023-03 | 1.7M | 0 | 259K | 0 | 0 | 1.4M |
| 2023-05 | 1.9M | 0 | 277K | 0 | 0 | 1.6M |
| 2024-08 | 2.0M | 0 | 443K | 0 | 131K | 1.4M |
| 2025-01 | 3.5M | 124K | 433K | 285K | 199K | 2.4M |
| 2023-08 | 2.3M | 0 | 385K | 0 | 0 | 1.9M |
| 2023-09 | 1.0M | 0 | 178K | 0 | 0 | 824K |
| 2023-10 | 2.4M | 0 | 638K | 42.4K | 81K | 1.6M |
| 2023-12 | 2.9M | 0 | 564K | 0 | 208K | 2.1M |
| 2024-05 | 3.9M | 0 | 748K | 10.7K | 237K | 3.0M |
| 2024-10 | 4.2M | 134K | 567K | 345K | 213K | 3.0M |
| 2025-06 | 2.7M | 201K | 465K | 134K | 311K | 1.6M |
| 2025-08 | 3.3M | 116K | 395K | 258K | 199K | 2.3M |
| _SUM | 80M | 1.6M | 14.4M | 2.5M | 4.3M | 58M |
Generated 2025-10-31 13:11:34.189 UTC