0 Replies Latest reply on Apr 13, 2010 12:37 PM by 614805

    Represent Non Fact values in Measure column and Rolling 3 months data

    614805
      Hi Gurus,

      I have 2 questions.
      1. How do i represent non-fact attributes in measures area without aggregating the values. For instance I need to display Month in the Column Area and Application ID in the Measures level and Department in the Rows Area. Is there any option to achieve this.

      2. For rolling Months i have checked the previous questions. But Moving Sum is not a feasible solution. If i am reporting from Apr 2010, then for Apr 2010 i need to display (Feb+Mar+Apr) for it. What is the function to achieve this. Can i do it with To_date. IF so, can anyone illustrate with an example.