Is it possible within Appian to effectively insert aggregated rows.

Hi All,
We're looking to expand the use of Reports within Appian, however I'm looking to confirm if it's possible to effectively do row level calculations on the datasubset.

Eg imagine you have a P&L report which contains a grid with columns (month, year to date, vs last year, vs budget)

And Rows 4 rows of P&L summary lines (eg sales, discounts, cost of sales, profits)

Is it possible within Appian to effectively insert aggregated rows. Eg Row 1 =Sales, 2 =Discounts, 3 =net sales, 4 = 1-2- cost of sales = margin, 5= profit

The calcs aren't important, just the principle of cdt manipulation and not just appending a "total row" on.

Thanks

OriginalPostID-178750

OriginalPostID-178750