OBIEE12.2.1.4.0 - Can we achieve this in BI Answers

Question

Dear Experts,

We are using OBIEE 12.2.1.4.0 on Linux environment. this is a brand new install with no patches applied. We are trying to meet an expectation on a report, but not sure if it can be done with BI Answers. What is required is highlighted in Yellow .

Please suggest how we can achieve this .

Thanks in Advance.

Rakesh

3822729 · Answer

Thanks Gianni, I wili try this option and see if I can the delta in a cell. will test this and get back.

3822729 · Answer

Thanks Christian. Will try your suggestion and get back..

Gianni Ceresa · Answer

You create formula giving the total amount on the left, you subtract a formula giving you the total amount on the right and you have your number in a cell. You can then use a narrative view to display it the way you prefer.

Grand total in pivot views are automatically calculated by OBIEE aggregating at the required level the column you have. If you do the same yourself by hand using AGGREGATE(... AT ...) you can achieve the exact same calculation and get by a single formula the virtual total OBIEE shows in a table or pivot view.

EDIT: Or what Christian said if you have access to the RPD