Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

Analytics OTBI - Get YTD, Previous Period and Previous Year Period values

Question
21
Views
0
Comments
Sílvia Ganhão
Sílvia Ganhão Rank 1 - Community Starter
in Oracle Business Intelligence Applications

Hi,

I've attached an excel with examples of what I want to achieve.

In OTBI I want to achieve columns:

1 - VALUE YTD;

2 - VALUE PREVIOUS PERIOD;

3 - VALUE PREVIOUS YEAR PERIOD.

For example:

1

When: jun-2018

Expected: Value of jan-2018 + feb-2018 + mar-2018 + apr-2018 + may-2018 + jun-2018

2

When: jun-2018

Expected: Value of jun-2017

3

When: jun-2018

Expected: Value of may-2018

Can you help?

Thanks,

Sílvia Ganhão