Analytics Software

Hello OBI Gurus,

I need some help. We have a report that requires what I call 'Custom Subtotals' -- i.e. I need the subtotal values to point to a different column than the one it belongs to.

For example, in a database table I have 4 columns: [Parent Entity], [Child Entity], [Parent Limit], [Child Limit]. The [Child Entity] column rolls up to the [Parent Entity] Column. In my OBI report, I need one column called 'Limit'.. And it should display [Child Limit] at the [Child Entity] Level, but it should display [Parent Limit] at the [Parent Limit] Subtotal. In this example, the subtotal is not the sum of the child limits, it is a completely separate number in the database.

Thank you,
Elliot