My Oracle Support Banner

PIVOT Table Limitation Compared With Crystal (Doc ID 2525285.1)

Last updated on DECEMBER 05, 2019

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.5.0 to 11.1.1.9.x [Release 11.1]
Information in this document applies to any platform.

Goal

Is there a field count limitation on Pivot table?

While converting Crystal templates to XML Publisher, not able to achieve the same output like crystal report.

1. Not able to use Multiple Aggregation Function in Pivot chart (Sum and Count). attached the Pivot Table_usage of both COUNT and SUM.docx
2. Not able to use Distinct for the Count Aggregation Function (Remove the Duplicate count).
3. Not able to user more than 6 fields in Pivot Table. can you please tell me how to increase.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.