@Christian Berg -Oracle This is only for my learning/understanding and for future implementation … I took a scenario and trying to implement the same

Thank you for the reply @Gianni Ceresa Yes I would you like to see them as rows.. a table with 4 columns and 6 + 6*3 rows. Like to know how this can be achieved … Thanks for the hint, 1st solution about BMM layer RPD change I will try to implement.. But like to know how it can be done on front end (analysis/dashboard).

@Gianni Ceresa thank you for the reply I want to setup this in classic BI, By default, data for all the years and months is displayed on Tabular format. as shown in the screenshot below if I select March I like to display Previous 3 months (including previous year's December months too) if I select April then Month and…

HI @SteveF-Oracle Many Thanks to you for the reply and going through all this, Awesome, Due to limited resources, I couldn't try this. I'm closing the thread.

Thank you Gianni for the response,