[ROOT]  dt  FactResellerSale  PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount   SELECT *.TMB() AS *   ORDER BY OrderDate.YearMonth()Id DESC  >   TITLE Reseller sales per year and month   

Reseller sales per year and month

37 items

OrderDate.YearMonth()Id_SUMAUDCADEURGBPUSD
2023-013.4M232K585K136K426K2.0M
2022-123.3M116K395K258K199K2.3M
2022-112.2M59K386K187K110K1.5M
2022-102.7M201K465K135K311K1.6M
2022-092.7M77K323K192K151K2.0M
2022-081.7M63K237K124K81K1.2M
2022-073.5M217K712K161K418K2.0M
2022-063.5M124K433K285K199K2.4M
2022-052.3M55K402K204K116K1.5M
2022-044.0M267K677K126K496K2.5M
2022-034.2M134K567K345K213K3.0M
2022-022.7M49.8K501K204K152K1.8M
2022-012.0M0443K0131K1.4M
2021-122.9M0468K10.3K112K2.3M
2021-111.9M0439K11.8K48.1K1.4M
2021-101.6M0394K0116K1.1M
2021-092.4M0354K10.7K121K1.9M
2021-081.3M0260K4.8K36.8K1.0M
2021-072.2M0489K0166K1.5M
2021-063.1M0510K8.6K141K2.4M
2021-051.8M0397K18.7K63K1.3M
2021-042.9M0564K0208K2.1M
2021-033.6M0658K10.5K183K2.7M
2021-022.4M0638K42.4K81K1.6M
2021-011.0M0178K00824K
2020-122.3M0385K001.9M
2020-11883K0228K00655K
2020-101.5M0335K001.1M
2020-091.9M0277K001.6M
2020-08713K0164K00549K
2020-071.7M0259K001.4M
2020-062.3M0382K001.9M
2020-05845K0235K00610K
2020-041.2M0206K00960K
2020-031.5M0317K001.2M
2020-02489K0115K00374K
_SUM80M1.6M14.4M2.5M4.3M58M

Generated 2023-03-20 09:17:20.135 UTC