Insert Row/Column in-between sections in the OAC Workbook

Vaigu_27

Hello experts,

Is there a way to insert (Empty or Calculated) Row/Column between section in the OAC DV Workbook to replicate the financial statement reports with custom row & Formula column.

Thanks,

Vaigu

BalagurunathanBagavathy-Oracle

@Vaigu_27

Thanks for sharing the screenshot. I got your requirement. This feature is not yet available in DV. Please upvote the idea below:

https://community.oracle.com/products/oracleanalytics/discussion/10668/make-calculated-items-groups-features-available-in-dv

BalagurunathanBagavathy-Oracle

@Vaigu_27

You can try creating a calculation with an expression ' ' to get a empty row / column.

Regards,

Bala.

Vaigu_27

@BalagurunathanBagavathy-Oracle ,

Is this can be achieved in the below OAC Workbook?

Vaigu

BalagurunathanBagavathy-Oracle

@Vaigu_27 Yes, we can create a dummy calculation with an expression ' ' in DV Workbook.

Vaigu_27

@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