Oracle Analytics Cloud and Server

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

Column heading for the previous year date

Received Response
1
Views
3
Comments
User_JL3CW
User_JL3CW Rank 6 - Analytics Lead

Hi,

There is a report requirement which has dashboard prompt with date(calender).

Date entered as for eg: 12/29/2016.

In my report i have two columns current year date and previous year date.

I have PV (Day_PV), which holds the date entered.

In column heading for the current year date i have written: @{Day_PV}  --- working fine  (displays 12/29/2016).

In column heading for the previous year date i should display (12/29/2015).

I tried the following in the column heading:

TIMESTAMPADD( SQL_TSI_YEAR , -1, Date '@{PDayPV}{2016-03-03}'). But it is not evaluating.

Is there any other way to get this one?

Regards,

Ram.

Answers