We are using Live Connection to create the story. Data source Type - Custom CDS based on Standard CDS View.
The requirement is to include calculated rows in-between the dynamic rows.
We have Measures in the column, Dimensions - Reporting Item and Profit Center in the row.
We are achieving the calculated rows using the direct formula by cell reference.
The issue is that we are able to insert the formulas in the cells of the rows that are included at the end of the table, but unable to do so in the rows inserted in-between the table.
Any insights would be helpful.