Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calculate Average YTD%

user10441472Jul 6 2009

Hi Guru's,

I need to calculate the (Average)%YTD for the whole year from Jan to Dec.
I am using the cast function to get the month as Jan,09 to Dec,09 in the answers.
and then using a pivot table to get the months (Dragging months into columns) as columns.
Now in the last column i need to calculate the %YTD(Average) of all the months but I don't want to hardcode any values in the report because it should run irrespective of any year.
Result looks like this...

Jan,09 Feb,09..... Dec,09 YTD

I don't have access to the rpd file.
Please help me out at the earliest. If any of you have a diffrent approach to resolve this please let me know.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 3 2009

Added on Jul 6 2009

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

0 comments

302 views