Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Aggregation rules and pivot tables

12663Feb 26 2009 — edited Feb 26 2009

I have 3 measures in a pivot table out which 2 have aggregation rule set to SUM. The third measure has aggregation rule set to NONE.
Although the third measure is a number I do not wish to show a grand total as it is the value in local currency and hence not additive as different regions have different currencies.

However the Pivot table does not display the values of the third measure if the aggregation rule is set to NONE. The cells are blank.

Is this expected behavior ? Can I over-ride this behavior ?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2009

Added on Feb 26 2009

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

5 comments

494 views