Forum Stats

  • 3,826,692 Users
  • 2,260,691 Discussions
  • 7,897,053 Comments

Discussions

Display Latest month in Web Studio Report

RJeff
RJeff Member Posts: 10 Green Ribbon

Hello!

Is there a way to display the latest month as the first column in a web studio report?

I've tried several things but it always displays the 1st month first. So for example i am pulling Jan-Jun. I want Jun to be first column, then May, etc. I am trying to create a 12 months rolling report, but needs the latest month to be in the 1st column.

Is this possible?

Any insights is greatly appreciated!!

Tagged:

Comments

  • Stu G-Oracle
    Stu G-Oracle Member Posts: 54 Employee

    Hi

    This is a tricky one as if the definition is in a single column I think it will always display in outline order from left to right. Do you want the entire report to run in reverse or is it just the first column that you want to be the latest month and then the remaining columns to run in outline order?

    Have you looked at the Sort options? If this is the now older FR studio there are options to sort that you can set at the grid level

    To get this to work you might need to have a value associated to each period so that you can sort using that (if you select the drop down where the above shows Period Heading it gives the option to choose a row of data. It is common to have a Calendar or Fiscal period index member in Planning these days (comes out of the box with the modules application type).

    If you are using Narrative Reporting or the new embedded Reports (effectively the MR report type from Narrative that is now embedded into the EPM business process applications) then there is a Sort tab on the right hand side.

    The above setting combined with the Fiscal TP-Index member in row 1 gives this display where this application fiscal year runs April - March.

    For a true rolling 12 months you will likely also need to get into having two columns to split the years and conditional suppression if you want it to be a truly dynamic report but hopefully this will get you started.

    Regards

    Stu

    RJeff
  • RJeff
    RJeff Member Posts: 10 Green Ribbon