Oracle Analytics and AI

Vineela1

Version:12.2.1.2.0

My requirement is to subtract two sub totals and show it in the analysis.

I have 2 account types like Expense,Revenue The grand total should be Total Revenue less expense.. Please let me know if it is possible & how can i achieve it ?

Thanks in advance

Gianni Ceresa

If "grant total" is the automated totals you enable at the view level, the aggregation works in a single way for all the rows.

If you use something like Essbase where you defined your accounts dimension, you can set aggregation rules for every account at any level of the hierarchy.

If you don't have that kind of source, you could replace the automated grant totals with calculated items where you set yourself the rules.