Forum Stats

  • 3,874,599 Users
  • 2,266,752 Discussions
  • 7,911,910 Comments

Discussions

Grand total in Pivot view in OBIEE

Dev
Dev Member Posts: 223 Bronze Badge
Hi

I have a requirement to show a particulra report in a pivot view whereby I have to keep the yearly values in the "ROWS" portion and the monthly capex values in the "Measures" portion.

The problem is when I am using the grand total functionality, the grand total is coming only for the monthly values which have kept in the "Measures" and not for the yearly capex values in Rows portion even though the aggregation rule is set as "sum".

I have to show the grand total for the yealy capex value as well.
Tagged:

Answers

This discussion has been closed.