CODEWITHSUNDEEP
obiee
Hoang Nguyen
Hoang Nguyen

Reputation: 61

OBIEE how to modify analysis table

I have an analyis pivot table

enter image description here

and here is the result

enter image description here

Is there any way to modidify this analysis pivot table to be like this:
enter image description here

Upvotes: 0

Views: 203

Answers (1)

mona16
mona16

Reputation: 46

enter image description here

Please see the above image.

  • Create the sum in criteria itself.
  • In column labels click on that summation and select none.
  • Create a dummy column having string 'Total', and arrange everything like below image.

Upvotes: 1

Related Questions