0 Replies Latest reply: Apr 13, 2010 7:37 AM by 614805 RSS

    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.