I will try this one as well and we have approached another way like adding year ago wid in day dimension. @Regis Peregrin Thank you

It did not worked out @Regis Peregin .It does not allow to add like that The starting Point of Period rolling function is larger than the End point.

Christian Berg & @Gianni Ceresa

Christian Berg , Is there a way that I can restrict to display 2013 Q1, 2013 Q2, 2013 Q3, 2013 Q4 only once during the start of the quarter. I also tried the above way but period is displaying multiple times.

I want to reiterate the issue @Christian. We already had a time dimension If I added Period the data is summing up and showing as month wise data, But I should show up Graph with date and X-axis Label like period.

Thank you @Gianni Ceresa. Now, the it is connecting to the database.

TNSNAMES.ORA file is not available in that location. I have manually added but it did not worked out.

H @Jerry Casey For Example: I have date records from 2019 May to 2020 DEC. There will be no filters in report. When I execute report it should pick Current date Mar-12-2020 and it should populate till 12 weeks(MAR-MAY results) + 13 week(Rest from May to till DEC) it should fall in 13th bucket.Before Mar-2020 (i.e 2019 May…

Hi @Jerry Casey, Thank you for the immediate response. I can able to achieve it from the above logic, The thing is that I did not have any filters on report but whenever a report executes it should display the Current_date + 12 weeks data + 13th week data.For suppose I just added Award Date greater than 12/4/19 which it…

Hi @Jerry Casey, I have misinterpreted the logic. For Example If Award Date is 1/9/2020 the week data 5766239.14 value should fall under 5 - Jan Bucket which is a Sunday Label.(It should fall under Previous Bucket). The logic should be implemented with Current_date & Award Date.I want to display only 12 weeks from Current…