@Shankar-Oracle , have clearly explained our problem & steps we are following. Step 1: Our Dashboard layout with Prompt & Report where all column width are fitting to its content for Cost Center & Division Description Report output looks good in Web Interface Step 2: We are facing issues while exporting results to excel,…

@Silvio Garber-Oracle, I have created AGO function with the above mentioned steps, if i try to pull created column in report, select Jan-24 in the column prompt , Dec-23 column shows empty in the report. Thanks, Vaigu

@BalagurunathanBagavathy-Oracle , Thank you for the response, i have accepted the answer. Just wanted to know is there a way to group columns apart from Union Query. Do post your thoughts on this.

@BalagurunathanBagavathy-Oracle , Thanks much we could achieve our layout with your mentioned approach. Is there a way we can bring this layout without Union Query ?

@Raghavendra Raghunath-Oracle @BalagurunathanBagavathy-Oracle , In the Out of Box Financials - GL Balance Sheet Subject Area has Time.Fiscal Period values in Jan-23..Dec-23 format I have created a Parameter to select the Month Value, since Month is at Varchar Jan-23,Feb-23 Created Expression Filter using below syntax to…

@BalagurunathanBagavathy-Oracle Our requirement to display last 12 months of Actual values based on monthly prompt selection from users, hence tried with Filter & Parameter. please advise on any alternate approach to attain this , Financials - Balance SHeet doesn't have Fiscal Date has only Fiscal period, wrote the…

@Raghavendra Raghunath-Oracle @BalagurunathanBagavathy-Oracle , As suggested used a 'Dashboard Filter ' Visual in DV, created a Bind Parameter for Fiscal Period, modified parameter with below expression, getting below error in the screenshot "Financials - GL Balance Sheet"."Time"."Fiscal Period" <=…

@BalagurunathanBagavathy-Oracle Once i create a Formula Row for Total Assets = (101060+101200+104010) & Total Liabilities = (112900+114030+117000+118000), can we insert the calculated rows in between accounts as shown in the below image. Total Assets Row after 104010 Total Liabilities after 118000 Thanks, Vaigu

@BalagurunathanBagavathy-Oracle , Is this can be achieved in the below OAC Workbook? Vaigu

@Raghavendra Raghunath-Oracle I tried to create this filter in DV Workbook couldn't proceed much, is there any documents/blog available to implement this Additionally do you think with this approach we can display 12 months of actuals based on the current period selection Vaigu