Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE 12c - How to do Row Totals?

I was wondering if I wanted to create ROW level totals, how would I go about doing this?

For example

Jan Feb Mar Row Total

A 5 6 4 15

B 1 2 3 6

C 0 7 5 12

Total 6 15 12 33

I know at the bottom its easy to add a "Grand Total"

What I am trying to do is calculate based on the rows and get a row total

How would I go about doing this?

Find more posts tagged with

Accepted answers

All comments

What about using a pivot table view?

With a pivot it's like the grand total: 1 click

Martin van Donselaar

You might want to have a look here: http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1221/cad/cad12c.html

Much thanks! I was trying to cram this in for a deadline and totally over looked these suggestions

Hi,

Did you get any workaround for achieving above total results? Kindly post.

Thank You.

It's an almost 6 years old abandoned thread. Some solutions are posted in the thread but OP never came back.

If you have an issue you can't solve, post a new question giving the details of your question, you will get more replies that way (providing your exact product name and version and an example of you try to achieve etc.).

Ok..Thank You.