This discussion is archived
0 Replies Latest reply: Apr 13, 2010 5:37 AM by 614805 RSS

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

614805 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points