[ROOT]  dt  FactInternetSale  PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount   SELECT *.TMB() AS *   

39 items

OrderDate.YearMonth()Id_SUMAUDCADDEMFRFGBPUSD
2022-12542K205K14.1K28.9K29.8K77K188K
2024-05509K216K20.8K0064K207K
2023-12375K162K14.6K0054K144K
2024-02452K146K14.1K0068K224K
2024-06494K193K21.4K0056K225K
2025-1026.0K0000026.0K
2023-03678K229K51K33.7K18.6K58K288K
2025-011.1M339K69K00137K566K
2025-09951K225K57K00134K535K
2023-05595K202K42.7K0015.3K335K
2023-04614K212K50K0086K265K
2022-09213K82K3.6K21.5K14.1K22.7K70K
2025-071.8M478K127K00217K1.0M
2024-01380K138K15.4K0042.6K183K
2023-01553K235K9.3K52K25.5K31.2K199K
2023-07736K248K68K0028.7K392K
2024-07528K209K20.5K0061K238K
2024-03512K206K21.2K0069K216K
2024-11951K249K58K00126K519K
2025-051.5M412K88K00192K826K
2024-04470K192K22.5K0063K193K
2025-061.5M373K95K00177K813K
2024-09725K236K30.9K0089K369K
2023-02553K203K44.0K35.9K37.5K36.6K196K
2025-021.4M346K82K00214K786K
2023-06624K216K46.1K0046.3K315K
2025-041.4M410K88K00181K719K
2024-08580K216K15.3K0057K291K
2023-08617K201K40.2K0036.6K339K
2024-10839K200K43.3K00148K447K
2023-11462K142K21.2K0066K232K
2025-081.9M470K144K00229K1.1M
2024-121.1M345K71K00135K512K
_SUM29.4M9.1M1.8M238K181K3.4M14.7M
2025-031.5M381K140K00190K808K
2022-10506K250K25.5K32.0K33.2K33.9K132K
2022-11484K191K28.9K33.6K21.8K61K148K
2023-09618K162K61K0039.6K355K
2023-10507K132K42.3K0045.5K287K

Generated 2025-10-15 10:02:05.120 UTC