Oracle Analytics and AI

User_97XVQ

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

Gianni Ceresa

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.