Skip to main content
Question

Display Monthly / MTD / YTD / FY / YTG and variance (in Amount and %) for 4 versions (1 main and 3 subs) + Version name display + Selector use only

  • March 16, 2026
  • 0 replies
  • 13 views

Forum|alt.badge.img+1
  • Within a single report, display a “Monthly” view limited to the main version  (current Fiscal Year - FY) only (i.e. no monthly view for prior years), together with MTD / YTD / FY / YTG views for three other versions (N-1, Budget, latest Forecast), as well as variances between the current FY and each of these three scenarios (i.e. no variances between those versions themselves, only versus the current FY)

  • Considering the requirement above, manage version labels appropriately by displaying business-friendly names instead of technical names, while also allowing users to dynamically select the versions to view and compare within the report

  • Use selectors rather than dedicated version selection tables for each version displayed in the board