Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OBIEE Pivot Table - Adding grand total to non-measures
User_97XVQ
Rank 3 - Community Apprentice
Hi,
I am using OBIEE 11.1.1.7.16 and working on a pivot table request
Is it possible to generate a grand total for non measure values that are unpivot in the view?
For example:
Total Amount - 103,810
Is it possible to have a grand total for Total Amount?
| ID | Product | Product Name | Total Amount | Customer | 05/2017 | 06/2017 | 07/2017 | 08/2017 |
| 100 | 123 | 03084062 | 29,000.00 | XYZ | 300 | 200 | 100 | 900 |
| 100 | 1234 | 03084063 | 74,810.00 | XYZ | 133 | 344 | 545 | 545 |
| 100 Total | 433 | 544 | 645 | 1445 |
0
Answers
-
Hi,
Grand totals requires a formula/aggregation to know how to calculate it, that's why they work on measures as there is a default aggregation defined in the RPD.
If you want to sum "total amount" (why isn't it already a measure?) you need to make it an aggregation and place it into the measures area.
Or edit the formula to add the "SUM" there directly and you can keep it at the rows level.
0
