Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Year Ago Sum of Points

Received Response
1
Views
2
Comments
Nikhila reddy
Nikhila reddy Rank 4 - Community Specialist
in Oracle Business Intelligence Applications Forum

Hi There,

report has prompt to date and from date.

here my report requirement to get Sum(points) for the selected range and the same range date exact last yera.

for example FromDate: 13th sep 2017  ToDate: 15th Nov 2017

pastedImage_1.png

Current Year should display Sum(points) between FromDate: 13th sep 2017  ToDate: 15th Nov 2017 these dates.

Year Ago should display Sum(Points) between FromDate: 13th sep 2016  ToDate: 15th Nov 2016 these dates.

Can anyone Help me out from this.

Thanks in advance

Nikhila

Answers